PREVIEW / etf_30min / 2012-06-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-19.parquet
  size:    288 KB
  rows:    9,703

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-06-19 04:00:00	SPY	ETF	134.94	134.94	134.26	134.4	3370.0
2012-06-19 04:30:00	SPY	ETF	134.66	134.73	134.65	134.73	1700.0
2012-06-19 05:00:00	SPY	ETF	134.53	134.8	134.48	134.75	3200.0
2012-06-19 05:30:00	SPY	ETF	134.82	134.94	134.7	134.94	7120.0
2012-06-19 06:00:00	SPY	ETF	134.88	134.96	134.85	134.89	9800.0
2012-06-19 06:30:00	SPY	ETF	134.87	134.88	134.78	134.78	15620.0
2012-06-19 07:00:00	SPY	ETF	134.84	135.0	134.84	134.87	58952.0
2012-06-19 07:30:00	SPY	ETF	134.89	135.14	134.84	135.01	320126.0
2012-06-19 08:00:00	SPY	ETF	135.0	135.11	134.5	135.09	262690.0
2012-06-19 08:30:00	SPY	ETF	135.08	135.15	134.79	134.93	1032973.0
2012-06-19 09:00:00	SPY	ETF	134.92	135.22	134.84	135.08	1089357.0
2012-06-19 09:30:00	SPY	ETF	135.08	135.44	134.93	135.42	13525751.0
2012-06-19 10:00:00	SPY	ETF	135.415	135.71	135.37	135.66	14288099.0
2012-06-19 10:30:00	SPY	ETF	135.66	135.75	135.5	135.7	9461103.0
2012-06-19 11:00:00	SPY	ETF	135.7	135.82	135.53	135.65	9603047.0
2012-06-19 11:30:00	SPY	ETF	135.66	135.85	135.59	135.82	6755107.0
2012-06-19 12:00:00	SPY	ETF	135.82	135.87	135.71	135.78	4219098.0
2012-06-19 12:30:00	SPY	ETF	135.79	135.9	135.74	135.87	3120785.0
2012-06-19 13:00:00	SPY	ETF	135.88	136.05	135.79	136.05	6498419.0
2012-06-19 13:30:00	SPY	ETF	136.05	136.25	136.04	136.12	7973742.0
2012-06-19 14:00:00	SPY	ETF	136.12	136.13	135.9	135.94	6296070.0
2012-06-19 14:30:00	SPY	ETF	135.94	135.94	135.58	135.865	14595063.0
2012-06-19 15:00:00	SPY	ETF	135.87	136.06	135.76	135.85	8598091.0
2012-06-19 15:30:00	SPY	ETF	135.85	135.91	135.59	135.7	18483533.0
2012-06-19 16:00:00	SPY	ETF	135.69	135.8121	134.3744	135.57	8222938.0
2012-06-19 16:30:00	SPY	ETF	135.58	135.61	135.48	135.54	2163353.0
2012-06-19 17:00:00	SPY	ETF	135.54	135.55	135.47	135.48	97792.0
2012-06-19 17:30:00	SPY	ETF	135.51	135.53	135.48	135.48	75740.0
2012-06-19 18:00:00	SPY	ETF	135.47	135.53	135.45	135.49	52990.0
2012-06-19 18:30:00	SPY	ETF	135.48	135.58	135.48	135.53	16650.0
2012-06-19 19:00:00	SPY	ETF	135.57	135.57	135.52	135.55	7950.0
2012-06-19 19:30:00	SPY	ETF	135.55	135.65	135.53	135.54	95772.0
2012-06-19 04:30:00	QQQ	ETF	63.72	63.72	63.72	63.72	100.0
2012-06-19 05:00:00	QQQ	ETF	63.75	63.75	63.75	63.75	200.0
2012-06-19 07:00:00	QQQ	ETF	63.8	63.86	63.79	63.83	34235.0
2012-06-19 07:30:00	QQQ	ETF	63.83	63.92	63.82	63.86	33850.0
2012-06-19 08:00:00	QQQ	ETF	63.87	63.87	63.81	63.86	135371.0
2012-06-19 08:30:00	QQQ	ETF	63.86	63.9	63.75	63.8	60395.0
2012-06-19 09:00:00	QQQ	ETF	63.8	63.92	63.8	63.88	83008.0
2012-06-19 09:30:00	QQQ	ETF	63.9	64.21	63.85	64.18	4539423.0
2012-06-19 10:00:00	QQQ	ETF	64.19	64.27	64.13	64.19	3039557.0
2012-06-19 10:30:00	QQQ	ETF	64.2	64.29	64.17	64.27	2037376.0
2012-06-19 11:00:00	QQQ	ETF	64.27	64.34	64.18	64.26	2139495.0
2012-06-19 11:30:00	QQQ	ETF	64.265	64.3783	64.205	64.34	1265504.0
2012-06-19 12:00:00	QQQ	ETF	64.34	64.38	64.27	64.28	1355544.0
2012-06-19 12:30:00	QQQ	ETF	64.28	64.35	64.24	64.33	788741.0
2012-06-19 13:00:00	QQQ	ETF	64.3395	64.4	64.29	64.4	1221403.0
2012-06-19 13:30:00	QQQ	ETF	64.4	64.51	64.38	64.45	2091348.0
2012-06-19 14:00:00	QQQ	ETF	64.445	64.47	64.31	64.315	1079960.0
2012-06-19 14:30:00	QQQ	ETF	64.32	64.335	64.1809	64.3292	2456877.0

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

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