PREVIEW / etf_1hour / 2005-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-28.parquet
  size:    37 KB
  rows:    1,161

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
2005-12-28 05:00:00	SPY	ETF	125.85	125.85	125.85	125.85	600.0
2005-12-28 07:00:00	SPY	ETF	125.89	125.92	125.86	125.87	70800.0
2005-12-28 08:00:00	SPY	ETF	125.84	125.91	125.77	125.8	419600.0
2005-12-28 09:00:00	SPY	ETF	125.79	125.85	125.63	125.77	3340800.0
2005-12-28 10:00:00	SPY	ETF	125.77	125.95	125.5	125.62	6748400.0
2005-12-28 11:00:00	SPY	ETF	125.62	125.87	125.62	125.73	2950300.0
2005-12-28 12:00:00	SPY	ETF	125.73	125.8	125.59	125.7	2327500.0
2005-12-28 13:00:00	SPY	ETF	125.701	125.83	125.63	125.78	2474100.0
2005-12-28 14:00:00	SPY	ETF	125.78	125.99	125.75	125.87	4350700.0
2005-12-28 15:00:00	SPY	ETF	125.86	125.95	125.6	125.61	4241800.0
2005-12-28 16:00:00	SPY	ETF	125.61	125.75	125.61	125.66	920700.0
2005-12-28 17:00:00	SPY	ETF	125.66	125.7	125.63	125.7	12400.0
2005-12-28 19:00:00	SPY	ETF	125.67	125.67	125.67	125.67	500.0
2005-12-28 09:00:00	QQQ	ETF	41.06	41.18	41.06	41.12	7778600.0
2005-12-28 10:00:00	QQQ	ETF	41.12	41.23	40.87	40.95	11328600.0
2005-12-28 11:00:00	QQQ	ETF	40.95	41.07	40.95	40.97	6446400.0
2005-12-28 12:00:00	QQQ	ETF	40.98	41.02	40.93	40.99	3372100.0
2005-12-28 13:00:00	QQQ	ETF	40.99	41.05	40.94	41.03	4625600.0
2005-12-28 14:00:00	QQQ	ETF	41.03	41.15	41.0	41.11	5598600.0
2005-12-28 15:00:00	QQQ	ETF	41.1	41.15	40.99	40.99	8304400.0
2005-12-28 08:00:00	IWM	ETF	67.36	67.4	67.34	67.4	10100.0
2005-12-28 09:00:00	IWM	ETF	67.37	67.47	67.16	67.29	2579100.0
2005-12-28 10:00:00	IWM	ETF	67.29	67.41	66.96	67.01	4835600.0
2005-12-28 11:00:00	IWM	ETF	67.01	67.26	67.0	67.17	3753100.0
2005-12-28 12:00:00	IWM	ETF	67.17	67.2	67.1	67.17	1607300.0
2005-12-28 13:00:00	IWM	ETF	67.17	67.44	67.14	67.38	1699400.0
2005-12-28 14:00:00	IWM	ETF	67.38	67.58	67.37	67.5	2098500.0
2005-12-28 15:00:00	IWM	ETF	67.51	67.69	67.44	67.49	2869900.0
2005-12-28 16:00:00	IWM	ETF	67.48	67.54	67.45	67.51	24000.0
2005-12-28 07:00:00	DIA	ETF	108.05	108.05	108.05	108.05	700.0
2005-12-28 08:00:00	DIA	ETF	108.04	108.07	108.02	108.03	10300.0
2005-12-28 09:00:00	DIA	ETF	107.98	108.05	107.85	107.98	350400.0
2005-12-28 10:00:00	DIA	ETF	107.99	108.11	107.69	107.73	979700.0
2005-12-28 11:00:00	DIA	ETF	107.79	108.0	107.77	107.9	366300.0
2005-12-28 12:00:00	DIA	ETF	107.89	107.97	107.8	107.9	697300.0
2005-12-28 13:00:00	DIA	ETF	107.89	107.97	107.81	107.91	253400.0
2005-12-28 14:00:00	DIA	ETF	107.91	108.15	107.88	108.03	780100.0
2005-12-28 15:00:00	DIA	ETF	108.05	108.11	107.85	107.87	484400.0
2005-12-28 16:00:00	DIA	ETF	107.86	107.9	107.81	107.88	17100.0
2005-12-28 17:00:00	DIA	ETF	107.85	107.85	107.85	107.85	100.0
2005-12-28 18:00:00	DIA	ETF	107.86	107.86	107.86	107.86	162400.0
2005-12-28 07:00:00	GLD	ETF	50.9	50.9	50.87	50.9	15400.0
2005-12-28 08:00:00	GLD	ETF	50.81	51.18	50.81	51.18	266400.0
2005-12-28 09:00:00	GLD	ETF	51.22	51.55	51.2	51.4192	1017600.0
2005-12-28 10:00:00	GLD	ETF	51.41	51.61	51.39	51.45	1337300.0
2005-12-28 11:00:00	GLD	ETF	51.44	51.61	51.37	51.439	440900.0
2005-12-28 12:00:00	GLD	ETF	51.44	51.49	51.33	51.37	270200.0
2005-12-28 13:00:00	GLD	ETF	51.3899	51.39	51.18	51.25	449900.0
2005-12-28 14:00:00	GLD	ETF	51.23	51.48	51.21	51.44	231000.0
2005-12-28 15:00:00	GLD	ETF	51.44	51.52	51.4	51.44	432600.0

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

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