PREVIEW / etf_1hour / 2007-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-12.parquet
  size:    96 KB
  rows:    3,203

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-12-12 04:00:00	SPY	ETF	149.27	149.44	149.22	149.22	33600.0
2007-12-12 05:00:00	SPY	ETF	149.3	149.3	149.13	149.13	2500.0
2007-12-12 06:00:00	SPY	ETF	149.22	149.56	149.22	149.49	381300.0
2007-12-12 07:00:00	SPY	ETF	149.45	149.74	149.1	149.58	2612200.0
2007-12-12 08:00:00	SPY	ETF	149.59	149.68	148.26	149.41	8034700.0
2007-12-12 09:00:00	SPY	ETF	149.4	152.0	149.4	150.93	74763061.0
2007-12-12 10:00:00	SPY	ETF	150.93	150.95	149.86	149.87	35708240.0
2007-12-12 11:00:00	SPY	ETF	149.86	150.58	149.85	150.15	26473841.0
2007-12-12 12:00:00	SPY	ETF	150.14	150.22	148.86	149.25	25474849.0
2007-12-12 13:00:00	SPY	ETF	149.25	151.32	148.93	149.7	25501026.0
2007-12-12 14:00:00	SPY	ETF	149.707	149.91	148.97	149.0	22799861.0
2007-12-12 15:00:00	SPY	ETF	148.97	149.23	147.2	149.16	79939182.0
2007-12-12 16:00:00	SPY	ETF	149.2	150.61	147.58	149.44	13305000.0
2007-12-12 17:00:00	SPY	ETF	149.45	149.46	148.18	149.37	1135800.0
2007-12-12 18:00:00	SPY	ETF	149.36	149.38	149.14	149.15	109300.0
2007-12-12 19:00:00	SPY	ETF	149.14	149.26	149.1	149.23	44200.0
2007-12-12 04:00:00	QQQ	ETF	51.72	51.72	51.72	51.72	300.0
2007-12-12 06:00:00	QQQ	ETF	51.7	51.8	51.7	51.77	203300.0
2007-12-12 07:00:00	QQQ	ETF	51.74	51.91	51.66	51.82	813500.0
2007-12-12 08:00:00	QQQ	ETF	51.82	51.9	51.69	51.71	3450977.0
2007-12-12 09:00:00	QQQ	ETF	51.73	52.43	51.73	52.24	27218007.0
2007-12-12 10:00:00	QQQ	ETF	52.2302	52.32	52.0	52.01	20586428.0
2007-12-12 11:00:00	QQQ	ETF	52.0	52.25	52.0	52.17	13970020.0
2007-12-12 12:00:00	QQQ	ETF	52.17	52.18	51.62	51.8	17155652.0
2007-12-12 13:00:00	QQQ	ETF	51.8	52.02	51.68	51.95	9943178.0
2007-12-12 14:00:00	QQQ	ETF	51.95	52.03	51.7	51.7	12876023.0
2007-12-12 15:00:00	QQQ	ETF	51.7	51.81	50.89	51.81	53115686.0
2007-12-12 16:00:00	QQQ	ETF	51.82	52.3	51.69	51.77	3395894.0
2007-12-12 17:00:00	QQQ	ETF	51.76	51.82	51.75	51.82	166730.0
2007-12-12 18:00:00	QQQ	ETF	51.77	51.77	51.71	51.71	98776.0
2007-12-12 19:00:00	QQQ	ETF	51.72	51.74	51.68	51.69	30654.0
2007-12-12 06:00:00	IWM	ETF	77.05	77.1	77.05	77.1	20000.0
2007-12-12 07:00:00	IWM	ETF	77.05	77.21	76.85	77.14	105000.0
2007-12-12 08:00:00	IWM	ETF	77.1	77.21	76.85	76.99	1226300.0
2007-12-12 09:00:00	IWM	ETF	77.0	78.81	77.0	78.15	17639284.0
2007-12-12 10:00:00	IWM	ETF	78.15	78.15	77.58	77.65	10716900.0
2007-12-12 11:00:00	IWM	ETF	77.65	77.94	77.55	77.66	12987900.0
2007-12-12 12:00:00	IWM	ETF	77.66	77.71	76.79	77.02	9158600.0
2007-12-12 13:00:00	IWM	ETF	77.02	77.48	76.85	77.39	8355800.0
2007-12-12 14:00:00	IWM	ETF	77.39	77.55	76.95	76.95	7349100.0
2007-12-12 15:00:00	IWM	ETF	76.95	77.02	76.09	76.94	32876200.0
2007-12-12 16:00:00	IWM	ETF	76.94	77.16	76.43	77.04	13582900.0
2007-12-12 17:00:00	IWM	ETF	77.05	77.05	76.9	76.9	10000.0
2007-12-12 18:00:00	IWM	ETF	76.97	77.03	76.97	77.03	9400.0
2007-12-12 19:00:00	IWM	ETF	76.93	76.93	76.86	76.92	5000.0
2007-12-12 04:00:00	DIA	ETF	138.0	138.0	133.99	133.99	200.0
2007-12-12 07:00:00	DIA	ETF	135.25	135.67	135.25	135.61	192100.0
2007-12-12 08:00:00	DIA	ETF	135.56	135.64	135.21	135.41	79300.0
2007-12-12 09:00:00	DIA	ETF	135.44	137.32	135.44	136.6	2599089.0
2007-12-12 10:00:00	DIA	ETF	136.56	136.58	135.59	135.59	1732700.0

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

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