PREVIEW / etf_1hour / 2006-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-01-31.parquet
  size:    40 KB
  rows:    1,250

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
2006-01-31 05:00:00	SPY	ETF	128.47	128.47	128.47	128.47	200.0
2006-01-31 07:00:00	SPY	ETF	128.34	128.43	128.3	128.3	89500.0
2006-01-31 08:00:00	SPY	ETF	128.3	128.43	128.26	128.33	461400.0
2006-01-31 09:00:00	SPY	ETF	128.33	128.38	128.08	128.15	7359200.0
2006-01-31 10:00:00	SPY	ETF	128.14	128.25	127.92	128.07	9248400.0
2006-01-31 11:00:00	SPY	ETF	128.07	128.15	127.93	127.99	3251100.0
2006-01-31 12:00:00	SPY	ETF	127.98	128.08	127.9	128.05	1583800.0
2006-01-31 13:00:00	SPY	ETF	128.05	128.29	127.96	128.18	3854900.0
2006-01-31 14:00:00	SPY	ETF	128.18	128.43	127.66	128.3	24247800.0
2006-01-31 15:00:00	SPY	ETF	128.27	128.54	127.93	127.94	12394300.0
2006-01-31 16:00:00	SPY	ETF	127.94	128.04	127.4	127.47	2909200.0
2006-01-31 17:00:00	SPY	ETF	127.47	127.6	127.29	127.49	4927200.0
2006-01-31 18:00:00	SPY	ETF	127.51	127.63	127.44	127.53	155300.0
2006-01-31 19:00:00	SPY	ETF	127.55	127.61	127.53	127.58	20000.0
2006-01-31 09:00:00	QQQ	ETF	42.14	42.19	41.91	41.96	9598400.0
2006-01-31 10:00:00	QQQ	ETF	41.95	41.98	41.81	41.95	10785100.0
2006-01-31 11:00:00	QQQ	ETF	41.96	42.02	41.91	41.95	5683400.0
2006-01-31 12:00:00	QQQ	ETF	41.95	42.0	41.94	41.97	3278200.0
2006-01-31 13:00:00	QQQ	ETF	41.97	42.09	41.94	42.05	5798700.0
2006-01-31 14:00:00	QQQ	ETF	42.04	42.14	41.82	42.1	21333100.0
2006-01-31 15:00:00	QQQ	ETF	42.11	42.27	42.0	42.01	21587700.0
2006-01-31 07:00:00	IWM	ETF	72.5	72.52	72.5	72.52	17000.0
2006-01-31 08:00:00	IWM	ETF	72.52	72.52	72.38	72.43	303800.0
2006-01-31 09:00:00	IWM	ETF	72.44	72.48	72.24	72.3	2883400.0
2006-01-31 10:00:00	IWM	ETF	72.3	72.35	72.13	72.32	3858500.0
2006-01-31 11:00:00	IWM	ETF	72.32	72.54	72.25	72.46	4070700.0
2006-01-31 12:00:00	IWM	ETF	72.46	72.5	72.4	72.5	2099000.0
2006-01-31 13:00:00	IWM	ETF	72.5	72.9	72.45	72.79	4899800.0
2006-01-31 14:00:00	IWM	ETF	72.79	72.88	72.3	72.88	11893700.0
2006-01-31 15:00:00	IWM	ETF	72.87	72.96	72.67	72.71	5179900.0
2006-01-31 16:00:00	IWM	ETF	72.7	72.83	71.92	72.16	1148100.0
2006-01-31 17:00:00	IWM	ETF	72.16	72.24	71.9	72.2	401800.0
2006-01-31 18:00:00	IWM	ETF	72.13	72.13	72.13	72.13	100.0
2006-01-31 08:00:00	DIA	ETF	108.71	108.71	108.71	108.71	1000.0
2006-01-31 09:00:00	DIA	ETF	108.78	108.82	108.61	108.69	196400.0
2006-01-31 10:00:00	DIA	ETF	108.71	108.74	108.57	108.7	422700.0
2006-01-31 11:00:00	DIA	ETF	108.7	108.8	108.62	108.66	812200.0
2006-01-31 12:00:00	DIA	ETF	108.69	108.74	108.65	108.73	165800.0
2006-01-31 13:00:00	DIA	ETF	108.73	108.98	108.68	108.91	229500.0
2006-01-31 14:00:00	DIA	ETF	108.91	109.19	108.54	108.92	1644500.0
2006-01-31 15:00:00	DIA	ETF	108.96	109.17	108.58	108.58	1404200.0
2006-01-31 16:00:00	DIA	ETF	108.58	108.62	108.16	108.16	117800.0
2006-01-31 17:00:00	DIA	ETF	108.3	108.3	108.1	108.1	2000.0
2006-01-31 18:00:00	DIA	ETF	108.15	108.27	108.15	108.27	200.0
2006-01-31 08:00:00	GLD	ETF	56.73	56.85	56.5	56.51	262800.0
2006-01-31 09:00:00	GLD	ETF	56.54	56.82	56.38	56.75	743600.0
2006-01-31 10:00:00	GLD	ETF	56.75	56.89	56.53	56.77	1115800.0
2006-01-31 11:00:00	GLD	ETF	56.78	56.82	56.57	56.68	928200.0
2006-01-31 12:00:00	GLD	ETF	56.67	57.05	56.67	56.94	523000.0
2006-01-31 13:00:00	GLD	ETF	56.93	57.03	56.82	56.86	497900.0

> showing 50 of 1,250 rows — these rows as CSV

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