PREVIEW / etf_30min / 2009-06-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-09.parquet
  size:    216 KB
  rows:    7,211

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
2009-06-09 04:00:00	SPY	ETF	94.28	94.28	94.28	94.28	100.0
2009-06-09 05:00:00	SPY	ETF	94.2	94.2	94.2	94.2	2000.0
2009-06-09 06:00:00	SPY	ETF	94.15	94.18	94.11	94.16	74100.0
2009-06-09 06:30:00	SPY	ETF	94.13	94.16	94.13	94.15	20000.0
2009-06-09 07:00:00	SPY	ETF	94.11	94.55	94.1	94.42	185749.0
2009-06-09 07:30:00	SPY	ETF	94.45	94.78	94.31	94.74	1003452.0
2009-06-09 08:00:00	SPY	ETF	94.73	94.7401	94.45	94.65	1309812.0
2009-06-09 08:30:00	SPY	ETF	94.65	94.67	94.44	94.49	582734.0
2009-06-09 09:00:00	SPY	ETF	94.49	94.77	94.46	94.69	989957.0
2009-06-09 09:30:00	SPY	ETF	94.69	94.99	94.35	94.44	30355590.0
2009-06-09 10:00:00	SPY	ETF	94.44	94.66	94.25	94.37	23219935.0
2009-06-09 10:30:00	SPY	ETF	94.39	94.6	94.08	94.19	12007734.0
2009-06-09 11:00:00	SPY	ETF	94.19	94.3	94.02	94.2	9964634.0
2009-06-09 11:30:00	SPY	ETF	94.2	94.3	94.16	94.2	7597451.0
2009-06-09 12:00:00	SPY	ETF	94.21	94.65	94.18	94.61	13191329.0
2009-06-09 12:30:00	SPY	ETF	94.61	94.67	94.42	94.55	9209236.0
2009-06-09 13:00:00	SPY	ETF	94.55	94.77	94.38	94.6301	12147953.0
2009-06-09 13:30:00	SPY	ETF	94.63	94.83	94.46	94.8	9604357.0
2009-06-09 14:00:00	SPY	ETF	94.8	94.99	94.72	94.96	15223720.0
2009-06-09 14:30:00	SPY	ETF	94.96	95.145	94.73	94.9	12562096.0
2009-06-09 15:00:00	SPY	ETF	94.9	95.01	94.61	94.71	18113111.0
2009-06-09 15:30:00	SPY	ETF	94.72	94.97	94.6	94.67	23754935.0
2009-06-09 16:00:00	SPY	ETF	94.66	94.7796	94.25	94.43	17115047.0
2009-06-09 16:30:00	SPY	ETF	94.45	94.46	94.34	94.43	5162577.0
2009-06-09 17:00:00	SPY	ETF	94.42	94.43	94.3461	94.38	1033983.0
2009-06-09 17:30:00	SPY	ETF	94.39	94.39	94.34	94.38	17545.0
2009-06-09 18:00:00	SPY	ETF	94.38	94.62	94.37	94.38	16311.0
2009-06-09 18:30:00	SPY	ETF	94.34	94.35	94.26	94.27	81469.0
2009-06-09 19:00:00	SPY	ETF	94.29	94.3	94.26	94.28	56924.0
2009-06-09 19:30:00	SPY	ETF	94.27	94.28	94.23	94.25	49904.0
2009-06-09 04:30:00	QQQ	ETF	36.73	36.73	36.73	36.73	800.0
2009-06-09 06:00:00	QQQ	ETF	36.7	36.7	36.68	36.68	400.0
2009-06-09 06:30:00	QQQ	ETF	36.67	36.7	36.67	36.68	400.0
2009-06-09 07:00:00	QQQ	ETF	36.67	36.81	36.67	36.78	148990.0
2009-06-09 07:30:00	QQQ	ETF	36.8	36.91	36.76	36.89	402557.0
2009-06-09 08:00:00	QQQ	ETF	36.89	36.9	36.82	36.89	223090.0
2009-06-09 08:30:00	QQQ	ETF	36.89	36.91	36.81	36.84	267020.0
2009-06-09 09:00:00	QQQ	ETF	36.83	36.91	36.83	36.84	338938.0
2009-06-09 09:30:00	QQQ	ETF	36.84	36.99	36.75	36.84	15641590.0
2009-06-09 10:00:00	QQQ	ETF	36.84	36.95	36.76	36.78	9149901.0
2009-06-09 10:30:00	QQQ	ETF	36.79	36.92	36.67	36.74	6322257.0
2009-06-09 11:00:00	QQQ	ETF	36.74	36.8	36.67	36.75	7097045.0
2009-06-09 11:30:00	QQQ	ETF	36.75	36.81	36.72	36.76	4073783.0
2009-06-09 12:00:00	QQQ	ETF	36.76	36.92	36.74	36.92	6499873.0
2009-06-09 12:30:00	QQQ	ETF	36.92	36.96	36.85	36.93	5881638.0
2009-06-09 13:00:00	QQQ	ETF	36.93	37.0	36.85	36.97	5882608.0
2009-06-09 13:30:00	QQQ	ETF	36.97	37.04	36.91	37.04	4693113.0
2009-06-09 14:00:00	QQQ	ETF	37.04	37.13	37.0	37.09	9130416.0
2009-06-09 14:30:00	QQQ	ETF	37.1	37.17	37.0	37.0601	8459149.0
2009-06-09 15:00:00	QQQ	ETF	37.07	37.1	36.97	37.02	5734433.0

> showing 50 of 7,211 rows — these rows as CSV

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