PREVIEW / etf_1hour / 2007-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-05.parquet
  size:    87 KB
  rows:    2,890

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-10-05 05:00:00	SPY	ETF	154.38	154.38	154.38	154.38	10000.0
2007-10-05 06:00:00	SPY	ETF	154.5	154.53	154.48	154.53	52600.0
2007-10-05 07:00:00	SPY	ETF	154.43	154.68	154.41	154.62	521600.0
2007-10-05 08:00:00	SPY	ETF	154.62	155.25	153.79	155.01	15323000.0
2007-10-05 09:00:00	SPY	ETF	155.01	155.14	154.68	154.93	16903406.0
2007-10-05 10:00:00	SPY	ETF	154.92	155.06	154.63	154.93	18514800.0
2007-10-05 11:00:00	SPY	ETF	154.92	155.53	154.92	155.49	17438200.0
2007-10-05 12:00:00	SPY	ETF	155.5	155.505	155.33	155.409	5621400.0
2007-10-05 13:00:00	SPY	ETF	155.4	155.8	155.27	155.69	17197900.0
2007-10-05 14:00:00	SPY	ETF	155.69	156.07	155.69	155.99	14808800.0
2007-10-05 15:00:00	SPY	ETF	155.98	156.1	155.49	155.6	21590700.0
2007-10-05 16:00:00	SPY	ETF	155.63	156.0	154.16	155.94	4650800.0
2007-10-05 17:00:00	SPY	ETF	155.97	156.06	155.92	156.04	39700.0
2007-10-05 18:00:00	SPY	ETF	156.0	156.0	155.95	155.95	1400.0
2007-10-05 19:00:00	SPY	ETF	156.0	156.0	156.0	156.0	1500.0
2007-10-05 04:00:00	QQQ	ETF	51.8	51.8	51.8	51.8	100.0
2007-10-05 06:00:00	QQQ	ETF	51.8	51.8	51.8	51.8	100.0
2007-10-05 07:00:00	QQQ	ETF	51.8	51.94	51.79	51.91	233811.0
2007-10-05 08:00:00	QQQ	ETF	51.91	52.18	51.8	52.08	8373780.0
2007-10-05 09:00:00	QQQ	ETF	52.09	52.26	52.0	52.14	17463674.0
2007-10-05 10:00:00	QQQ	ETF	52.14	52.35	52.07	52.3372	21639897.0
2007-10-05 11:00:00	QQQ	ETF	52.3325	52.7	52.3325	52.679	23553183.0
2007-10-05 12:00:00	QQQ	ETF	52.67	52.7	52.6	52.6726	7065840.0
2007-10-05 13:00:00	QQQ	ETF	52.68	52.85	52.61	52.7885	9493064.0
2007-10-05 14:00:00	QQQ	ETF	52.79	52.9	52.77	52.8391	8541620.0
2007-10-05 15:00:00	QQQ	ETF	52.83	52.86	52.69	52.82	17639017.0
2007-10-05 16:00:00	QQQ	ETF	52.83	52.98	52.38	52.94	1914692.0
2007-10-05 17:00:00	QQQ	ETF	52.94	52.97	52.89	52.95	23416.0
2007-10-05 18:00:00	QQQ	ETF	52.95	52.97	52.92	52.97	8703.0
2007-10-05 19:00:00	QQQ	ETF	52.97	52.97	52.91	52.93	7221.0
2007-10-05 07:00:00	IWM	ETF	82.74	82.89	82.74	82.89	66200.0
2007-10-05 08:00:00	IWM	ETF	82.84	83.54	82.81	83.45	2843400.0
2007-10-05 09:00:00	IWM	ETF	83.45	83.51	83.12	83.26	9506348.0
2007-10-05 10:00:00	IWM	ETF	83.25	83.37	82.98	83.24	8010100.0
2007-10-05 11:00:00	IWM	ETF	83.24	84.1	83.24	84.07	15598800.0
2007-10-05 12:00:00	IWM	ETF	84.07	84.15	83.88	83.98	8784600.0
2007-10-05 13:00:00	IWM	ETF	83.99	84.15	83.84	84.08	8338500.0
2007-10-05 14:00:00	IWM	ETF	84.09	84.35	84.02	84.25	7778300.0
2007-10-05 15:00:00	IWM	ETF	84.24	84.42	83.96	84.0	13096500.0
2007-10-05 16:00:00	IWM	ETF	83.99	84.15	83.99	84.0	13067000.0
2007-10-05 17:00:00	IWM	ETF	84.0	84.15	84.0	84.15	5002900.0
2007-10-05 18:00:00	IWM	ETF	84.17	84.17	84.17	84.17	1000.0
2007-10-05 07:00:00	DIA	ETF	139.88	139.97	139.88	139.97	1200.0
2007-10-05 08:00:00	DIA	ETF	139.97	140.6	139.97	140.43	260100.0
2007-10-05 09:00:00	DIA	ETF	140.47	140.57	140.15	140.47	1490600.0
2007-10-05 10:00:00	DIA	ETF	140.47	140.47	140.14	140.28	1516100.0
2007-10-05 11:00:00	DIA	ETF	140.31	140.83	140.31	140.8	1081900.0
2007-10-05 12:00:00	DIA	ETF	140.78	140.79	140.56	140.72	442100.0
2007-10-05 13:00:00	DIA	ETF	140.7	140.92	140.57	140.85	635800.0
2007-10-05 14:00:00	DIA	ETF	140.85	141.12	140.84	141.09	1120300.0

> showing 50 of 2,890 rows — these rows as CSV

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