PREVIEW / etf_1hour / 2007-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-17.parquet
  size:    62 KB
  rows:    1,958

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-01-17 05:00:00	SPY	ETF	143.05	143.05	143.04	143.04	10000.0
2007-01-17 07:00:00	SPY	ETF	143.1	143.22	143.1	143.12	6900.0
2007-01-17 08:00:00	SPY	ETF	143.13	143.18	142.71	142.75	1267300.0
2007-01-17 09:00:00	SPY	ETF	142.73	143.16	142.73	143.08	6702100.0
2007-01-17 10:00:00	SPY	ETF	143.08	143.08	142.75	142.95	6900500.0
2007-01-17 11:00:00	SPY	ETF	142.97	143.29	142.95	143.24	4504100.0
2007-01-17 12:00:00	SPY	ETF	143.23	143.43	143.22	143.35	5252100.0
2007-01-17 13:00:00	SPY	ETF	143.36	143.4	143.17	143.27	3522500.0
2007-01-17 14:00:00	SPY	ETF	143.26	143.46	142.83	143.05	8557600.0
2007-01-17 15:00:00	SPY	ETF	143.06	143.06	142.73	143.0	7534000.0
2007-01-17 16:00:00	SPY	ETF	143.03	143.14	142.92	143.01	1813400.0
2007-01-17 17:00:00	SPY	ETF	142.98	143.01	142.81	142.87	120900.0
2007-01-17 18:00:00	SPY	ETF	142.9	142.92	142.85	142.87	1362400.0
2007-01-17 19:00:00	SPY	ETF	142.9	142.93	142.87	142.93	1500.0
2007-01-17 07:00:00	QQQ	ETF	45.17	45.2	45.17	45.18	15200.0
2007-01-17 08:00:00	QQQ	ETF	45.19	45.21	45.05	45.06	1181763.0
2007-01-17 09:00:00	QQQ	ETF	45.07	45.27	45.06	45.18	21809206.0
2007-01-17 10:00:00	QQQ	ETF	45.17	45.2	45.05	45.17	17717800.0
2007-01-17 11:00:00	QQQ	ETF	45.17	45.24	45.09	45.18	11791900.0
2007-01-17 12:00:00	QQQ	ETF	45.18	45.29	45.12	45.2	8223000.0
2007-01-17 13:00:00	QQQ	ETF	45.2	45.21	45.1	45.14	6757700.0
2007-01-17 14:00:00	QQQ	ETF	45.13	45.21	44.9	44.97	18169300.0
2007-01-17 15:00:00	QQQ	ETF	44.96	45.19	44.83	44.9	17653300.0
2007-01-17 16:00:00	QQQ	ETF	44.91	45.04	44.8	44.96	9696889.0
2007-01-17 17:00:00	QQQ	ETF	44.96	44.98	44.75	44.8	1854155.0
2007-01-17 18:00:00	QQQ	ETF	44.82	44.82	44.74	44.78	424889.0
2007-01-17 19:00:00	QQQ	ETF	44.77	44.79	44.75	44.77	40535.0
2007-01-17 08:00:00	IWM	ETF	78.43	78.44	78.16	78.16	124700.0
2007-01-17 09:00:00	IWM	ETF	78.2	78.57	78.2	78.49	3555200.0
2007-01-17 10:00:00	IWM	ETF	78.47	78.48	78.24	78.4	4714500.0
2007-01-17 11:00:00	IWM	ETF	78.41	78.68	78.41	78.64	3138600.0
2007-01-17 12:00:00	IWM	ETF	78.65	78.76	78.64	78.71	2243100.0
2007-01-17 13:00:00	IWM	ETF	78.71	78.78	78.51	78.58	1808400.0
2007-01-17 14:00:00	IWM	ETF	78.59	78.77	78.32	78.49	3994700.0
2007-01-17 15:00:00	IWM	ETF	78.49	78.51	78.18	78.19	6200800.0
2007-01-17 16:00:00	IWM	ETF	78.2	78.31	78.0	78.07	787400.0
2007-01-17 17:00:00	IWM	ETF	78.07	78.1	78.0	78.1	30000.0
2007-01-17 18:00:00	IWM	ETF	77.96	77.97	77.96	77.96	30600.0
2007-01-17 08:00:00	DIA	ETF	125.81	125.81	125.5	125.52	41500.0
2007-01-17 09:00:00	DIA	ETF	125.54	125.78	125.46	125.71	609700.0
2007-01-17 10:00:00	DIA	ETF	125.71	125.71	125.43	125.56	1128400.0
2007-01-17 11:00:00	DIA	ETF	125.58	125.81	125.58	125.78	1513800.0
2007-01-17 12:00:00	DIA	ETF	125.78	126.03	125.63	125.98	726200.0
2007-01-17 13:00:00	DIA	ETF	125.98	126.02	125.8	125.9	1198000.0
2007-01-17 14:00:00	DIA	ETF	125.89	126.1	125.62	125.78	1274700.0
2007-01-17 15:00:00	DIA	ETF	125.79	125.79	125.5	125.73	1215200.0
2007-01-17 16:00:00	DIA	ETF	125.77	125.84	125.72	125.84	157300.0
2007-01-17 17:00:00	DIA	ETF	125.75	125.75	125.71	125.71	2500.0
2007-01-17 18:00:00	DIA	ETF	125.71	125.75	125.71	125.75	400.0
2007-01-17 19:00:00	DIA	ETF	125.68	125.68	125.56	125.56	1400.0

> showing 50 of 1,958 rows — these rows as CSV

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