PREVIEW / etf_1hour / 2007-12-18

all etf 1-hour files

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

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-18 04:00:00	SPY	ETF	145.7	145.79	145.7	145.79	4000.0
2007-12-18 05:00:00	SPY	ETF	145.84	146.23	145.84	146.23	9700.0
2007-12-18 06:00:00	SPY	ETF	146.29	146.39	146.21	146.26	123000.0
2007-12-18 07:00:00	SPY	ETF	146.22	146.55	146.14	146.39	1057800.0
2007-12-18 08:00:00	SPY	ETF	145.14	146.57	145.14	146.23	4609436.0
2007-12-18 09:00:00	SPY	ETF	146.22	146.29	145.8	146.04	21930919.0
2007-12-18 10:00:00	SPY	ETF	146.04	146.06	145.08	145.56	30938227.0
2007-12-18 11:00:00	SPY	ETF	145.56	145.65	144.27	144.41	33499228.0
2007-12-18 12:00:00	SPY	ETF	144.41	144.72	143.96	144.54	33877179.0
2007-12-18 13:00:00	SPY	ETF	144.53	145.76	144.31	145.3	28708641.0
2007-12-18 14:00:00	SPY	ETF	145.31	146.32	145.24	145.8	46576841.0
2007-12-18 15:00:00	SPY	ETF	145.8	146.48	145.71	145.82	35022351.0
2007-12-18 16:00:00	SPY	ETF	145.81	148.0684	145.64	146.15	5627200.0
2007-12-18 17:00:00	SPY	ETF	146.15	146.21	145.6016	146.12	191000.0
2007-12-18 18:00:00	SPY	ETF	146.16	146.29	146.16	146.29	11100.0
2007-12-18 19:00:00	SPY	ETF	146.23	146.29	146.17	146.17	8400.0
2007-12-18 05:00:00	QQQ	ETF	50.08	50.15	50.08	50.15	300.0
2007-12-18 06:00:00	QQQ	ETF	50.21	50.26	50.21	50.24	2900.0
2007-12-18 07:00:00	QQQ	ETF	50.2	50.29	50.13	50.21	266220.0
2007-12-18 08:00:00	QQQ	ETF	50.24	50.35	50.13	50.24	2211248.0
2007-12-18 09:00:00	QQQ	ETF	50.22	50.37	49.94	50.09	14481643.0
2007-12-18 10:00:00	QQQ	ETF	50.09	50.1	49.72	49.9	24185968.0
2007-12-18 11:00:00	QQQ	ETF	49.89	49.95	49.32	49.355	21095417.0
2007-12-18 12:00:00	QQQ	ETF	49.355	49.57	49.18	49.51	19119318.0
2007-12-18 13:00:00	QQQ	ETF	49.51	50.1	49.44	49.97	26901771.0
2007-12-18 14:00:00	QQQ	ETF	49.97	50.26	49.89	49.97	23460334.0
2007-12-18 15:00:00	QQQ	ETF	49.9694	50.17	49.86	49.94	19604688.0
2007-12-18 16:00:00	QQQ	ETF	49.94	50.065	49.88	49.95	2862277.0
2007-12-18 17:00:00	QQQ	ETF	49.97	50.0	49.97	50.0	21441.0
2007-12-18 18:00:00	QQQ	ETF	50.0	50.03	50.0	50.0	7801.0
2007-12-18 19:00:00	QQQ	ETF	50.03	50.05	50.0	50.03	30300.0
2007-12-18 06:00:00	IWM	ETF	74.84	74.84	74.77	74.77	6500.0
2007-12-18 07:00:00	IWM	ETF	74.7	74.92	74.64	74.7	223300.0
2007-12-18 08:00:00	IWM	ETF	74.83	74.9	74.64	74.74	902200.0
2007-12-18 09:00:00	IWM	ETF	74.75	74.82	74.3	74.49	10198804.0
2007-12-18 10:00:00	IWM	ETF	74.49	74.53	73.98	74.34	12311760.0
2007-12-18 11:00:00	IWM	ETF	74.34	74.38	73.49	73.57	10054842.0
2007-12-18 12:00:00	IWM	ETF	73.57	73.78	73.35	73.68	9382350.0
2007-12-18 13:00:00	IWM	ETF	73.67	74.66	73.55	74.38	17104275.0
2007-12-18 14:00:00	IWM	ETF	74.38	75.19	74.34	74.81	23898102.0
2007-12-18 15:00:00	IWM	ETF	74.81	75.39	74.78	75.34	26132803.0
2007-12-18 16:00:00	IWM	ETF	75.35	75.41	73.74	73.74	6759100.0
2007-12-18 17:00:00	IWM	ETF	75.29	75.32	75.29	75.32	1300.0
2007-12-18 18:00:00	IWM	ETF	75.32	75.34	75.32	75.34	1400.0
2007-12-18 19:00:00	IWM	ETF	75.36	75.36	75.36	75.36	1000.0
2007-12-18 07:00:00	DIA	ETF	132.71	132.98	132.66	132.92	25600.0
2007-12-18 08:00:00	DIA	ETF	132.9	132.98	132.61	132.73	72400.0
2007-12-18 09:00:00	DIA	ETF	132.75	132.78	132.34	132.56	1508080.0
2007-12-18 10:00:00	DIA	ETF	132.55	132.57	131.8	132.2	1720200.0
2007-12-18 11:00:00	DIA	ETF	132.19	132.28	131.3	131.36	1957969.0

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

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