PREVIEW / etf_30min / 2012-07-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-20.parquet
  size:    276 KB
  rows:    9,356

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
2012-07-20 04:00:00	SPY	ETF	137.51	137.51	137.51	137.51	1000.0
2012-07-20 04:30:00	SPY	ETF	137.45	137.58	137.45	137.58	5400.0
2012-07-20 05:00:00	SPY	ETF	137.59	137.59	137.59	137.59	200.0
2012-07-20 05:30:00	SPY	ETF	137.61	137.61	137.45	137.45	1450.0
2012-07-20 06:00:00	SPY	ETF	137.31	137.4	137.18	137.29	30004.0
2012-07-20 06:30:00	SPY	ETF	137.3	137.3	137.18	137.25	29080.0
2012-07-20 07:00:00	SPY	ETF	137.25	137.32	137.21	137.25	54159.0
2012-07-20 07:30:00	SPY	ETF	137.26	137.26	136.85	136.93	465173.0
2012-07-20 08:00:00	SPY	ETF	136.97	137.26	136.84	136.89	558827.0
2012-07-20 08:30:00	SPY	ETF	136.89	136.96	136.78	136.96	725374.0
2012-07-20 09:00:00	SPY	ETF	136.96	137.03	136.8	136.95	1706754.0
2012-07-20 09:30:00	SPY	ETF	136.95	137.1442	136.74	136.93	22934789.0
2012-07-20 10:00:00	SPY	ETF	136.94	137.16	136.86	137.0	12165331.0
2012-07-20 10:30:00	SPY	ETF	137.0	137.02	136.67	136.96	8216667.0
2012-07-20 11:00:00	SPY	ETF	136.97	137.13	136.77	136.94	10488168.0
2012-07-20 11:30:00	SPY	ETF	136.93	136.99	136.66	136.83	6207295.0
2012-07-20 12:00:00	SPY	ETF	136.83	136.84	136.51	136.58	7185586.0
2012-07-20 12:30:00	SPY	ETF	136.575	136.69	136.37	136.65	7126302.0
2012-07-20 13:00:00	SPY	ETF	136.6501	136.71	136.33	136.43	5101720.0
2012-07-20 13:30:00	SPY	ETF	136.43	136.59	136.42	136.55	8073705.0
2012-07-20 14:00:00	SPY	ETF	136.54	136.69	136.48	136.48	4649889.0
2012-07-20 14:30:00	SPY	ETF	136.47	136.5	136.37	136.43	5606931.0
2012-07-20 15:00:00	SPY	ETF	136.43	136.6	136.41	136.4975	5435813.0
2012-07-20 15:30:00	SPY	ETF	136.499	136.58	136.32	136.46	21873186.0
2012-07-20 16:00:00	SPY	ETF	136.47	137.0059	136.32	136.37	10694541.0
2012-07-20 16:30:00	SPY	ETF	136.37	136.48	136.34	136.37	892185.0
2012-07-20 17:00:00	SPY	ETF	136.4	136.42	136.34	136.38	22324.0
2012-07-20 17:30:00	SPY	ETF	136.38	136.4	136.37	136.37	14987.0
2012-07-20 18:00:00	SPY	ETF	136.4	136.4	136.28	136.34	38692.0
2012-07-20 18:30:00	SPY	ETF	136.32	136.37	136.3	136.3	10265.0
2012-07-20 19:00:00	SPY	ETF	136.3	136.33	136.27	136.3	25966.0
2012-07-20 19:30:00	SPY	ETF	136.33	136.4	136.33	136.35	10195.0
2012-07-20 04:00:00	QQQ	ETF	65.19	65.25	65.19	65.25	600.0
2012-07-20 05:30:00	QQQ	ETF	65.27	65.27	65.27	65.27	800.0
2012-07-20 06:30:00	QQQ	ETF	65.13	65.13	65.11	65.11	1200.0
2012-07-20 07:00:00	QQQ	ETF	65.12	65.12	65.12	65.12	2000.0
2012-07-20 07:30:00	QQQ	ETF	65.11	65.11	64.97	65.02	73493.0
2012-07-20 08:00:00	QQQ	ETF	65.01	65.03	64.94	64.95	42525.0
2012-07-20 08:30:00	QQQ	ETF	64.94	64.97	64.91	64.97	115865.0
2012-07-20 09:00:00	QQQ	ETF	65.0	65.09	64.93	65.08	750414.0
2012-07-20 09:30:00	QQQ	ETF	65.09	65.1	64.71	64.845	5584462.0
2012-07-20 10:00:00	QQQ	ETF	64.84	65.02	64.79	64.89	2757597.0
2012-07-20 10:30:00	QQQ	ETF	64.89	64.9	64.6	64.79	3408935.0
2012-07-20 11:00:00	QQQ	ETF	64.8	64.9	64.63	64.7118	3972095.0
2012-07-20 11:30:00	QQQ	ETF	64.71	64.73	64.51	64.59	2243607.0
2012-07-20 12:00:00	QQQ	ETF	64.58	64.585	64.4	64.42	2336927.0
2012-07-20 12:30:00	QQQ	ETF	64.42	64.54	64.34	64.52	1483275.0
2012-07-20 13:00:00	QQQ	ETF	64.52	64.56	64.36	64.42	1668651.0
2012-07-20 13:30:00	QQQ	ETF	64.42	64.49	64.35	64.451	968624.0
2012-07-20 14:00:00	QQQ	ETF	64.46	64.53	64.43	64.44	1148969.0

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

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