PREVIEW / etf_1hour / 2007-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-19.parquet
  size:    88 KB
  rows:    2,952

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-09-19 04:00:00	SPY	ETF	152.88	153.13	152.88	152.99	10500.0
2007-09-19 05:00:00	SPY	ETF	152.92	152.99	152.8	152.99	7200.0
2007-09-19 06:00:00	SPY	ETF	152.95	153.09	152.94	153.02	307200.0
2007-09-19 07:00:00	SPY	ETF	153.05	153.29	152.85	153.05	1347600.0
2007-09-19 08:00:00	SPY	ETF	153.01	153.5	152.93	153.4	3324900.0
2007-09-19 09:00:00	SPY	ETF	153.4	153.88	153.37	153.73	27083348.0
2007-09-19 10:00:00	SPY	ETF	153.73	154.05	153.58	154.01	31208300.0
2007-09-19 11:00:00	SPY	ETF	154.02	154.39	153.61	153.82	31448300.0
2007-09-19 12:00:00	SPY	ETF	153.83	153.88	153.48	153.72	12289800.0
2007-09-19 13:00:00	SPY	ETF	153.72	153.72	153.22	153.425	18939200.0
2007-09-19 14:00:00	SPY	ETF	153.42	153.49	152.71	153.34	26142400.0
2007-09-19 15:00:00	SPY	ETF	153.34	153.77	153.0	153.36	30267500.0
2007-09-19 16:00:00	SPY	ETF	153.36	153.4756	152.4409	153.09	5977000.0
2007-09-19 17:00:00	SPY	ETF	153.09	153.56	152.94	153.07	2557500.0
2007-09-19 18:00:00	SPY	ETF	153.07	153.1	153.0	153.09	36100.0
2007-09-19 19:00:00	SPY	ETF	153.1	153.11	153.0	153.04	12200.0
2007-09-19 04:00:00	QQQ	ETF	50.2	50.2	50.2	50.2	200.0
2007-09-19 05:00:00	QQQ	ETF	50.12	50.12	50.12	50.12	300.0
2007-09-19 06:00:00	QQQ	ETF	50.15	50.16	50.15	50.16	500.0
2007-09-19 07:00:00	QQQ	ETF	50.16	50.23	50.1	50.15	347973.0
2007-09-19 08:00:00	QQQ	ETF	50.15	50.33	50.14	50.29	1420870.0
2007-09-19 09:00:00	QQQ	ETF	50.29	50.42	50.27	50.3594	14127814.0
2007-09-19 10:00:00	QQQ	ETF	50.35	50.51	50.09	50.47	16053846.0
2007-09-19 11:00:00	QQQ	ETF	50.4715	50.59	50.35	50.38	15396808.0
2007-09-19 12:00:00	QQQ	ETF	50.37	50.45	50.33	50.39	6119820.0
2007-09-19 13:00:00	QQQ	ETF	50.39	50.4	50.15	50.24	15380751.0
2007-09-19 14:00:00	QQQ	ETF	50.24	50.27	49.98	50.16	20699288.0
2007-09-19 15:00:00	QQQ	ETF	50.16	50.29	50.09	50.19	16880415.0
2007-09-19 16:00:00	QQQ	ETF	50.17	50.2	50.08	50.1	1868923.0
2007-09-19 17:00:00	QQQ	ETF	50.09	50.09	50.02	50.05	196112.0
2007-09-19 18:00:00	QQQ	ETF	50.05	50.09	50.03	50.06	43093.0
2007-09-19 19:00:00	QQQ	ETF	50.05	50.17	50.04	50.05	162300.0
2007-09-19 04:00:00	IWM	ETF	80.85	80.85	80.85	80.85	100.0
2007-09-19 06:00:00	IWM	ETF	80.9	80.9	80.9	80.9	700.0
2007-09-19 07:00:00	IWM	ETF	80.94	81.06	80.89	81.0	121500.0
2007-09-19 08:00:00	IWM	ETF	80.97	81.23	80.92	81.21	1061500.0
2007-09-19 09:00:00	IWM	ETF	81.21	81.8	81.11	81.61	19936778.0
2007-09-19 10:00:00	IWM	ETF	81.61	81.82	77.26	81.79	15272600.0
2007-09-19 11:00:00	IWM	ETF	81.79	82.1	81.69	81.78	15926200.0
2007-09-19 12:00:00	IWM	ETF	81.78	81.82	81.63	81.74	10503000.0
2007-09-19 13:00:00	IWM	ETF	81.73	81.74	81.4	81.45	8066300.0
2007-09-19 14:00:00	IWM	ETF	81.45	81.6	81.09	81.45	11933200.0
2007-09-19 15:00:00	IWM	ETF	81.45	81.67	81.39	81.56	14727600.0
2007-09-19 16:00:00	IWM	ETF	81.56	81.7	81.5	81.5	1177600.0
2007-09-19 17:00:00	IWM	ETF	81.47	81.48	81.4	81.4	1400.0
2007-09-19 19:00:00	IWM	ETF	81.48	81.48	81.41	81.41	8800.0
2007-09-19 07:00:00	DIA	ETF	137.92	138.07	137.72	137.91	37300.0
2007-09-19 08:00:00	DIA	ETF	137.86	138.27	137.82	138.24	674200.0
2007-09-19 09:00:00	DIA	ETF	138.21	139.31	138.03	138.37	3324400.0
2007-09-19 10:00:00	DIA	ETF	138.37	138.57	138.22	138.55	2568300.0

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

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