PREVIEW / etf_1hour / 2007-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-17.parquet
  size:    81 KB
  rows:    2,742

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-17 04:00:00	SPY	ETF	148.02	148.04	147.92	147.92	20100.0
2007-09-17 05:00:00	SPY	ETF	147.87	147.89	147.82	147.82	9100.0
2007-09-17 06:00:00	SPY	ETF	147.91	148.05	147.9	147.9	84700.0
2007-09-17 07:00:00	SPY	ETF	147.94	148.11	147.89	148.07	829200.0
2007-09-17 08:00:00	SPY	ETF	148.07	148.31	147.82	148.26	2058200.0
2007-09-17 09:00:00	SPY	ETF	148.25	148.54	148.22	148.37	16724475.0
2007-09-17 10:00:00	SPY	ETF	148.36	148.65	147.88	148.0	18708200.0
2007-09-17 11:00:00	SPY	ETF	148.0	148.19	147.69	147.82	13361300.0
2007-09-17 12:00:00	SPY	ETF	147.82	148.29	147.63	148.28	10217900.0
2007-09-17 13:00:00	SPY	ETF	148.28	148.8905	148.0	148.02	11129400.0
2007-09-17 14:00:00	SPY	ETF	148.03	148.38	147.93	148.24	10088200.0
2007-09-17 15:00:00	SPY	ETF	148.24	148.52	148.03	148.13	23997700.0
2007-09-17 16:00:00	SPY	ETF	148.14	148.23	148.03	148.1	1532600.0
2007-09-17 17:00:00	SPY	ETF	148.16	148.16	148.09	148.15	89100.0
2007-09-17 18:00:00	SPY	ETF	148.12	148.12	148.03	148.09	17100.0
2007-09-17 19:00:00	SPY	ETF	148.08	148.08	148.02	148.03	17200.0
2007-09-17 04:00:00	QQQ	ETF	48.91	48.91	48.9	48.9	11000.0
2007-09-17 05:00:00	QQQ	ETF	48.89	48.89	48.89	48.89	100.0
2007-09-17 06:00:00	QQQ	ETF	48.92	48.95	48.92	48.95	54350.0
2007-09-17 07:00:00	QQQ	ETF	48.94	48.97	48.92	48.97	108106.0
2007-09-17 08:00:00	QQQ	ETF	48.97	49.07	48.97	49.05	1136292.0
2007-09-17 09:00:00	QQQ	ETF	49.04	49.1	48.86	48.9085	13361668.0
2007-09-17 10:00:00	QQQ	ETF	48.9	48.95	48.64	48.67	11653060.0
2007-09-17 11:00:00	QQQ	ETF	48.6795	48.77	48.59	48.65	7287813.0
2007-09-17 12:00:00	QQQ	ETF	48.66	48.84	48.62	48.83	8122579.0
2007-09-17 13:00:00	QQQ	ETF	48.83	48.93	48.76	48.77	7816732.0
2007-09-17 14:00:00	QQQ	ETF	48.77	48.89	48.73	48.8	7138806.0
2007-09-17 15:00:00	QQQ	ETF	48.79	48.94	48.76	48.79	11090432.0
2007-09-17 16:00:00	QQQ	ETF	48.79	48.86	48.7	48.75	4489770.0
2007-09-17 17:00:00	QQQ	ETF	48.76	48.81	48.72	48.75	83052.0
2007-09-17 18:00:00	QQQ	ETF	48.75	48.77	48.72	48.77	10219.0
2007-09-17 19:00:00	QQQ	ETF	48.72	48.75	48.72	48.75	4100.0
2007-09-17 04:00:00	IWM	ETF	77.79	77.79	77.79	77.79	100.0
2007-09-17 06:00:00	IWM	ETF	77.72	77.72	77.71	77.71	14600.0
2007-09-17 07:00:00	IWM	ETF	77.72	77.79	77.72	77.72	124200.0
2007-09-17 08:00:00	IWM	ETF	77.79	77.88	77.7	77.84	47100.0
2007-09-17 09:00:00	IWM	ETF	77.82	78.02	77.53	77.62	4987409.0
2007-09-17 10:00:00	IWM	ETF	77.62	77.81	77.28	77.41	9467300.0
2007-09-17 11:00:00	IWM	ETF	77.4	77.55	77.24	77.33	5344600.0
2007-09-17 12:00:00	IWM	ETF	77.34	77.53	77.19	77.52	3405300.0
2007-09-17 13:00:00	IWM	ETF	77.51	78.12	77.28	77.35	5132200.0
2007-09-17 14:00:00	IWM	ETF	77.35	77.55	77.26	77.36	4996300.0
2007-09-17 15:00:00	IWM	ETF	77.37	77.76	77.26	77.34	9761700.0
2007-09-17 16:00:00	IWM	ETF	77.32	77.41	77.26	77.27	532400.0
2007-09-17 17:00:00	IWM	ETF	77.31	77.31	77.27	77.27	1200.0
2007-09-17 18:00:00	IWM	ETF	77.3	77.31	77.28	77.28	6900.0
2007-09-17 19:00:00	IWM	ETF	77.27	77.31	77.27	77.31	700.0
2007-09-17 07:00:00	DIA	ETF	134.01	134.01	133.9	133.91	2400.0
2007-09-17 08:00:00	DIA	ETF	134.13	134.13	133.93	134.1	15700.0
2007-09-17 09:00:00	DIA	ETF	134.12	134.27	134.02	134.23	824500.0

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

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