PREVIEW / etf_30min / 2011-03-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-17.parquet
  size:    291 KB
  rows:    9,699

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-03-17 04:00:00	SPY	ETF	127.35	127.51	127.2	127.35	35731.0
2011-03-17 04:30:00	SPY	ETF	127.54	127.71	127.46	127.69	15342.0
2011-03-17 05:00:00	SPY	ETF	127.69	127.9	127.44	127.44	46959.0
2011-03-17 05:30:00	SPY	ETF	127.48	127.61	127.43	127.43	23095.0
2011-03-17 06:00:00	SPY	ETF	127.5	127.56	127.17	127.49	36280.0
2011-03-17 06:30:00	SPY	ETF	127.44	127.44	126.77	127.32	362916.0
2011-03-17 07:00:00	SPY	ETF	127.28	127.34	127.0	127.19	443466.0
2011-03-17 07:30:00	SPY	ETF	127.18	127.62	127.13	127.48	561408.0
2011-03-17 08:00:00	SPY	ETF	127.5	128.22	126.6786	128.0	4160671.0
2011-03-17 08:30:00	SPY	ETF	128.0	128.31	127.18	128.1	8426788.0
2011-03-17 09:00:00	SPY	ETF	128.1	128.3	127.92	128.0	3306527.0
2011-03-17 09:30:00	SPY	ETF	128.0	128.119	127.47	127.58	24429562.0
2011-03-17 10:00:00	SPY	ETF	127.59	128.39	127.5	128.29	22548670.0
2011-03-17 10:30:00	SPY	ETF	128.3	128.36	128.01	128.12	15301334.0
2011-03-17 11:00:00	SPY	ETF	128.11	128.38	127.77	127.84	17594994.0
2011-03-17 11:30:00	SPY	ETF	127.83	128.08	127.66	127.72	8671810.0
2011-03-17 12:00:00	SPY	ETF	127.71	128.06	127.645	128.01	10260576.0
2011-03-17 12:30:00	SPY	ETF	128.01	128.18	127.82	127.87	6570915.0
2011-03-17 13:00:00	SPY	ETF	127.87	128.14	127.43	127.48	10425762.0
2011-03-17 13:30:00	SPY	ETF	127.475	127.74	127.1	127.34	17013932.0
2011-03-17 14:00:00	SPY	ETF	127.35	127.49	127.125	127.39	10944703.0
2011-03-17 14:30:00	SPY	ETF	127.38	127.86	127.37	127.7	14055749.0
2011-03-17 15:00:00	SPY	ETF	127.7	127.91	127.52	127.57	13299771.0
2011-03-17 15:30:00	SPY	ETF	127.57	128.2	127.5	127.8	30726307.0
2011-03-17 16:00:00	SPY	ETF	127.8	128.34	126.1565	127.84	21714118.0
2011-03-17 16:30:00	SPY	ETF	127.79	128.21	127.61	127.75	10987874.0
2011-03-17 17:00:00	SPY	ETF	127.74	127.85	127.71	127.83	629016.0
2011-03-17 17:30:00	SPY	ETF	127.82	127.87	127.8	127.84	58856.0
2011-03-17 18:00:00	SPY	ETF	127.84	127.99	127.75	127.94	227370.0
2011-03-17 18:30:00	SPY	ETF	127.93	127.96	127.32	127.43	103533.0
2011-03-17 19:00:00	SPY	ETF	127.42	127.5	127.15	127.25	132520.0
2011-03-17 19:30:00	SPY	ETF	127.25	127.68	127.17	127.68	95947.0
2011-03-17 04:00:00	QQQ	ETF	54.5	54.55	54.5	54.55	350.0
2011-03-17 04:30:00	QQQ	ETF	54.69	54.79	54.69	54.79	22165.0
2011-03-17 05:00:00	QQQ	ETF	54.78	54.91	54.78	54.79	6497.0
2011-03-17 05:30:00	QQQ	ETF	54.71	54.71	54.65	54.67	5690.0
2011-03-17 06:00:00	QQQ	ETF	54.68	54.68	54.56	54.6	106720.0
2011-03-17 06:30:00	QQQ	ETF	54.6	54.63	54.45	54.63	22372.0
2011-03-17 07:00:00	QQQ	ETF	54.6	54.63	54.52	54.52	30937.0
2011-03-17 07:30:00	QQQ	ETF	54.58	54.76	54.56	54.73	99886.0
2011-03-17 08:00:00	QQQ	ETF	54.75	54.94	54.69	54.87	500452.0
2011-03-17 08:30:00	QQQ	ETF	54.87	55.07	54.78	55.01	1682731.0
2011-03-17 09:00:00	QQQ	ETF	55.01	55.1	54.95	55.0	1120203.0
2011-03-17 09:30:00	QQQ	ETF	54.99	55.07	54.77	54.8375	11376296.0
2011-03-17 10:00:00	QQQ	ETF	54.88	55.12	54.81	55.09	10294516.0
2011-03-17 10:30:00	QQQ	ETF	55.1	55.18	55.03	55.13	6944172.0
2011-03-17 11:00:00	QQQ	ETF	55.13	55.24	55.025	55.0808	8511462.0
2011-03-17 11:30:00	QQQ	ETF	55.09	55.19	55.02	55.0269	4772418.0
2011-03-17 12:00:00	QQQ	ETF	55.02	55.13	55.01	55.065	2580481.0
2011-03-17 12:30:00	QQQ	ETF	55.07	55.14	54.99	55.01	2327390.0

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

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