PREVIEW / etf_30min / 2011-02-22

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-22.parquet
  size:    306 KB
  rows:    10,243

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-02-22 04:00:00	SPY	ETF	133.49	133.49	132.48	132.68	24599.0
2011-02-22 04:30:00	SPY	ETF	132.8	132.82	132.7	132.7	1800.0
2011-02-22 05:00:00	SPY	ETF	132.72	132.73	132.55	132.65	30418.0
2011-02-22 05:30:00	SPY	ETF	132.72	132.93	132.72	132.93	9700.0
2011-02-22 06:00:00	SPY	ETF	132.98	133.03	132.8	132.82	76450.0
2011-02-22 06:30:00	SPY	ETF	132.84	132.93	132.82	132.87	134531.0
2011-02-22 07:00:00	SPY	ETF	132.87	133.05	132.86	133.05	438559.0
2011-02-22 07:30:00	SPY	ETF	133.05	133.16	133.03	133.15	544789.0
2011-02-22 08:00:00	SPY	ETF	133.16	134.15	132.66	133.11	2411575.0
2011-02-22 08:30:00	SPY	ETF	133.12	133.3497	133.05	133.16	1105824.0
2011-02-22 09:00:00	SPY	ETF	133.18	134.57	133.06	133.12	1380690.0
2011-02-22 09:30:00	SPY	ETF	133.12	133.62	132.75	133.6	27081123.0
2011-02-22 10:00:00	SPY	ETF	133.6	133.86	133.4	133.5095	19643063.0
2011-02-22 10:30:00	SPY	ETF	133.51	133.74	133.41	133.54	8816838.0
2011-02-22 11:00:00	SPY	ETF	133.55	133.57	133.0	133.17	16081516.0
2011-02-22 11:30:00	SPY	ETF	133.17	133.18	132.68	132.8	13180347.0
2011-02-22 12:00:00	SPY	ETF	132.81	132.84	132.55	132.7	11874149.0
2011-02-22 12:30:00	SPY	ETF	132.7093	132.72	132.01	132.13	16672419.0
2011-02-22 13:00:00	SPY	ETF	132.13	132.28	131.771	131.93	13073234.0
2011-02-22 13:30:00	SPY	ETF	131.93	132.07	131.73	131.97	11461195.0
2011-02-22 14:00:00	SPY	ETF	131.96	134.5615	131.75	132.04	12354559.0
2011-02-22 14:30:00	SPY	ETF	132.04	132.85	131.86	131.91	11326317.0
2011-02-22 15:00:00	SPY	ETF	131.91	132.01	131.47	131.531	17081134.0
2011-02-22 15:30:00	SPY	ETF	131.55	131.84	131.48	131.83	25965363.0
2011-02-22 16:00:00	SPY	ETF	131.83	134.5615	131.78	131.8	14511747.0
2011-02-22 16:30:00	SPY	ETF	131.8	131.89	131.79	131.82	4439887.0
2011-02-22 17:00:00	SPY	ETF	131.82	134.5615	131.68	131.68	1096042.0
2011-02-22 17:30:00	SPY	ETF	131.72	131.81	131.67	131.72	54141.0
2011-02-22 18:00:00	SPY	ETF	131.7	131.87	131.67	131.83	63738.0
2011-02-22 18:30:00	SPY	ETF	131.81	132.0	131.81	131.96	64925.0
2011-02-22 19:00:00	SPY	ETF	131.97	132.09	131.93	132.08	145507.0
2011-02-22 19:30:00	SPY	ETF	132.05	132.15	132.02	132.15	53257.0
2011-02-22 04:00:00	QQQ	ETF	57.94	57.94	57.8	57.82	47500.0
2011-02-22 05:00:00	QQQ	ETF	57.82	57.82	57.81	57.81	200.0
2011-02-22 05:30:00	QQQ	ETF	57.88	57.95	57.88	57.94	9715.0
2011-02-22 06:00:00	QQQ	ETF	57.95	57.95	57.87	57.87	23300.0
2011-02-22 06:30:00	QQQ	ETF	57.87	57.88	57.84	57.88	31152.0
2011-02-22 07:00:00	QQQ	ETF	57.88	58.0	57.88	58.0	166843.0
2011-02-22 07:30:00	QQQ	ETF	58.02	58.08	57.99	58.05	151960.0
2011-02-22 08:00:00	QQQ	ETF	58.14	58.15	57.92	57.97	1724354.0
2011-02-22 08:30:00	QQQ	ETF	57.96	58.03	57.93	58.01	158644.0
2011-02-22 09:00:00	QQQ	ETF	58.02	58.03	57.93	57.99	1151260.0
2011-02-22 09:30:00	QQQ	ETF	57.99	58.0	57.51	57.94	18092917.0
2011-02-22 10:00:00	QQQ	ETF	57.94	58.12	57.77	58.01	6427698.0
2011-02-22 10:30:00	QQQ	ETF	58.01	58.13	57.95	58.02	3393693.0
2011-02-22 11:00:00	QQQ	ETF	58.02	58.04	57.64	57.78	7181804.0
2011-02-22 11:30:00	QQQ	ETF	57.79	57.81	57.6	57.66	5576514.0
2011-02-22 12:00:00	QQQ	ETF	57.66	57.69	57.55	57.6	2405772.0
2011-02-22 12:30:00	QQQ	ETF	57.6	57.6199	57.19	57.241	5558721.0
2011-02-22 13:00:00	QQQ	ETF	57.24	57.35	57.14	57.22	4597690.0

> showing 50 of 10,243 rows — these rows as CSV

> unlock the full archive -- $79 one-time