PREVIEW / etf_1hour / 2007-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-19.parquet
  size:    71 KB
  rows:    2,274

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-04-19 04:00:00	SPY	ETF	146.18	146.26	146.18	146.26	37100.0
2007-04-19 05:00:00	SPY	ETF	146.38	146.4	146.38	146.4	7200.0
2007-04-19 06:00:00	SPY	ETF	146.35	146.55	146.34	146.55	25800.0
2007-04-19 07:00:00	SPY	ETF	146.52	146.53	146.35	146.43	486100.0
2007-04-19 08:00:00	SPY	ETF	146.55	146.64	146.05	146.52	3248300.0
2007-04-19 09:00:00	SPY	ETF	146.51	146.83	146.36	146.71	17237222.0
2007-04-19 10:00:00	SPY	ETF	146.71	147.07	146.53	146.89	19887528.0
2007-04-19 11:00:00	SPY	ETF	146.9	147.2	146.75	147.13	12337196.0
2007-04-19 12:00:00	SPY	ETF	147.13	147.39	146.99	147.32	13525580.0
2007-04-19 13:00:00	SPY	ETF	147.33	147.4	147.21	147.32	5806829.0
2007-04-19 14:00:00	SPY	ETF	147.31	147.32	146.95	147.06	10840540.0
2007-04-19 15:00:00	SPY	ETF	147.07	147.21	146.88	147.03	14906541.0
2007-04-19 16:00:00	SPY	ETF	147.03	147.33	146.73	147.24	2993300.0
2007-04-19 17:00:00	SPY	ETF	147.31	147.35	147.05	147.28	405500.0
2007-04-19 18:00:00	SPY	ETF	147.28	147.33	147.26	147.27	12900.0
2007-04-19 19:00:00	SPY	ETF	146.95	147.35	146.95	147.35	23200.0
2007-04-19 04:00:00	QQQ	ETF	44.76	44.77	44.76	44.77	118590.0
2007-04-19 05:00:00	QQQ	ETF	44.78	44.78	44.78	44.78	100.0
2007-04-19 06:00:00	QQQ	ETF	44.79	44.85	44.79	44.85	41400.0
2007-04-19 07:00:00	QQQ	ETF	44.86	44.86	44.79	44.81	784519.0
2007-04-19 08:00:00	QQQ	ETF	44.8	44.89	44.8	44.86	2065418.0
2007-04-19 09:00:00	QQQ	ETF	44.85	44.94	44.72	44.9	14819424.0
2007-04-19 10:00:00	QQQ	ETF	44.9	45.07	44.86	44.99	18395700.0
2007-04-19 11:00:00	QQQ	ETF	44.99	45.16	44.95	45.12	12349800.0
2007-04-19 12:00:00	QQQ	ETF	45.13	45.22	44.98	45.19	11976200.0
2007-04-19 13:00:00	QQQ	ETF	45.2	45.25	45.13	45.15	6325400.0
2007-04-19 14:00:00	QQQ	ETF	45.15	45.18	45.03	45.03	9999400.0
2007-04-19 15:00:00	QQQ	ETF	45.03	45.09	44.95	45.06	14095700.0
2007-04-19 16:00:00	QQQ	ETF	45.07	45.18	44.94	45.15	3878157.0
2007-04-19 17:00:00	QQQ	ETF	45.15	45.2	45.15	45.17	349608.0
2007-04-19 18:00:00	QQQ	ETF	45.19	45.19	45.18	45.19	29975.0
2007-04-19 19:00:00	QQQ	ETF	45.19	45.21	45.19	45.21	50646.0
2007-04-19 07:00:00	IWM	ETF	81.18	81.18	81.1	81.13	31800.0
2007-04-19 08:00:00	IWM	ETF	81.15	81.28	80.98	81.17	914900.0
2007-04-19 09:00:00	IWM	ETF	81.16	81.34	80.8	81.17	14374915.0
2007-04-19 10:00:00	IWM	ETF	81.17	81.47	80.98	81.28	14866085.0
2007-04-19 11:00:00	IWM	ETF	81.27	81.59	80.98	81.51	7537910.0
2007-04-19 12:00:00	IWM	ETF	81.51	81.8	81.38	81.69	8847415.0
2007-04-19 13:00:00	IWM	ETF	81.69	81.83	81.57	81.62	4365075.0
2007-04-19 14:00:00	IWM	ETF	81.62	81.67	81.26	81.3	6965502.0
2007-04-19 15:00:00	IWM	ETF	81.31	81.45	81.17	81.27	7401969.0
2007-04-19 16:00:00	IWM	ETF	81.27	81.39	81.24	81.39	2453200.0
2007-04-19 17:00:00	IWM	ETF	81.4	81.46	81.37	81.37	79000.0
2007-04-19 18:00:00	IWM	ETF	81.47	81.49	81.44	81.44	58000.0
2007-04-19 07:00:00	DIA	ETF	127.46	127.46	127.36	127.38	31200.0
2007-04-19 08:00:00	DIA	ETF	127.43	127.52	127.42	127.45	90800.0
2007-04-19 09:00:00	DIA	ETF	127.43	127.8	127.27	127.69	1389300.0
2007-04-19 10:00:00	DIA	ETF	127.69	127.9	127.6	127.75	1879020.0
2007-04-19 11:00:00	DIA	ETF	127.76	128.01	127.63	127.93	1144978.0
2007-04-19 12:00:00	DIA	ETF	127.92	128.22	127.84	128.18	1181679.0

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

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