PREVIEW / etf_1hour / 2007-10-15

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-15.parquet
  size:    89 KB
  rows:    2,988

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-15 05:00:00	SPY	ETF	156.45	156.45	156.42	156.42	30000.0
2007-10-15 06:00:00	SPY	ETF	156.28	156.28	156.23	156.23	82700.0
2007-10-15 07:00:00	SPY	ETF	156.22	156.26	156.03	156.15	533100.0
2007-10-15 08:00:00	SPY	ETF	156.17	156.46	156.12	156.39	820800.0
2007-10-15 09:00:00	SPY	ETF	156.38	156.38	155.73	155.78	14910990.0
2007-10-15 10:00:00	SPY	ETF	155.78	155.88	155.23	155.27	23850600.0
2007-10-15 11:00:00	SPY	ETF	155.27	155.28	154.6	154.99	25113100.0
2007-10-15 12:00:00	SPY	ETF	154.99	155.11	154.47	154.59	16403000.0
2007-10-15 13:00:00	SPY	ETF	154.59	154.68	154.22	154.57	18155650.0
2007-10-15 14:00:00	SPY	ETF	154.57	154.63	154.14	154.45	17919450.0
2007-10-15 15:00:00	SPY	ETF	154.44	154.9	153.94	154.83	31194130.0
2007-10-15 16:00:00	SPY	ETF	154.83	156.07	154.52	155.02	3709900.0
2007-10-15 17:00:00	SPY	ETF	155.01	155.05	154.95	155.0	1544200.0
2007-10-15 18:00:00	SPY	ETF	154.97	155.04	154.87	154.91	105000.0
2007-10-15 19:00:00	SPY	ETF	154.87	154.88	154.79	154.79	38000.0
2007-10-15 05:00:00	QQQ	ETF	53.63	53.64	53.63	53.64	2100.0
2007-10-15 06:00:00	QQQ	ETF	53.59	53.59	53.56	53.56	800.0
2007-10-15 07:00:00	QQQ	ETF	53.59	53.59	53.49	53.56	330050.0
2007-10-15 08:00:00	QQQ	ETF	53.56	53.69	53.53	53.63	974453.0
2007-10-15 09:00:00	QQQ	ETF	53.63	53.71	53.42	53.49	13436039.0
2007-10-15 10:00:00	QQQ	ETF	53.49	53.64	53.33	53.35	17577986.0
2007-10-15 11:00:00	QQQ	ETF	53.347	53.36	53.01	53.16	19295816.0
2007-10-15 12:00:00	QQQ	ETF	53.16	53.2	52.87	52.97	12635428.0
2007-10-15 13:00:00	QQQ	ETF	52.97	53.08	52.8	53.05	12797934.0
2007-10-15 14:00:00	QQQ	ETF	53.04	53.05	52.78	52.95	12931263.0
2007-10-15 15:00:00	QQQ	ETF	52.94	53.11	52.7	53.11	27067905.0
2007-10-15 16:00:00	QQQ	ETF	53.11	53.2	53.01	53.2	4026556.0
2007-10-15 17:00:00	QQQ	ETF	53.19	53.22	53.17	53.19	205696.0
2007-10-15 18:00:00	QQQ	ETF	53.21	53.21	53.12	53.14	292201.0
2007-10-15 19:00:00	QQQ	ETF	53.14	53.18	53.14	53.18	4440.0
2007-10-15 06:00:00	IWM	ETF	83.72	83.72	83.67	83.67	5400.0
2007-10-15 07:00:00	IWM	ETF	83.69	83.72	83.65	83.65	14800.0
2007-10-15 08:00:00	IWM	ETF	83.65	83.92	83.65	83.86	247000.0
2007-10-15 09:00:00	IWM	ETF	83.86	83.87	83.2	83.23	5509300.0
2007-10-15 10:00:00	IWM	ETF	83.24	83.45	82.67	82.72	14622700.0
2007-10-15 11:00:00	IWM	ETF	82.72	83.0	82.47	82.91	13554356.0
2007-10-15 12:00:00	IWM	ETF	82.9	83.0	82.2	82.36	11666900.0
2007-10-15 13:00:00	IWM	ETF	82.36	82.55	82.19	82.51	7850600.0
2007-10-15 14:00:00	IWM	ETF	82.52	82.52	82.09	82.34	8292300.0
2007-10-15 15:00:00	IWM	ETF	82.34	82.64	82.03	82.61	15643300.0
2007-10-15 16:00:00	IWM	ETF	82.61	83.09	82.49	82.99	3467600.0
2007-10-15 17:00:00	IWM	ETF	82.95	82.97	82.94	82.94	8900.0
2007-10-15 18:00:00	IWM	ETF	82.99	82.99	82.85	82.85	2700.0
2007-10-15 19:00:00	IWM	ETF	82.86	82.86	82.86	82.86	3000.0
2007-10-15 07:00:00	DIA	ETF	140.95	140.95	140.95	140.95	900.0
2007-10-15 08:00:00	DIA	ETF	141.04	141.24	141.04	141.21	13900.0
2007-10-15 09:00:00	DIA	ETF	141.17	141.17	140.52	140.56	990200.0
2007-10-15 10:00:00	DIA	ETF	140.54	140.57	140.04	140.07	1758300.0
2007-10-15 11:00:00	DIA	ETF	140.06	140.07	139.42	139.8	2671300.0
2007-10-15 12:00:00	DIA	ETF	139.81	139.91	139.4	139.5	1456700.0

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

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