PREVIEW / etf_1hour / 2007-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-18.parquet
  size:    83 KB
  rows:    2,798

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-18 05:00:00	SPY	ETF	154.04	154.05	154.04	154.05	20000.0
2007-07-18 06:00:00	SPY	ETF	154.16	154.21	154.05	154.16	459900.0
2007-07-18 07:00:00	SPY	ETF	154.23	154.45	154.16	154.22	1212200.0
2007-07-18 08:00:00	SPY	ETF	154.18	154.3	153.85	154.18	4646200.0
2007-07-18 09:00:00	SPY	ETF	154.18	154.73	154.08	154.49	29668828.0
2007-07-18 10:00:00	SPY	ETF	154.48	154.78	153.5	153.96	48883914.0
2007-07-18 11:00:00	SPY	ETF	153.95	154.33	153.5	153.74	28925482.0
2007-07-18 12:00:00	SPY	ETF	153.75	153.97	153.3	153.79	23332573.0
2007-07-18 13:00:00	SPY	ETF	153.8	154.19	153.5	153.85	25039235.0
2007-07-18 14:00:00	SPY	ETF	153.85	154.03	153.5	153.78	21908964.0
2007-07-18 15:00:00	SPY	ETF	153.78	154.8	153.62	154.59	36251058.0
2007-07-18 16:00:00	SPY	ETF	154.58	154.67	154.36	154.6	6509700.0
2007-07-18 17:00:00	SPY	ETF	154.65	154.9	154.65	154.74	132400.0
2007-07-18 18:00:00	SPY	ETF	154.74	154.87	153.72	154.75	5658500.0
2007-07-18 19:00:00	SPY	ETF	154.78	154.78	154.6	154.62	129600.0
2007-07-18 04:00:00	QQQ	ETF	49.88	49.88	49.88	49.88	300.0
2007-07-18 06:00:00	QQQ	ETF	49.94	49.96	49.94	49.96	30200.0
2007-07-18 07:00:00	QQQ	ETF	49.97	50.0	49.85	49.87	1128566.0
2007-07-18 08:00:00	QQQ	ETF	49.87	49.98	49.79	49.91	4176049.0
2007-07-18 09:00:00	QQQ	ETF	49.92	50.02	48.93	49.96	18329878.0
2007-07-18 10:00:00	QQQ	ETF	49.97	50.03	49.76	49.842	26578158.0
2007-07-18 11:00:00	QQQ	ETF	49.8401	49.94	49.76	49.78	18183361.0
2007-07-18 12:00:00	QQQ	ETF	49.77	49.85	49.64	49.78	17301322.0
2007-07-18 13:00:00	QQQ	ETF	49.77	49.92	49.7	49.85	13000318.0
2007-07-18 14:00:00	QQQ	ETF	49.86	49.92	49.74	49.83	9535091.0
2007-07-18 15:00:00	QQQ	ETF	49.83	50.13	49.76	50.12	25722980.0
2007-07-18 16:00:00	QQQ	ETF	50.12	50.25	50.07	50.2	2852487.0
2007-07-18 17:00:00	QQQ	ETF	50.22	50.33	50.17	50.25	665456.0
2007-07-18 18:00:00	QQQ	ETF	50.24	50.33	50.05	50.29	810672.0
2007-07-18 19:00:00	QQQ	ETF	50.3	50.32	50.25	50.26	43960.0
2007-07-18 07:00:00	IWM	ETF	84.24	84.3	84.14	84.17	255800.0
2007-07-18 08:00:00	IWM	ETF	84.15	84.26	83.95	84.05	2354400.0
2007-07-18 09:00:00	IWM	ETF	84.05	84.3	83.82	84.0	7601812.0
2007-07-18 10:00:00	IWM	ETF	84.0	84.11	83.47	83.65	15977400.0
2007-07-18 11:00:00	IWM	ETF	83.64	83.8	83.35	83.39	13474354.0
2007-07-18 12:00:00	IWM	ETF	83.39	83.6	83.09	83.52	14081791.0
2007-07-18 13:00:00	IWM	ETF	83.52	83.83	83.34	83.6	8060703.0
2007-07-18 14:00:00	IWM	ETF	83.6	83.76	83.42	83.62	5796082.0
2007-07-18 15:00:00	IWM	ETF	83.63	84.22	83.49	84.17	14838344.0
2007-07-18 16:00:00	IWM	ETF	84.17	84.43	84.07	84.38	2904100.0
2007-07-18 17:00:00	IWM	ETF	84.4	84.54	84.24	84.4	5312300.0
2007-07-18 18:00:00	IWM	ETF	84.48	84.5	84.03	84.5	313100.0
2007-07-18 07:00:00	DIA	ETF	139.35	139.45	139.29	139.29	4600.0
2007-07-18 08:00:00	DIA	ETF	139.3	139.55	139.24	139.3	202500.0
2007-07-18 09:00:00	DIA	ETF	139.3	139.62	139.12	139.47	2222965.0
2007-07-18 10:00:00	DIA	ETF	139.48	139.7	138.75	139.0	3631450.0
2007-07-18 11:00:00	DIA	ETF	139.0	139.26	138.65	138.81	3053623.0
2007-07-18 12:00:00	DIA	ETF	138.8	138.91	138.28	138.71	2566014.0
2007-07-18 13:00:00	DIA	ETF	138.7	138.97	138.42	138.67	2546900.0
2007-07-18 14:00:00	DIA	ETF	138.68	138.79	138.4	138.66	1847219.0

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

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