PREVIEW / etf_30min / 2011-08-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-26.parquet
  size:    278 KB
  rows:    9,299

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-08-26 04:00:00	SPY	ETF	116.4	116.43	116.4	116.43	600.0
2011-08-26 04:30:00	SPY	ETF	116.65	116.72	116.38	116.41	10100.0
2011-08-26 05:00:00	SPY	ETF	116.47	116.47	116.47	116.47	200.0
2011-08-26 05:30:00	SPY	ETF	116.56	116.63	116.43	116.43	2600.0
2011-08-26 06:00:00	SPY	ETF	116.41	116.41	116.26	116.26	3200.0
2011-08-26 06:30:00	SPY	ETF	116.26	116.46	116.26	116.37	3100.0
2011-08-26 07:00:00	SPY	ETF	116.4	116.42	116.06	116.19	180525.0
2011-08-26 07:30:00	SPY	ETF	116.16	116.16	115.82	116.09	309788.0
2011-08-26 08:00:00	SPY	ETF	116.09	116.12	115.7	115.97	1480936.0
2011-08-26 08:30:00	SPY	ETF	115.85	116.31	115.22	115.35	3134130.0
2011-08-26 09:00:00	SPY	ETF	115.37	115.79	115.2	115.7	2288754.0
2011-08-26 09:30:00	SPY	ETF	115.69	115.93	114.96	115.47	27897721.0
2011-08-26 10:00:00	SPY	ETF	115.47	116.3	113.85	115.82	64212108.0
2011-08-26 10:30:00	SPY	ETF	115.83	117.13	115.31	116.29	38200561.0
2011-08-26 11:00:00	SPY	ETF	116.29	117.68	116.07	116.9525	24691794.0
2011-08-26 11:30:00	SPY	ETF	116.94	117.52	116.92	117.41	11797336.0
2011-08-26 12:00:00	SPY	ETF	117.4	118.43	117.4	118.28	19130896.0
2011-08-26 12:30:00	SPY	ETF	118.265	118.31	117.63	117.93	12070743.0
2011-08-26 13:00:00	SPY	ETF	117.93	118.31	117.7	118.28	7221833.0
2011-08-26 13:30:00	SPY	ETF	118.29	118.51	118.12	118.36	9409872.0
2011-08-26 14:00:00	SPY	ETF	118.37	118.5	117.67	117.715	12442784.0
2011-08-26 14:30:00	SPY	ETF	117.72	118.11	117.58	117.98	10882422.0
2011-08-26 15:00:00	SPY	ETF	117.985	118.0	117.19	117.48	15099079.0
2011-08-26 15:30:00	SPY	ETF	117.48	118.07	117.39	117.97	27406108.0
2011-08-26 16:00:00	SPY	ETF	117.96	118.34	116.2911	118.06	20259298.0
2011-08-26 16:30:00	SPY	ETF	118.06	118.17	116.2911	118.09	2692691.0
2011-08-26 17:00:00	SPY	ETF	118.09	118.17	118.07	118.1	65457.0
2011-08-26 17:30:00	SPY	ETF	118.11	118.18	118.05	118.13	15045.0
2011-08-26 18:00:00	SPY	ETF	118.1	118.13	117.91	118.09	179734.0
2011-08-26 18:30:00	SPY	ETF	118.04	118.16	118.04	118.08	11593.0
2011-08-26 19:00:00	SPY	ETF	118.11	118.16	118.09	118.1	8302.0
2011-08-26 19:30:00	SPY	ETF	118.11	118.22	118.11	118.22	26715.0
2011-08-26 05:30:00	QQQ	ETF	52.0	52.0	52.0	52.0	500.0
2011-08-26 06:00:00	QQQ	ETF	51.9	51.9	51.9	51.9	200.0
2011-08-26 07:00:00	QQQ	ETF	51.89	51.95	51.83	51.84	2821.0
2011-08-26 07:30:00	QQQ	ETF	51.86	51.86	51.73	51.82	33700.0
2011-08-26 08:00:00	QQQ	ETF	51.83	51.85	51.69	51.83	170190.0
2011-08-26 08:30:00	QQQ	ETF	51.78	51.83	51.49	51.54	349559.0
2011-08-26 09:00:00	QQQ	ETF	51.55	51.74	51.49	51.68	555506.0
2011-08-26 09:30:00	QQQ	ETF	51.68	51.9	51.45	51.67	9558305.0
2011-08-26 10:00:00	QQQ	ETF	51.67	52.41	51.15	52.17	22109393.0
2011-08-26 10:30:00	QQQ	ETF	52.1779	52.79	51.93	52.37	14231360.0
2011-08-26 11:00:00	QQQ	ETF	52.36	52.97	52.27	52.66	7095133.0
2011-08-26 11:30:00	QQQ	ETF	52.655	52.86	52.63	52.819	2866292.0
2011-08-26 12:00:00	QQQ	ETF	52.82	53.19	52.82	53.17	4956946.0
2011-08-26 12:30:00	QQQ	ETF	53.17	53.18	52.9002	53.0	2559565.0
2011-08-26 13:00:00	QQQ	ETF	52.99	53.149	52.89	53.13	1970013.0
2011-08-26 13:30:00	QQQ	ETF	53.1316	53.28	53.11	53.25	2585529.0
2011-08-26 14:00:00	QQQ	ETF	53.25	53.31	52.99	53.01	2982621.0
2011-08-26 14:30:00	QQQ	ETF	53.01	53.19	52.94	53.14	2752022.0

> showing 50 of 9,299 rows — these rows as CSV

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