PREVIEW / etf_1hour / 2007-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-01.parquet
  size:    89 KB
  rows:    2,967

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-08-01 04:00:00	SPY	ETF	144.41	144.41	143.78	143.94	11500.0
2007-08-01 05:00:00	SPY	ETF	144.05	144.48	144.05	144.48	3000.0
2007-08-01 06:00:00	SPY	ETF	144.53	144.69	144.05	144.47	400500.0
2007-08-01 07:00:00	SPY	ETF	144.5	145.2	144.38	144.62	4099600.0
2007-08-01 08:00:00	SPY	ETF	144.66	145.45	143.45	145.27	14103900.0
2007-08-01 09:00:00	SPY	ETF	145.26	146.48	144.33	145.21	61682495.0
2007-08-01 10:00:00	SPY	ETF	145.215	146.3	144.59	144.73	84983071.0
2007-08-01 11:00:00	SPY	ETF	144.73	145.85	144.3	145.81	58350446.0
2007-08-01 12:00:00	SPY	ETF	145.8	146.42	145.32	145.74	41993664.0
2007-08-01 13:00:00	SPY	ETF	145.74	146.2	144.6	145.11	37987555.0
2007-08-01 14:00:00	SPY	ETF	145.11	145.42	144.0	144.49	48243271.0
2007-08-01 15:00:00	SPY	ETF	144.49	147.01	143.95	146.61	93518842.0
2007-08-01 16:00:00	SPY	ETF	146.55	146.82	145.153	146.69	8744600.0
2007-08-01 17:00:00	SPY	ETF	146.69	146.92	145.5295	146.79	2327500.0
2007-08-01 18:00:00	SPY	ETF	146.83	146.88	146.71	146.71	44300.0
2007-08-01 19:00:00	SPY	ETF	146.74	146.82	146.73	146.76	8100.0
2007-08-01 04:00:00	QQQ	ETF	47.18	47.18	47.04	47.04	2700.0
2007-08-01 06:00:00	QQQ	ETF	47.26	47.26	47.2	47.2	600.0
2007-08-01 07:00:00	QQQ	ETF	47.26	47.45	47.22	47.31	723467.0
2007-08-01 08:00:00	QQQ	ETF	47.32	47.47	47.18	47.42	3037086.0
2007-08-01 09:00:00	QQQ	ETF	47.41	47.81	47.04	47.36	40538323.0
2007-08-01 10:00:00	QQQ	ETF	47.35	47.7	47.06	47.09	56088031.0
2007-08-01 11:00:00	QQQ	ETF	47.0985	47.64	47.0	47.62	36893118.0
2007-08-01 12:00:00	QQQ	ETF	47.62	47.78	47.45	47.54	20346589.0
2007-08-01 13:00:00	QQQ	ETF	47.53	47.54	47.15	47.43	35282685.0
2007-08-01 14:00:00	QQQ	ETF	47.42	47.53	47.08	47.21	20257025.0
2007-08-01 15:00:00	QQQ	ETF	47.2	47.91	46.98	47.91	61314147.0
2007-08-01 16:00:00	QQQ	ETF	47.9	48.0	47.82	47.97	8756546.0
2007-08-01 17:00:00	QQQ	ETF	47.97	48.0	47.95	47.97	3194218.0
2007-08-01 18:00:00	QQQ	ETF	47.97	47.99	47.94	47.94	7825.0
2007-08-01 19:00:00	QQQ	ETF	47.97	47.97	47.93	47.95	55997.0
2007-08-01 05:00:00	IWM	ETF	76.19	76.19	76.01	76.13	4100.0
2007-08-01 06:00:00	IWM	ETF	76.4	76.4	76.4	76.4	200.0
2007-08-01 07:00:00	IWM	ETF	76.42	76.71	76.39	76.44	253900.0
2007-08-01 08:00:00	IWM	ETF	76.7	77.1	76.34	76.96	1194600.0
2007-08-01 09:00:00	IWM	ETF	76.93	77.96	76.22	76.81	29600316.0
2007-08-01 10:00:00	IWM	ETF	76.8	77.5	76.4	76.44	35202427.0
2007-08-01 11:00:00	IWM	ETF	76.45	77.42	76.24	77.39	18555400.0
2007-08-01 12:00:00	IWM	ETF	77.38	77.74	77.1	77.22	16554028.0
2007-08-01 13:00:00	IWM	ETF	77.21	77.23	76.56	76.85	18347139.0
2007-08-01 14:00:00	IWM	ETF	76.84	77.03	76.17	76.3	15596838.0
2007-08-01 15:00:00	IWM	ETF	76.29	77.75	76.11	77.49	25160663.0
2007-08-01 16:00:00	IWM	ETF	77.46	77.65	77.28	77.64	5215300.0
2007-08-01 17:00:00	IWM	ETF	77.64	77.71	77.1	77.71	134200.0
2007-08-01 18:00:00	IWM	ETF	77.69	77.71	77.68	77.69	4100.0
2007-08-01 19:00:00	IWM	ETF	77.62	77.62	77.54	77.54	1000.0
2007-08-01 07:00:00	DIA	ETF	131.5	131.74	131.2	131.45	12400.0
2007-08-01 08:00:00	DIA	ETF	131.41	131.92	131.2	131.87	192100.0
2007-08-01 09:00:00	DIA	ETF	131.87	132.63	131.47	131.87	4878200.0
2007-08-01 10:00:00	DIA	ETF	131.86	133.06	131.44	131.51	7525247.0

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

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