PREVIEW / etf_1hour / 2006-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-08.parquet
  size:    56 KB
  rows:    1,764

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-12-08 07:00:00	SPY	ETF	141.19	141.33	141.19	141.33	484700.0
2006-12-08 08:00:00	SPY	ETF	141.32	141.69	141.22	141.41	4793500.0
2006-12-08 09:00:00	SPY	ETF	141.41	141.85	140.85	141.25	12035600.0
2006-12-08 10:00:00	SPY	ETF	141.25	141.53	140.78	141.24	16320700.0
2006-12-08 11:00:00	SPY	ETF	141.24	141.9	141.22	141.55	13708200.0
2006-12-08 12:00:00	SPY	ETF	141.56	141.71	141.35	141.6	9151300.0
2006-12-08 13:00:00	SPY	ETF	141.6	141.6	141.35	141.41	4979600.0
2006-12-08 14:00:00	SPY	ETF	141.4	141.68	141.29	141.58	4857900.0
2006-12-08 15:00:00	SPY	ETF	141.59	141.65	141.3	141.41	5304900.0
2006-12-08 16:00:00	SPY	ETF	141.39	141.45	141.33	141.36	1246600.0
2006-12-08 17:00:00	SPY	ETF	141.36	141.36	140.8474	141.36	3375300.0
2006-12-08 18:00:00	SPY	ETF	141.36	141.36	141.36	141.36	2400.0
2006-12-08 19:00:00	SPY	ETF	141.42	141.42	141.42	141.42	900.0
2006-12-08 09:00:00	QQQ	ETF	43.57	43.83	43.53	43.66	19324900.0
2006-12-08 10:00:00	QQQ	ETF	43.66	43.77	43.47	43.73	22846000.0
2006-12-08 11:00:00	QQQ	ETF	43.73	44.26	43.73	44.12	31343900.0
2006-12-08 12:00:00	QQQ	ETF	44.12	44.22	44.05	44.13	9017200.0
2006-12-08 13:00:00	QQQ	ETF	44.14	44.14	43.98	44.01	7791000.0
2006-12-08 14:00:00	QQQ	ETF	44.01	44.13	43.96	44.09	7169500.0
2006-12-08 15:00:00	QQQ	ETF	44.1	44.1	43.84	43.9	15322600.0
2006-12-08 07:00:00	IWM	ETF	78.74	78.74	78.74	78.74	5000.0
2006-12-08 08:00:00	IWM	ETF	78.8	79.1	78.71	78.9	1849500.0
2006-12-08 09:00:00	IWM	ETF	78.89	79.0	78.41	78.6	5904900.0
2006-12-08 10:00:00	IWM	ETF	78.58	78.83	78.16	78.68	12561200.0
2006-12-08 11:00:00	IWM	ETF	78.69	79.34	78.69	79.08	7927500.0
2006-12-08 12:00:00	IWM	ETF	79.08	79.17	78.86	79.0	3008300.0
2006-12-08 13:00:00	IWM	ETF	78.99	79.1	78.79	78.85	3660500.0
2006-12-08 14:00:00	IWM	ETF	78.84	79.07	78.81	79.03	2253400.0
2006-12-08 15:00:00	IWM	ETF	79.03	79.11	78.84	78.85	3094400.0
2006-12-08 16:00:00	IWM	ETF	78.85	78.87	78.76	78.77	1124400.0
2006-12-08 17:00:00	IWM	ETF	78.78	78.78	78.78	78.78	1000.0
2006-12-08 07:00:00	DIA	ETF	122.93	122.93	122.93	122.93	200.0
2006-12-08 08:00:00	DIA	ETF	122.88	123.11	122.8	123.0	96900.0
2006-12-08 09:00:00	DIA	ETF	122.89	123.03	122.47	122.81	1352200.0
2006-12-08 10:00:00	DIA	ETF	122.82	122.94	122.32	122.82	1560900.0
2006-12-08 11:00:00	DIA	ETF	122.83	123.38	122.82	123.13	1789300.0
2006-12-08 12:00:00	DIA	ETF	123.16	123.29	122.94	123.11	760900.0
2006-12-08 13:00:00	DIA	ETF	123.12	123.14	122.96	123.02	517600.0
2006-12-08 14:00:00	DIA	ETF	123.02	123.24	122.92	123.16	524600.0
2006-12-08 15:00:00	DIA	ETF	123.16	123.3	123.0	123.02	570900.0
2006-12-08 16:00:00	DIA	ETF	123.03	123.07	123.0	123.0	7800.0
2006-12-08 17:00:00	DIA	ETF	123.0	123.0	123.0	123.0	130000.0
2006-12-08 19:00:00	DIA	ETF	123.02	123.02	123.02	123.02	200.0
2006-12-08 08:00:00	GLD	ETF	62.72	63.12	62.35	63.03	275600.0
2006-12-08 09:00:00	GLD	ETF	63.07	63.3	62.93	63.26	815300.0
2006-12-08 10:00:00	GLD	ETF	63.25	63.34	62.88	62.99	1112500.0
2006-12-08 11:00:00	GLD	ETF	63.0	63.22	62.36	62.5476	1153000.0
2006-12-08 12:00:00	GLD	ETF	62.5599	62.63	62.11	62.23	1092000.0
2006-12-08 13:00:00	GLD	ETF	62.24	62.32	62.09	62.18	537800.0
2006-12-08 14:00:00	GLD	ETF	62.17	62.2	62.09	62.15	227300.0

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

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