PREVIEW / etf_1hour / 2007-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-17.parquet
  size:    81 KB
  rows:    2,779

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-07-17 04:00:00	SPY	ETF	154.75	154.75	154.75	154.75	100.0
2007-07-17 05:00:00	SPY	ETF	154.5	154.5	154.5	154.5	1000.0
2007-07-17 06:00:00	SPY	ETF	154.56	154.67	154.56	154.67	8000.0
2007-07-17 07:00:00	SPY	ETF	154.73	155.05	154.57	154.96	282100.0
2007-07-17 08:00:00	SPY	ETF	154.89	155.1	154.5	155.0	3035200.0
2007-07-17 09:00:00	SPY	ETF	155.0	155.48	154.89	155.32	15468189.0
2007-07-17 10:00:00	SPY	ETF	155.33	156.0	155.01	155.32	17564900.0
2007-07-17 11:00:00	SPY	ETF	155.33	155.46	155.02	155.17	16471841.0
2007-07-17 12:00:00	SPY	ETF	155.17	155.22	154.68	154.84	15839926.0
2007-07-17 13:00:00	SPY	ETF	154.84	155.29	154.7	155.13	13238139.0
2007-07-17 14:00:00	SPY	ETF	155.12	155.48	155.07	155.4	11977037.0
2007-07-17 15:00:00	SPY	ETF	155.4	155.41	154.85	154.85	19491606.0
2007-07-17 16:00:00	SPY	ETF	154.85	155.2613	154.38	154.41	5876700.0
2007-07-17 17:00:00	SPY	ETF	154.42	154.52	153.35	153.41	3040200.0
2007-07-17 18:00:00	SPY	ETF	153.43	154.75	153.4	153.94	1546900.0
2007-07-17 19:00:00	SPY	ETF	153.9	154.01	153.86	153.87	64900.0
2007-07-17 07:00:00	QQQ	ETF	49.82	49.96	49.82	49.95	456584.0
2007-07-17 08:00:00	QQQ	ETF	49.95	49.99	49.86	49.95	1774906.0
2007-07-17 09:00:00	QQQ	ETF	49.96	50.08	49.94	50.0485	12420289.0
2007-07-17 10:00:00	QQQ	ETF	50.04	50.09	49.92	50.07	18193212.0
2007-07-17 11:00:00	QQQ	ETF	50.07	50.13	49.98	50.0485	12548219.0
2007-07-17 12:00:00	QQQ	ETF	50.05	50.07	49.93	50.0	9862922.0
2007-07-17 13:00:00	QQQ	ETF	49.99	50.21	49.97	50.1795	16443214.0
2007-07-17 14:00:00	QQQ	ETF	50.18	50.3	50.17	50.2605	17143340.0
2007-07-17 15:00:00	QQQ	ETF	50.27	50.28	50.18	50.21	15885442.0
2007-07-17 16:00:00	QQQ	ETF	50.2	50.27	49.93	50.0	8388316.0
2007-07-17 17:00:00	QQQ	ETF	50.0	50.03	49.76	49.79	5680151.0
2007-07-17 18:00:00	QQQ	ETF	49.82	49.94	49.82	49.84	654007.0
2007-07-17 19:00:00	QQQ	ETF	49.84	49.9	49.83	49.88	91255.0
2007-07-17 07:00:00	IWM	ETF	84.45	84.64	84.45	84.64	38300.0
2007-07-17 08:00:00	IWM	ETF	84.64	84.66	84.43	84.54	544300.0
2007-07-17 09:00:00	IWM	ETF	84.62	85.01	84.6	84.81	6220900.0
2007-07-17 10:00:00	IWM	ETF	84.81	84.99	84.69	84.92	7072182.0
2007-07-17 11:00:00	IWM	ETF	84.93	85.06	84.72	84.85	5417538.0
2007-07-17 12:00:00	IWM	ETF	84.85	84.86	84.53	84.67	3862030.0
2007-07-17 13:00:00	IWM	ETF	84.68	84.92	84.59	84.85	4244900.0
2007-07-17 14:00:00	IWM	ETF	84.85	85.05	84.79	85.01	6928878.0
2007-07-17 15:00:00	IWM	ETF	85.0	85.04	84.51	84.51	13292297.0
2007-07-17 16:00:00	IWM	ETF	84.51	84.9	84.24	84.24	4066200.0
2007-07-17 17:00:00	IWM	ETF	84.25	84.3	83.6	83.6	179800.0
2007-07-17 18:00:00	IWM	ETF	83.7	84.12	83.7	84.02	158400.0
2007-07-17 19:00:00	IWM	ETF	84.05	84.09	84.05	84.09	2100.0
2007-07-17 07:00:00	DIA	ETF	139.34	139.57	139.34	139.57	4000.0
2007-07-17 08:00:00	DIA	ETF	139.57	139.7	139.52	139.6	74400.0
2007-07-17 09:00:00	DIA	ETF	139.72	140.85	139.53	139.86	2139500.0
2007-07-17 10:00:00	DIA	ETF	139.85	140.0	139.65	139.94	2574801.0
2007-07-17 11:00:00	DIA	ETF	139.95	140.07	139.77	139.9	1484150.0
2007-07-17 12:00:00	DIA	ETF	139.91	139.96	139.66	139.79	1055300.0
2007-07-17 13:00:00	DIA	ETF	139.77	140.07	139.67	139.98	1348159.0
2007-07-17 14:00:00	DIA	ETF	139.98	140.17	139.94	140.11	1402307.0

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

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