PREVIEW / etf_1hour / 2007-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-08-23.parquet
  size:    84 KB
  rows:    2,771

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-23 04:00:00	SPY	ETF	147.87	147.87	147.7	147.7	1700.0
2007-08-23 05:00:00	SPY	ETF	147.77	148.0	147.77	148.0	2100.0
2007-08-23 06:00:00	SPY	ETF	148.05	148.05	147.85	147.89	36300.0
2007-08-23 07:00:00	SPY	ETF	147.88	148.03	147.59	147.68	966500.0
2007-08-23 08:00:00	SPY	ETF	147.69	148.13	147.32	147.33	3260900.0
2007-08-23 09:00:00	SPY	ETF	147.35	148.0	146.55	146.79	35277537.0
2007-08-23 10:00:00	SPY	ETF	146.79	147.04	146.49	146.9	32387108.0
2007-08-23 11:00:00	SPY	ETF	146.9	146.94	145.74	145.81	31283200.0
2007-08-23 12:00:00	SPY	ETF	145.81	146.28	145.61	145.73	22043900.0
2007-08-23 13:00:00	SPY	ETF	145.74	146.37	145.64	146.34	18615200.0
2007-08-23 14:00:00	SPY	ETF	146.34	146.65	145.86	146.11	19191827.0
2007-08-23 15:00:00	SPY	ETF	146.11	146.73	145.87	146.57	31593200.0
2007-08-23 16:00:00	SPY	ETF	146.57	147.9	146.2256	146.56	4904500.0
2007-08-23 17:00:00	SPY	ETF	146.55	146.58	146.33	146.38	323300.0
2007-08-23 18:00:00	SPY	ETF	146.39	146.39	146.24	146.33	42500.0
2007-08-23 19:00:00	SPY	ETF	146.34	146.38	146.3	146.34	61000.0
2007-08-23 04:00:00	QQQ	ETF	47.95	47.95	47.95	47.95	1000.0
2007-08-23 05:00:00	QQQ	ETF	47.95	48.0	47.95	48.0	1500.0
2007-08-23 06:00:00	QQQ	ETF	48.0	48.01	47.97	47.97	7400.0
2007-08-23 07:00:00	QQQ	ETF	47.98	48.0	47.87	47.88	647554.0
2007-08-23 08:00:00	QQQ	ETF	47.89	48.04	47.73	47.73	1320412.0
2007-08-23 09:00:00	QQQ	ETF	47.72	47.87	47.58	47.66	17233732.0
2007-08-23 10:00:00	QQQ	ETF	47.66	47.7	47.4	47.56	21051084.0
2007-08-23 11:00:00	QQQ	ETF	47.57	47.57	47.23	47.2485	14039851.0
2007-08-23 12:00:00	QQQ	ETF	47.25	47.4905	47.25	47.3	12378235.0
2007-08-23 13:00:00	QQQ	ETF	47.3	47.46	47.27	47.452	9717805.0
2007-08-23 14:00:00	QQQ	ETF	47.46	47.56	47.3	47.4	14346537.0
2007-08-23 15:00:00	QQQ	ETF	47.4	47.54	47.33	47.49	14993753.0
2007-08-23 16:00:00	QQQ	ETF	47.49	47.55	47.49	47.5	5005614.0
2007-08-23 17:00:00	QQQ	ETF	47.53	47.54	47.38	47.39	919506.0
2007-08-23 18:00:00	QQQ	ETF	47.4	47.44	47.4	47.42	42400.0
2007-08-23 19:00:00	QQQ	ETF	47.42	47.47	47.41	47.42	12050.0
2007-08-23 07:00:00	IWM	ETF	80.31	80.47	80.18	80.23	139200.0
2007-08-23 08:00:00	IWM	ETF	80.34	80.4	79.88	79.91	877000.0
2007-08-23 09:00:00	IWM	ETF	79.89	80.5	78.9	79.08	15099288.0
2007-08-23 10:00:00	IWM	ETF	79.08	79.22	78.8	79.07	11283700.0
2007-08-23 11:00:00	IWM	ETF	79.06	79.08	78.46	78.5	10811300.0
2007-08-23 12:00:00	IWM	ETF	78.51	78.91	78.31	78.45	6932900.0
2007-08-23 13:00:00	IWM	ETF	78.45	78.89	78.33	78.84	10582600.0
2007-08-23 14:00:00	IWM	ETF	78.85	79.12	78.48	78.64	12420000.0
2007-08-23 15:00:00	IWM	ETF	78.64	78.96	78.34	78.53	15197200.0
2007-08-23 16:00:00	IWM	ETF	78.52	78.69	78.47	78.61	18125400.0
2007-08-23 17:00:00	IWM	ETF	78.57	78.61	78.5	78.5	13400.0
2007-08-23 18:00:00	IWM	ETF	78.5	78.5	78.5	78.5	3200.0
2007-08-23 19:00:00	IWM	ETF	78.5	78.5	78.5	78.5	400.0
2007-08-23 07:00:00	DIA	ETF	133.14	133.17	133.01	133.01	11900.0
2007-08-23 08:00:00	DIA	ETF	132.88	132.89	132.71	132.73	107300.0
2007-08-23 09:00:00	DIA	ETF	132.7	133.08	132.36	132.52	1461800.0
2007-08-23 10:00:00	DIA	ETF	132.51	132.64	132.21	132.54	2466100.0
2007-08-23 11:00:00	DIA	ETF	132.54	132.58	131.74	131.8	1540200.0

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

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