PREVIEW / etf_1hour / 2005-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-20.parquet
  size:    38 KB
  rows:    1,192

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-20 07:00:00	SPY	ETF	125.95	125.99	125.89	125.89	33000.0
2005-12-20 08:00:00	SPY	ETF	125.9	126.1	125.89	125.95	1060100.0
2005-12-20 09:00:00	SPY	ETF	125.95	126.02	125.71	125.9	6455500.0
2005-12-20 10:00:00	SPY	ETF	125.9	126.59	125.48	125.79	9636200.0
2005-12-20 11:00:00	SPY	ETF	125.78	125.95	125.75	125.75	4199600.0
2005-12-20 12:00:00	SPY	ETF	125.75	126.15	125.71	126.13	6309100.0
2005-12-20 13:00:00	SPY	ETF	126.15	126.22	125.87	125.97	6299100.0
2005-12-20 14:00:00	SPY	ETF	125.95	125.99	125.76	125.86	3980400.0
2005-12-20 15:00:00	SPY	ETF	125.86	125.87	125.56	125.77	6748600.0
2005-12-20 16:00:00	SPY	ETF	125.77	125.85	125.74	125.85	894900.0
2005-12-20 17:00:00	SPY	ETF	125.84	125.84	125.8	125.8	4300.0
2005-12-20 18:00:00	SPY	ETF	125.79	125.79	125.72	125.74	3700.0
2005-12-20 19:00:00	SPY	ETF	125.78	125.81	125.78	125.81	300.0
2005-12-20 09:00:00	QQQ	ETF	40.95	41.01	40.79	40.9	11997200.0
2005-12-20 10:00:00	QQQ	ETF	40.9	40.93	40.75	40.92	13545700.0
2005-12-20 11:00:00	QQQ	ETF	40.93	41.04	40.89	41.0	7421600.0
2005-12-20 12:00:00	QQQ	ETF	40.92	41.12	40.92	41.1	8209100.0
2005-12-20 13:00:00	QQQ	ETF	41.1	41.15	40.99	41.04	8298200.0
2005-12-20 14:00:00	QQQ	ETF	41.03	41.08	40.93	40.95	5930200.0
2005-12-20 15:00:00	QQQ	ETF	40.95	41.03	40.85	40.96	10459800.0
2005-12-20 08:00:00	IWM	ETF	67.05	67.13	67.05	67.09	13900.0
2005-12-20 09:00:00	IWM	ETF	67.11	67.12	66.68	66.89	4150000.0
2005-12-20 10:00:00	IWM	ETF	66.88	66.9	66.54	66.86	5188800.0
2005-12-20 11:00:00	IWM	ETF	66.86	67.13	66.85	67.02	4435500.0
2005-12-20 12:00:00	IWM	ETF	67.02	67.53	66.98	67.47	4819700.0
2005-12-20 13:00:00	IWM	ETF	67.48	67.48	67.23	67.32	1066800.0
2005-12-20 14:00:00	IWM	ETF	67.32	67.41	67.17	67.28	1249600.0
2005-12-20 15:00:00	IWM	ETF	67.27	67.27	66.9	66.93	4979400.0
2005-12-20 16:00:00	IWM	ETF	66.93	67.04	66.93	66.97	1602700.0
2005-12-20 17:00:00	IWM	ETF	66.98	67.05	66.98	67.05	101900.0
2005-12-20 18:00:00	IWM	ETF	67.01	67.02	67.01	67.02	2900.0
2005-12-20 07:00:00	DIA	ETF	108.34	108.34	108.31	108.31	900.0
2005-12-20 08:00:00	DIA	ETF	108.36	108.45	108.36	108.45	107500.0
2005-12-20 09:00:00	DIA	ETF	108.35	108.4	108.16	108.32	783600.0
2005-12-20 10:00:00	DIA	ETF	108.33	108.34	108.01	108.21	535800.0
2005-12-20 11:00:00	DIA	ETF	108.21	108.33	108.16	108.16	265600.0
2005-12-20 12:00:00	DIA	ETF	108.16	108.42	108.13	108.4	954600.0
2005-12-20 13:00:00	DIA	ETF	108.38	108.42	108.16	108.22	332300.0
2005-12-20 14:00:00	DIA	ETF	108.22	108.22	107.95	108.0	1501500.0
2005-12-20 15:00:00	DIA	ETF	108.0	108.01	107.7	107.89	532800.0
2005-12-20 16:00:00	DIA	ETF	107.91	107.94	107.89	107.89	20500.0
2005-12-20 07:00:00	GLD	ETF	51.1	51.1	51.05	51.05	2000.0
2005-12-20 08:00:00	GLD	ETF	50.39	50.5	50.37	50.37	22000.0
2005-12-20 09:00:00	GLD	ETF	50.41	50.41	50.25	50.33	188600.0
2005-12-20 10:00:00	GLD	ETF	50.33	50.33	49.94	50.04	426900.0
2005-12-20 11:00:00	GLD	ETF	50.02	50.16	49.84	49.86	360500.0
2005-12-20 12:00:00	GLD	ETF	49.85	50.15	49.32	49.35	1082000.0
2005-12-20 13:00:00	GLD	ETF	49.35	49.5	49.1801	49.35	1199700.0
2005-12-20 14:00:00	GLD	ETF	49.33	49.33	49.1	49.12	391600.0
2005-12-20 15:00:00	GLD	ETF	49.11	49.16	49.0	49.07	601700.0

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

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