PREVIEW / etf_30min / 2012-11-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-14.parquet
  size:    303 KB
  rows:    10,154

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-11-14 04:00:00	SPY	ETF	138.36	138.6	138.36	138.6	1902.0
2012-11-14 04:30:00	SPY	ETF	138.68	138.82	138.68	138.8	700.0
2012-11-14 05:00:00	SPY	ETF	138.69	138.71	138.48	138.5	30200.0
2012-11-14 05:30:00	SPY	ETF	138.55	138.55	138.4	138.44	900.0
2012-11-14 06:00:00	SPY	ETF	138.33	138.48	138.3	138.43	51865.0
2012-11-14 06:30:00	SPY	ETF	138.44	138.45	138.22	138.45	70680.0
2012-11-14 07:00:00	SPY	ETF	138.4	138.47	138.17	138.23	124666.0
2012-11-14 07:30:00	SPY	ETF	138.23	138.31	138.02	138.1	181872.0
2012-11-14 08:00:00	SPY	ETF	138.42	138.48	138.01	138.3	1955650.0
2012-11-14 08:30:00	SPY	ETF	138.27	138.34	138.0	138.18	1980964.0
2012-11-14 09:00:00	SPY	ETF	138.18	138.39	138.11	138.21	652205.0
2012-11-14 09:30:00	SPY	ETF	138.21	138.43	137.77	137.87	14102688.0
2012-11-14 10:00:00	SPY	ETF	137.865	138.09	137.36	137.37	14449560.0
2012-11-14 10:30:00	SPY	ETF	137.37	137.48	136.91	137.081	18039121.0
2012-11-14 11:00:00	SPY	ETF	137.085	137.43	136.88	137.37	11121496.0
2012-11-14 11:30:00	SPY	ETF	137.3699	137.54	137.08	137.4801	8083102.0
2012-11-14 12:00:00	SPY	ETF	137.49	137.53	137.0	137.222	7446603.0
2012-11-14 12:30:00	SPY	ETF	137.22	137.31	136.96	137.02	5901844.0
2012-11-14 13:00:00	SPY	ETF	137.03	137.36	136.96	137.16	7181259.0
2012-11-14 13:30:00	SPY	ETF	137.16	137.43	137.03	137.31	10686464.0
2012-11-14 14:00:00	SPY	ETF	137.3	137.5	136.75	137.0401	14077228.0
2012-11-14 14:30:00	SPY	ETF	137.04	137.05	136.66	136.69	8783995.0
2012-11-14 15:00:00	SPY	ETF	136.7	136.74	136.05	136.3	21520096.0
2012-11-14 15:30:00	SPY	ETF	136.29	136.34	135.62	135.92	28147256.0
2012-11-14 16:00:00	SPY	ETF	135.93	137.8328	135.7988	136.09	10032923.0
2012-11-14 16:30:00	SPY	ETF	136.07	136.15	135.98	136.11	3618583.0
2012-11-14 17:00:00	SPY	ETF	136.11	136.11	135.96	136.0	1172660.0
2012-11-14 17:30:00	SPY	ETF	136.0	136.02	135.9287	135.99	1142732.0
2012-11-14 18:00:00	SPY	ETF	136.0	136.17	135.99	136.17	48471.0
2012-11-14 18:30:00	SPY	ETF	136.17	136.23	136.07	136.1	52295.0
2012-11-14 19:00:00	SPY	ETF	136.1	136.1	136.0	136.01	17762.0
2012-11-14 19:30:00	SPY	ETF	136.01	136.14	136.0	136.01	36512.0
2012-11-14 20:00:00	SPY	ETF	136.03	136.03	136.03	136.03	400.0
2012-11-14 04:30:00	QQQ	ETF	63.53	63.57	63.53	63.57	5400.0
2012-11-14 05:00:00	QQQ	ETF	63.47	63.47	63.47	63.47	100.0
2012-11-14 05:30:00	QQQ	ETF	63.41	63.41	63.4	63.4	1100.0
2012-11-14 06:00:00	QQQ	ETF	63.4	63.4	63.4	63.4	1300.0
2012-11-14 06:30:00	QQQ	ETF	63.38	63.4	63.34	63.34	59550.0
2012-11-14 07:00:00	QQQ	ETF	63.38	63.4	63.23	63.25	181361.0
2012-11-14 07:30:00	QQQ	ETF	63.25	63.31	63.22	63.22	109600.0
2012-11-14 08:00:00	QQQ	ETF	63.22	63.38	63.2	63.32	824227.0
2012-11-14 08:30:00	QQQ	ETF	63.3	63.32	63.19	63.26	1384778.0
2012-11-14 09:00:00	QQQ	ETF	63.26	63.35	63.23	63.27	215672.0
2012-11-14 09:30:00	QQQ	ETF	63.27	63.36	63.08	63.15	6085977.0
2012-11-14 10:00:00	QQQ	ETF	63.15	63.25	62.88	62.895	5540930.0
2012-11-14 10:30:00	QQQ	ETF	62.89	62.985	62.69	62.77	5878087.0
2012-11-14 11:00:00	QQQ	ETF	62.76	62.93	62.68	62.92	2544670.0
2012-11-14 11:30:00	QQQ	ETF	62.91	63.05	62.84	63.01	2975634.0
2012-11-14 12:00:00	QQQ	ETF	63.01	63.03	62.78	62.912	1763525.0
2012-11-14 12:30:00	QQQ	ETF	62.902	62.96	62.74	62.77	1190047.0

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

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