PREVIEW / etf_30min / 2008-07-30

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-30.parquet
  size:    175 KB
  rows:    6,021

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
2008-07-30 04:30:00	SPY	ETF	126.27	126.27	126.27	126.27	200.0
2008-07-30 05:30:00	SPY	ETF	126.11	126.13	126.1	126.1	7200.0
2008-07-30 06:00:00	SPY	ETF	126.43	126.44	126.4	126.4	5300.0
2008-07-30 06:30:00	SPY	ETF	126.5	126.5	126.5	126.5	100.0
2008-07-30 07:00:00	SPY	ETF	126.47	126.53	126.33	126.51	311437.0
2008-07-30 07:30:00	SPY	ETF	126.5	126.52	126.21	126.34	468600.0
2008-07-30 08:00:00	SPY	ETF	126.31	126.73	126.13	126.73	4406029.0
2008-07-30 08:30:00	SPY	ETF	126.73	126.99	126.71	126.98	2083944.0
2008-07-30 09:00:00	SPY	ETF	126.99	127.25	126.95	127.01	3721516.0
2008-07-30 09:30:00	SPY	ETF	127.02	127.69	126.95	127.3	57433227.0
2008-07-30 10:00:00	SPY	ETF	127.31	128.06	126.3502	127.95	28057474.0
2008-07-30 10:30:00	SPY	ETF	127.94	128.13	127.36	127.51	44150804.0
2008-07-30 11:00:00	SPY	ETF	127.52	127.86	127.37	127.64	22652429.0
2008-07-30 11:30:00	SPY	ETF	127.64	127.68	127.3	127.47	13741492.0
2008-07-30 12:00:00	SPY	ETF	127.48	127.53	127.12	127.29	12777294.0
2008-07-30 12:30:00	SPY	ETF	127.29	127.3	126.54	126.85	23303096.0
2008-07-30 13:00:00	SPY	ETF	126.84	127.11	126.3502	127.02	24888714.0
2008-07-30 13:30:00	SPY	ETF	127.02	127.16	126.55	126.76	15177417.0
2008-07-30 14:00:00	SPY	ETF	126.77	127.65	126.62	127.16	15501863.0
2008-07-30 14:30:00	SPY	ETF	127.16	127.48	127.08	127.45	20005171.0
2008-07-30 15:00:00	SPY	ETF	127.46	127.92	127.05	127.91	20423039.0
2008-07-30 15:30:00	SPY	ETF	127.91	128.47	127.9	128.45	32199091.0
2008-07-30 16:00:00	SPY	ETF	128.46	128.68	126.3502	128.56	6943431.0
2008-07-30 16:30:00	SPY	ETF	128.57	128.67	127.73	128.59	758877.0
2008-07-30 17:00:00	SPY	ETF	128.6	128.6	126.35	128.53	1194638.0
2008-07-30 17:30:00	SPY	ETF	128.53	128.57	128.49	128.5	107139.0
2008-07-30 18:00:00	SPY	ETF	128.5	128.62	128.5	128.57	70400.0
2008-07-30 18:30:00	SPY	ETF	128.58	128.6	128.54	128.56	7450.0
2008-07-30 19:00:00	SPY	ETF	128.58	128.58	128.5	128.5	25265.0
2008-07-30 19:30:00	SPY	ETF	128.5	128.55	128.48	128.48	26616.0
2008-07-30 04:00:00	QQQ	ETF	45.22	45.22	45.22	45.22	300.0
2008-07-30 06:30:00	QQQ	ETF	45.41	45.42	45.38	45.4	8300.0
2008-07-30 07:00:00	QQQ	ETF	45.42	45.47	45.38	45.47	200091.0
2008-07-30 07:30:00	QQQ	ETF	45.46	45.46	45.37	45.41	264614.0
2008-07-30 08:00:00	QQQ	ETF	45.41	45.54	45.34	45.44	5513541.0
2008-07-30 08:30:00	QQQ	ETF	45.44	45.59	45.44	45.58	1970068.0
2008-07-30 09:00:00	QQQ	ETF	45.59	45.6	45.45	45.45	1297040.0
2008-07-30 09:30:00	QQQ	ETF	45.46	45.66	45.37	45.38	16357619.0
2008-07-30 10:00:00	QQQ	ETF	45.39	45.82	45.38	45.78	13157934.0
2008-07-30 10:30:00	QQQ	ETF	45.78	45.81	45.53	45.53	17306873.0
2008-07-30 11:00:00	QQQ	ETF	45.53	45.66	45.49	45.6	4969266.0
2008-07-30 11:30:00	QQQ	ETF	45.6	45.66	45.52	45.59	3719544.0
2008-07-30 12:00:00	QQQ	ETF	45.59	45.62	45.38	45.43	6331973.0
2008-07-30 12:30:00	QQQ	ETF	45.43	45.44	45.11	45.1899	10216249.0
2008-07-30 13:00:00	QQQ	ETF	45.18	45.21	44.96	45.1295	13955122.0
2008-07-30 13:30:00	QQQ	ETF	45.1299	45.15	44.88	45.01	12747866.0
2008-07-30 14:00:00	QQQ	ETF	45.0199	45.14	44.9	45.1195	7707690.0
2008-07-30 14:30:00	QQQ	ETF	45.1101	45.23	45.09	45.21	9188283.0
2008-07-30 15:00:00	QQQ	ETF	45.21	45.31	44.95	45.301	11063988.0
2008-07-30 15:30:00	QQQ	ETF	45.31	45.57	45.31	45.56	14717553.0

> showing 50 of 6,021 rows — these rows as CSV

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