PREVIEW / etf_30min / 2011-08-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-18.parquet
  size:    305 KB
  rows:    10,346

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-18 04:00:00	SPY	ETF	118.35	118.35	118.01	118.32	17794.0
2011-08-18 04:30:00	SPY	ETF	118.29	118.29	117.7	117.81	23500.0
2011-08-18 05:00:00	SPY	ETF	117.73	117.73	117.0	117.18	87319.0
2011-08-18 05:30:00	SPY	ETF	117.14	117.55	117.04	117.4	164213.0
2011-08-18 06:00:00	SPY	ETF	117.48	117.54	117.25	117.25	84239.0
2011-08-18 06:30:00	SPY	ETF	117.3	117.52	117.05	117.46	172890.0
2011-08-18 07:00:00	SPY	ETF	117.43	117.72	117.38	117.5	613535.0
2011-08-18 07:30:00	SPY	ETF	117.46	117.5	117.11	117.11	791812.0
2011-08-18 08:00:00	SPY	ETF	117.15	118.0	117.0	117.1	1544176.0
2011-08-18 08:30:00	SPY	ETF	117.14	117.14	116.65	116.73	5040543.0
2011-08-18 09:00:00	SPY	ETF	116.75	116.92	116.33	116.51	4880443.0
2011-08-18 09:30:00	SPY	ETF	116.5	116.64	115.52	115.72	52314580.0
2011-08-18 10:00:00	SPY	ETF	115.72	115.72	113.68	114.89	70075589.0
2011-08-18 10:30:00	SPY	ETF	114.89	115.02	114.2	114.92	34291210.0
2011-08-18 11:00:00	SPY	ETF	114.92	115.03	114.3	114.6484	26650485.0
2011-08-18 11:30:00	SPY	ETF	114.64	115.37	114.57	115.26	22259566.0
2011-08-18 12:00:00	SPY	ETF	115.26	119.714	114.76	115.12	20706506.0
2011-08-18 12:30:00	SPY	ETF	115.12	115.25	114.71	114.88	11367321.0
2011-08-18 13:00:00	SPY	ETF	114.875	114.98	114.29	114.5	17379353.0
2011-08-18 13:30:00	SPY	ETF	114.5	119.714	113.93	114.13	26650532.0
2011-08-18 14:00:00	SPY	ETF	114.13	114.95	114.1	114.6	21009133.0
2011-08-18 14:30:00	SPY	ETF	114.6	114.8	113.85	113.87	21344042.0
2011-08-18 15:00:00	SPY	ETF	113.86	119.714	113.51	114.13	41671737.0
2011-08-18 15:30:00	SPY	ETF	114.13	114.79	113.39	114.405	72150755.0
2011-08-18 16:00:00	SPY	ETF	114.59	119.714	113.6	114.93	29267938.0
2011-08-18 16:30:00	SPY	ETF	114.92	119.714	114.0	114.85	15831719.0
2011-08-18 17:00:00	SPY	ETF	114.86	119.714	114.4	114.93	5773328.0
2011-08-18 17:30:00	SPY	ETF	114.95	114.95	114.79	114.79	3707506.0
2011-08-18 18:00:00	SPY	ETF	114.79	114.86	114.61	114.76	207343.0
2011-08-18 18:30:00	SPY	ETF	114.76	115.0	114.73	114.94	111186.0
2011-08-18 19:00:00	SPY	ETF	114.99	115.02	114.48	114.49	110702.0
2011-08-18 19:30:00	SPY	ETF	114.5	114.57	114.19	114.24	416684.0
2011-08-18 04:00:00	QQQ	ETF	53.18	53.18	52.77	52.79	4389.0
2011-08-18 04:30:00	QQQ	ETF	52.74	52.74	52.54	52.54	871.0
2011-08-18 05:00:00	QQQ	ETF	52.33	52.37	52.22	52.28	7000.0
2011-08-18 05:30:00	QQQ	ETF	52.22	52.44	52.22	52.44	22700.0
2011-08-18 06:00:00	QQQ	ETF	52.42	52.47	52.36	52.36	2900.0
2011-08-18 06:30:00	QQQ	ETF	52.34	52.4	52.3	52.37	136350.0
2011-08-18 07:00:00	QQQ	ETF	52.4	52.49	52.4	52.42	148490.0
2011-08-18 07:30:00	QQQ	ETF	52.42	52.42	52.25	52.28	627388.0
2011-08-18 08:00:00	QQQ	ETF	52.29	52.42	52.24	52.36	859119.0
2011-08-18 08:30:00	QQQ	ETF	52.36	52.38	52.16	52.25	710552.0
2011-08-18 09:00:00	QQQ	ETF	52.25	52.32	52.05	52.13	1768463.0
2011-08-18 09:30:00	QQQ	ETF	52.13	52.14	51.42	51.45	18027710.0
2011-08-18 10:00:00	QQQ	ETF	51.45	51.45	50.72	51.2495	20702720.0
2011-08-18 10:30:00	QQQ	ETF	51.25	51.33	50.95	51.27	8838892.0
2011-08-18 11:00:00	QQQ	ETF	51.27	51.31	51.03	51.145	6227055.0
2011-08-18 11:30:00	QQQ	ETF	51.15	51.505	51.13	51.47	6774157.0
2011-08-18 12:00:00	QQQ	ETF	51.47	51.62	51.24	51.45	6097394.0
2011-08-18 12:30:00	QQQ	ETF	51.45	51.48	51.27	51.34	3258563.0

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

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