PREVIEW / etf_1hour / 2007-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-16.parquet
  size:    82 KB
  rows:    2,769

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-16 05:00:00	SPY	ETF	155.13	155.13	155.13	155.13	15000.0
2007-07-16 06:00:00	SPY	ETF	154.91	154.96	154.91	154.96	12700.0
2007-07-16 07:00:00	SPY	ETF	154.85	154.9	154.72	154.8	272100.0
2007-07-16 08:00:00	SPY	ETF	154.78	155.1	154.74	154.88	2586200.0
2007-07-16 09:00:00	SPY	ETF	154.88	155.2	154.84	155.04	16114699.0
2007-07-16 10:00:00	SPY	ETF	155.04	155.42	154.87	155.35	13876268.0
2007-07-16 11:00:00	SPY	ETF	155.34	155.53	155.25	155.44	8143039.0
2007-07-16 12:00:00	SPY	ETF	155.45	155.47	155.23	155.35	6148118.0
2007-07-16 13:00:00	SPY	ETF	155.36	155.4	154.6	154.6999	16222709.0
2007-07-16 14:00:00	SPY	ETF	154.69	155.03	154.58	155.0	14254788.0
2007-07-16 15:00:00	SPY	ETF	155.0	155.17	154.72	154.9	17112175.0
2007-07-16 16:00:00	SPY	ETF	154.91	155.41	154.76	154.87	2260800.0
2007-07-16 17:00:00	SPY	ETF	154.87	154.89	154.83	154.83	9200.0
2007-07-16 18:00:00	SPY	ETF	154.86	154.9	154.81	154.82	22900.0
2007-07-16 19:00:00	SPY	ETF	154.85	154.9	154.85	154.85	4600.0
2007-07-16 04:00:00	QQQ	ETF	49.9	49.9	49.9	49.9	500.0
2007-07-16 07:00:00	QQQ	ETF	49.84	49.87	49.78	49.81	383991.0
2007-07-16 08:00:00	QQQ	ETF	49.84	49.94	49.82	49.88	880710.0
2007-07-16 09:00:00	QQQ	ETF	49.88	49.98	49.84	49.9185	9624126.0
2007-07-16 10:00:00	QQQ	ETF	49.91	50.06	49.87	50.05	12520815.0
2007-07-16 11:00:00	QQQ	ETF	50.05	50.08	50.0	50.05	7028646.0
2007-07-16 12:00:00	QQQ	ETF	50.06	50.08	49.98	50.01	5822702.0
2007-07-16 13:00:00	QQQ	ETF	50.02	50.05	49.78	49.8	10980336.0
2007-07-16 14:00:00	QQQ	ETF	49.805	49.94	49.76	49.91	10048608.0
2007-07-16 15:00:00	QQQ	ETF	49.91	49.97	49.8	49.86	15277527.0
2007-07-16 16:00:00	QQQ	ETF	49.85	49.92	49.85	49.9	1381580.0
2007-07-16 17:00:00	QQQ	ETF	49.91	49.92	49.9	49.92	7000.0
2007-07-16 18:00:00	QQQ	ETF	49.92	49.92	49.89	49.89	9450.0
2007-07-16 19:00:00	QQQ	ETF	49.91	49.92	49.85	49.89	129360.0
2007-07-16 07:00:00	IWM	ETF	84.83	84.85	84.79	84.8	68200.0
2007-07-16 08:00:00	IWM	ETF	84.82	85.01	84.8	84.88	764200.0
2007-07-16 09:00:00	IWM	ETF	84.84	84.98	84.7	84.82	7882099.0
2007-07-16 10:00:00	IWM	ETF	84.82	85.08	84.68	85.0	14152000.0
2007-07-16 11:00:00	IWM	ETF	85.01	85.16	84.81	85.09	7332300.0
2007-07-16 12:00:00	IWM	ETF	85.09	85.09	84.84	84.95	5632775.0
2007-07-16 13:00:00	IWM	ETF	84.95	84.97	84.27	84.35	10749595.0
2007-07-16 14:00:00	IWM	ETF	84.35	84.51	84.28	84.44	9310425.0
2007-07-16 15:00:00	IWM	ETF	84.43	84.61	84.22	84.37	11722747.0
2007-07-16 16:00:00	IWM	ETF	84.37	84.51	84.36	84.44	3474100.0
2007-07-16 17:00:00	IWM	ETF	84.47	84.55	84.47	84.48	508900.0
2007-07-16 18:00:00	IWM	ETF	84.52	84.54	84.48	84.49	42300.0
2007-07-16 07:00:00	DIA	ETF	138.9	139.0	138.9	138.91	2900.0
2007-07-16 08:00:00	DIA	ETF	138.93	139.05	138.93	139.0	3000.0
2007-07-16 09:00:00	DIA	ETF	138.96	139.33	138.91	139.25	695700.0
2007-07-16 10:00:00	DIA	ETF	139.24	139.63	139.12	139.6	2002100.0
2007-07-16 11:00:00	DIA	ETF	139.6	139.8	139.53	139.76	1333820.0
2007-07-16 12:00:00	DIA	ETF	139.76	139.83	139.63	139.78	1051700.0
2007-07-16 13:00:00	DIA	ETF	139.8	139.86	139.26	139.35	1895100.0
2007-07-16 14:00:00	DIA	ETF	139.34	139.59	139.19	139.59	1873600.0
2007-07-16 15:00:00	DIA	ETF	139.58	139.73	139.41	139.47	1555900.0

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

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