PREVIEW / etf_1hour / 2007-09-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-06.parquet
  size:    82 KB
  rows:    2,747

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-06 04:00:00	SPY	ETF	148.1	148.1	148.1	148.1	2000.0
2007-09-06 05:00:00	SPY	ETF	147.88	147.88	147.88	147.88	2000.0
2007-09-06 06:00:00	SPY	ETF	147.65	147.65	147.35	147.6	108000.0
2007-09-06 07:00:00	SPY	ETF	147.58	147.58	147.16	147.33	1015800.0
2007-09-06 08:00:00	SPY	ETF	148.25	148.25	147.21	147.88	5093200.0
2007-09-06 09:00:00	SPY	ETF	147.89	148.24	147.48	147.61	16865156.0
2007-09-06 10:00:00	SPY	ETF	147.61	147.91	147.12	147.78	22648400.0
2007-09-06 11:00:00	SPY	ETF	147.78	148.38	147.49	148.18	17506700.0
2007-09-06 12:00:00	SPY	ETF	148.18	148.61	147.93	148.24	17120600.0
2007-09-06 13:00:00	SPY	ETF	148.25	148.26	147.76	148.1	10957300.0
2007-09-06 14:00:00	SPY	ETF	148.1	148.27	147.85	148.19	13328800.0
2007-09-06 15:00:00	SPY	ETF	148.19	148.43	148.01	148.27	17767600.0
2007-09-06 16:00:00	SPY	ETF	148.27	148.28	148.05	148.08	2634800.0
2007-09-06 17:00:00	SPY	ETF	148.08	148.18	148.07	148.07	69400.0
2007-09-06 18:00:00	SPY	ETF	148.16	148.16	147.99	148.15	74000.0
2007-09-06 19:00:00	SPY	ETF	148.05	148.06	148.05	148.06	3800.0
2007-09-06 04:00:00	QQQ	ETF	49.26	49.26	49.25	49.25	600.0
2007-09-06 06:00:00	QQQ	ETF	49.23	49.23	49.23	49.23	100.0
2007-09-06 07:00:00	QQQ	ETF	49.06	49.13	48.99	48.99	86900.0
2007-09-06 08:00:00	QQQ	ETF	49.02	49.18	48.99	49.17	3269701.0
2007-09-06 09:00:00	QQQ	ETF	49.18	49.36	49.0	49.02	13243944.0
2007-09-06 10:00:00	QQQ	ETF	49.02	49.11	48.81	49.03	16014457.0
2007-09-06 11:00:00	QQQ	ETF	49.04	49.26	48.98	49.22	10378661.0
2007-09-06 12:00:00	QQQ	ETF	49.2211	49.35	49.09	49.19	12660613.0
2007-09-06 13:00:00	QQQ	ETF	49.19	49.22	49.0105	49.17	6265848.0
2007-09-06 14:00:00	QQQ	ETF	49.1614	49.24	49.07	49.24	5694757.0
2007-09-06 15:00:00	QQQ	ETF	49.25	49.35	49.14	49.16	10014837.0
2007-09-06 16:00:00	QQQ	ETF	49.17	49.25	49.13	49.16	2110863.0
2007-09-06 17:00:00	QQQ	ETF	49.15	49.15	49.1	49.12	48743.0
2007-09-06 18:00:00	QQQ	ETF	49.11	49.13	49.1	49.11	13350.0
2007-09-06 19:00:00	QQQ	ETF	49.13	49.14	49.13	49.13	10600.0
2007-09-06 07:00:00	IWM	ETF	78.74	78.8	78.61	78.61	44300.0
2007-09-06 08:00:00	IWM	ETF	78.76	78.99	78.6	78.85	1184200.0
2007-09-06 09:00:00	IWM	ETF	78.95	79.26	78.72	78.77	3595188.0
2007-09-06 10:00:00	IWM	ETF	78.75	78.83	78.2	78.68	9517700.0
2007-09-06 11:00:00	IWM	ETF	78.69	79.2	78.49	79.04	7685800.0
2007-09-06 12:00:00	IWM	ETF	79.05	79.37	78.84	79.02	7058700.0
2007-09-06 13:00:00	IWM	ETF	79.04	79.08	78.63	78.83	2776100.0
2007-09-06 14:00:00	IWM	ETF	78.83	79.0	78.69	78.95	3556800.0
2007-09-06 15:00:00	IWM	ETF	78.94	79.11	78.84	78.96	5901700.0
2007-09-06 16:00:00	IWM	ETF	78.97	79.04	78.89	79.03	13051900.0
2007-09-06 17:00:00	IWM	ETF	78.99	79.04	78.84	78.84	41700.0
2007-09-06 18:00:00	IWM	ETF	78.83	79.02	78.83	78.94	80100.0
2007-09-06 19:00:00	IWM	ETF	78.99	78.99	78.93	78.93	2000.0
2007-09-06 07:00:00	DIA	ETF	132.97	132.97	132.97	132.97	100.0
2007-09-06 08:00:00	DIA	ETF	132.9	133.48	132.9	133.35	49600.0
2007-09-06 09:00:00	DIA	ETF	133.57	133.61	133.05	133.1	604522.0
2007-09-06 10:00:00	DIA	ETF	133.1	133.25	132.76	133.2	1338900.0
2007-09-06 11:00:00	DIA	ETF	133.2	133.8	133.02	133.7	748800.0
2007-09-06 12:00:00	DIA	ETF	133.69	133.98	133.52	133.78	1172100.0

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

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