PREVIEW / etf_1hour / 2007-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-16.parquet
  size:    70 KB
  rows:    2,250

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-16 06:00:00	SPY	ETF	145.62	145.62	145.6	145.6	18600.0
2007-04-16 07:00:00	SPY	ETF	145.59	145.74	145.59	145.71	579300.0
2007-04-16 08:00:00	SPY	ETF	145.7	145.9	145.5	145.83	2459900.0
2007-04-16 09:00:00	SPY	ETF	145.83	146.35	145.8	146.19	15578883.0
2007-04-16 10:00:00	SPY	ETF	146.19	146.52	146.12	146.41	14157870.0
2007-04-16 11:00:00	SPY	ETF	146.42	146.86	146.28	146.75	14230416.0
2007-04-16 12:00:00	SPY	ETF	146.75	146.78	146.57	146.58	5319262.0
2007-04-16 13:00:00	SPY	ETF	146.5701	146.71	146.48	146.5	5206708.0
2007-04-16 14:00:00	SPY	ETF	146.49	146.66	146.41	146.63	7783273.0
2007-04-16 15:00:00	SPY	ETF	146.63	146.8	146.62	146.78	12199706.0
2007-04-16 16:00:00	SPY	ETF	146.78	146.82	146.56	146.65	4436700.0
2007-04-16 17:00:00	SPY	ETF	146.63	146.7	146.59	146.69	214600.0
2007-04-16 18:00:00	SPY	ETF	146.69	146.69	146.65	146.65	2000.0
2007-04-16 19:00:00	SPY	ETF	146.69	146.69	146.68	146.68	4500.0
2007-04-16 07:00:00	QQQ	ETF	44.79	44.85	44.79	44.82	107949.0
2007-04-16 08:00:00	QQQ	ETF	44.82	44.88	44.79	44.85	720078.0
2007-04-16 09:00:00	QQQ	ETF	44.84	45.0	44.82	44.94	13804177.0
2007-04-16 10:00:00	QQQ	ETF	44.93	45.0	44.85	44.97	11723600.0
2007-04-16 11:00:00	QQQ	ETF	44.96	45.15	44.93	45.08	12805900.0
2007-04-16 12:00:00	QQQ	ETF	45.07	45.09	44.99	45.0	5990000.0
2007-04-16 13:00:00	QQQ	ETF	45.0	45.08	44.96	44.96	5875700.0
2007-04-16 14:00:00	QQQ	ETF	44.97	45.03	44.94	45.01	5666700.0
2007-04-16 15:00:00	QQQ	ETF	45.01	45.08	44.99	45.08	10747200.0
2007-04-16 16:00:00	QQQ	ETF	45.08	45.1	45.05	45.1	3914082.0
2007-04-16 17:00:00	QQQ	ETF	45.08	45.1	45.07	45.09	1791645.0
2007-04-16 18:00:00	QQQ	ETF	45.09	45.1	45.08	45.08	18284.0
2007-04-16 19:00:00	QQQ	ETF	45.07	45.1	45.07	45.09	15158.0
2007-04-16 07:00:00	IWM	ETF	81.6	81.61	81.6	81.61	20100.0
2007-04-16 08:00:00	IWM	ETF	81.65	81.85	81.64	81.8	284800.0
2007-04-16 09:00:00	IWM	ETF	81.77	82.2	81.77	81.99	9811495.0
2007-04-16 10:00:00	IWM	ETF	82.0	82.28	81.96	82.24	6775135.0
2007-04-16 11:00:00	IWM	ETF	82.24	82.43	82.19	82.32	5175431.0
2007-04-16 12:00:00	IWM	ETF	82.32	82.35	82.25	82.26	2332305.0
2007-04-16 13:00:00	IWM	ETF	82.27	82.32	82.17	82.17	3025639.0
2007-04-16 14:00:00	IWM	ETF	82.18	82.32	82.15	82.29	3014670.0
2007-04-16 15:00:00	IWM	ETF	82.3	82.55	82.28	82.55	9139699.0
2007-04-16 16:00:00	IWM	ETF	82.56	82.57	82.35	82.4	2185000.0
2007-04-16 17:00:00	IWM	ETF	82.39	82.43	82.39	82.43	220300.0
2007-04-16 18:00:00	IWM	ETF	82.4	82.4	82.38	82.38	200.0
2007-04-16 07:00:00	DIA	ETF	126.46	126.46	126.42	126.42	4100.0
2007-04-16 08:00:00	DIA	ETF	126.22	126.58	126.22	126.54	127100.0
2007-04-16 09:00:00	DIA	ETF	126.51	126.84	126.45	126.65	2097400.0
2007-04-16 10:00:00	DIA	ETF	126.65	127.02	126.51	126.97	1925700.0
2007-04-16 11:00:00	DIA	ETF	126.98	127.29	126.96	127.2105	1111883.0
2007-04-16 12:00:00	DIA	ETF	127.21	127.21	127.03	127.03	332200.0
2007-04-16 13:00:00	DIA	ETF	127.02	127.16	126.98	126.99	716420.0
2007-04-16 14:00:00	DIA	ETF	126.99	127.07	126.91	127.04	710300.0
2007-04-16 15:00:00	DIA	ETF	127.04	127.18	127.04	127.14	874573.0
2007-04-16 16:00:00	DIA	ETF	127.13	127.13	127.01	127.01	46200.0
2007-04-16 17:00:00	DIA	ETF	127.03	127.08	127.03	127.03	96000.0

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

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