PREVIEW / etf_30min / 2012-06-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-13.parquet
  size:    277 KB
  rows:    9,190

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-13 04:00:00	SPY	ETF	133.01	133.02	133.01	133.02	335.0
2012-06-13 04:30:00	SPY	ETF	132.91	132.91	132.89	132.89	400.0
2012-06-13 05:00:00	SPY	ETF	132.86	133.18	132.86	133.18	7300.0
2012-06-13 05:30:00	SPY	ETF	132.92	132.97	132.81	132.87	3300.0
2012-06-13 06:00:00	SPY	ETF	132.87	133.1	132.87	133.07	51610.0
2012-06-13 06:30:00	SPY	ETF	133.07	133.07	132.83	132.83	34299.0
2012-06-13 07:00:00	SPY	ETF	132.86	132.94	132.68	132.78	184415.0
2012-06-13 07:30:00	SPY	ETF	132.78	132.98	132.77	132.96	149815.0
2012-06-13 08:00:00	SPY	ETF	132.92	132.98	132.66	132.72	828610.0
2012-06-13 08:30:00	SPY	ETF	132.67	132.8	132.39	132.56	1280873.0
2012-06-13 09:00:00	SPY	ETF	132.56	132.57	132.33	132.53	1183641.0
2012-06-13 09:30:00	SPY	ETF	132.53	132.6	132.09	132.25	19645777.0
2012-06-13 10:00:00	SPY	ETF	132.25	132.88	132.23	132.71	12969256.0
2012-06-13 10:30:00	SPY	ETF	132.71	133.3	132.71	133.2	15469914.0
2012-06-13 11:00:00	SPY	ETF	133.2	133.2	132.78	132.94	12571476.0
2012-06-13 11:30:00	SPY	ETF	132.94	133.18	132.77	132.86	7902689.0
2012-06-13 12:00:00	SPY	ETF	132.86	132.88	132.59	132.81	8401248.0
2012-06-13 12:30:00	SPY	ETF	132.81	133.36	132.795	133.11	7783635.0
2012-06-13 13:00:00	SPY	ETF	133.1	133.24	132.97	133.22	11084652.0
2012-06-13 13:30:00	SPY	ETF	133.22	133.29	132.75	132.8	9010612.0
2012-06-13 14:00:00	SPY	ETF	132.81	132.87	132.64	132.73	6444664.0
2012-06-13 14:30:00	SPY	ETF	132.72	132.795	132.28	132.3399	11970674.0
2012-06-13 15:00:00	SPY	ETF	132.33	132.43	131.71	131.75	13896724.0
2012-06-13 15:30:00	SPY	ETF	131.74	132.11	131.62	132.09	19519409.0
2012-06-13 16:00:00	SPY	ETF	132.09	132.24	131.9759	132.12	9513294.0
2012-06-13 16:30:00	SPY	ETF	132.13	133.1499	131.79	131.91	1329113.0
2012-06-13 17:00:00	SPY	ETF	131.91	132.11	131.9	132.08	115608.0
2012-06-13 17:30:00	SPY	ETF	132.08	132.09	132.04	132.04	18970.0
2012-06-13 18:00:00	SPY	ETF	132.06	132.18	132.01	132.15	51717.0
2012-06-13 18:30:00	SPY	ETF	132.15	132.19	132.08	132.1	107650.0
2012-06-13 19:00:00	SPY	ETF	132.1	132.13	132.01	132.11	18290.0
2012-06-13 19:30:00	SPY	ETF	132.11	132.19	132.06	132.19	105130.0
2012-06-13 05:30:00	QQQ	ETF	62.5	62.5	62.5	62.5	1000.0
2012-06-13 07:00:00	QQQ	ETF	62.55	62.56	62.45	62.46	8650.0
2012-06-13 07:30:00	QQQ	ETF	62.44	62.57	62.44	62.57	21000.0
2012-06-13 08:00:00	QQQ	ETF	62.57	62.63	62.45	62.48	24450.0
2012-06-13 08:30:00	QQQ	ETF	62.44	62.52	62.35	62.43	328498.0
2012-06-13 09:00:00	QQQ	ETF	62.41	62.43	62.29	62.38	169760.0
2012-06-13 09:30:00	QQQ	ETF	62.38	62.57	62.19	62.285	5715210.0
2012-06-13 10:00:00	QQQ	ETF	62.28	62.64	62.27	62.54	4189559.0
2012-06-13 10:30:00	QQQ	ETF	62.55	62.85	62.55	62.82	3994669.0
2012-06-13 11:00:00	QQQ	ETF	62.82	62.82	62.64	62.73	2345522.0
2012-06-13 11:30:00	QQQ	ETF	62.725	62.85	62.61	62.64	1689755.0
2012-06-13 12:00:00	QQQ	ETF	62.6377	62.6377	62.465	62.52	2261528.0
2012-06-13 12:30:00	QQQ	ETF	62.52	62.78	62.52	62.68	1503623.0
2012-06-13 13:00:00	QQQ	ETF	62.68	62.75	62.61	62.74	2440575.0
2012-06-13 13:30:00	QQQ	ETF	62.74	62.77	62.47	62.5	2251574.0
2012-06-13 14:00:00	QQQ	ETF	62.5	62.54	62.42	62.5	1679304.0
2012-06-13 14:30:00	QQQ	ETF	62.49	62.52	62.23	62.27	3292561.0
2012-06-13 15:00:00	QQQ	ETF	62.26	62.31	61.94	61.98	4280604.0

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

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