PREVIEW / etf_1hour / 2007-11-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-09.parquet
  size:    93 KB
  rows:    3,099

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
2007-11-09 04:00:00	SPY	ETF	147.54	147.54	147.27	147.27	6000.0
2007-11-09 05:00:00	SPY	ETF	147.12	147.12	146.51	146.56	40000.0
2007-11-09 06:00:00	SPY	ETF	146.56	146.56	145.6	145.74	537100.0
2007-11-09 07:00:00	SPY	ETF	145.83	146.4	145.7	145.9	1361300.0
2007-11-09 08:00:00	SPY	ETF	145.92	146.17	145.5	145.91	4917600.0
2007-11-09 09:00:00	SPY	ETF	145.9	145.99	145.11	145.51	32576339.0
2007-11-09 10:00:00	SPY	ETF	145.52	146.55	145.18	145.79	42885258.0
2007-11-09 11:00:00	SPY	ETF	145.79	146.52	144.89	146.39	46793641.0
2007-11-09 12:00:00	SPY	ETF	146.4	146.82	145.69	146.23	24048474.0
2007-11-09 13:00:00	SPY	ETF	146.23	146.44	145.78	145.98	20232799.0
2007-11-09 14:00:00	SPY	ETF	145.98	147.47	145.82	146.92	36961647.0
2007-11-09 15:00:00	SPY	ETF	146.91	147.54	145.26	145.27	53075934.0
2007-11-09 16:00:00	SPY	ETF	145.36	146.7	144.9	144.92	8029500.0
2007-11-09 17:00:00	SPY	ETF	144.91	145.16	144.85	145.07	59700.0
2007-11-09 18:00:00	SPY	ETF	145.0	145.25	145.0	145.14	11000.0
2007-11-09 19:00:00	SPY	ETF	145.1	145.1	144.85	144.85	13600.0
2007-11-09 05:00:00	QQQ	ETF	51.45	51.45	51.44	51.44	25000.0
2007-11-09 06:00:00	QQQ	ETF	51.25	51.25	51.03	51.08	727662.0
2007-11-09 07:00:00	QQQ	ETF	51.06	51.25	51.02	51.11	1254755.0
2007-11-09 08:00:00	QQQ	ETF	51.11	51.7737	50.7	50.85	4800808.0
2007-11-09 09:00:00	QQQ	ETF	50.86	50.86	50.28	50.67	47782302.0
2007-11-09 10:00:00	QQQ	ETF	50.67	50.92	50.43	50.52	53341563.0
2007-11-09 11:00:00	QQQ	ETF	50.52	50.78	50.18	50.69	41688312.0
2007-11-09 12:00:00	QQQ	ETF	50.6999	50.87	50.41	50.6194	25440470.0
2007-11-09 13:00:00	QQQ	ETF	50.61	50.73	50.4	50.41	19873570.0
2007-11-09 14:00:00	QQQ	ETF	50.4	51.0	50.35	50.8085	37712222.0
2007-11-09 15:00:00	QQQ	ETF	50.81	51.12	50.0	50.01	63582105.0
2007-11-09 16:00:00	QQQ	ETF	50.0	51.7826	49.88	49.9	11390286.0
2007-11-09 17:00:00	QQQ	ETF	49.9	49.97	49.89	49.94	114549.0
2007-11-09 18:00:00	QQQ	ETF	49.96	50.0	49.93	49.96	1656491.0
2007-11-09 19:00:00	QQQ	ETF	49.98	49.98	49.89	49.89	30725.0
2007-11-09 06:00:00	IWM	ETF	77.26	77.26	76.96	76.96	1000.0
2007-11-09 07:00:00	IWM	ETF	76.92	77.23	76.92	77.0	62800.0
2007-11-09 08:00:00	IWM	ETF	76.99	77.18	76.7	76.91	2020300.0
2007-11-09 09:00:00	IWM	ETF	76.84	76.86	76.13	76.39	10881040.0
2007-11-09 10:00:00	IWM	ETF	76.39	77.2	76.22	76.69	15759192.0
2007-11-09 11:00:00	IWM	ETF	76.69	76.97	76.15	76.93	11573465.0
2007-11-09 12:00:00	IWM	ETF	76.93	77.28	76.57	76.93	11802239.0
2007-11-09 13:00:00	IWM	ETF	76.94	77.01	76.54	76.77	10371008.0
2007-11-09 14:00:00	IWM	ETF	76.77	77.75	76.65	77.27	17231312.0
2007-11-09 15:00:00	IWM	ETF	77.27	77.71	76.65	76.84	19958466.0
2007-11-09 16:00:00	IWM	ETF	76.84	77.95	76.7	76.85	5022500.0
2007-11-09 17:00:00	IWM	ETF	76.75	76.9	76.75	76.85	2500.0
2007-11-09 07:00:00	DIA	ETF	131.54	131.89	131.43	131.47	52600.0
2007-11-09 08:00:00	DIA	ETF	131.51	131.7	131.31	131.58	68000.0
2007-11-09 09:00:00	DIA	ETF	131.6	131.63	130.88	131.05	2811403.0
2007-11-09 10:00:00	DIA	ETF	131.04	131.68	130.73	131.05	3918355.0
2007-11-09 11:00:00	DIA	ETF	131.03	131.48	130.25	131.45	3779349.0
2007-11-09 12:00:00	DIA	ETF	131.44	131.61	130.81	131.16	1698313.0
2007-11-09 13:00:00	DIA	ETF	131.15	131.33	130.8	130.95	1501343.0

> showing 50 of 3,099 rows — these rows as CSV

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