PREVIEW / etf_1hour / 2007-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-22.parquet
  size:    81 KB
  rows:    2,705

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-06-22 04:00:00	SPY	ETF	151.51	151.51	151.51	151.51	6200.0
2007-06-22 06:00:00	SPY	ETF	151.28	151.57	151.25	151.57	65100.0
2007-06-22 07:00:00	SPY	ETF	151.57	151.75	151.27	151.3	925700.0
2007-06-22 08:00:00	SPY	ETF	151.28	151.58	151.26	151.54	2397500.0
2007-06-22 09:00:00	SPY	ETF	151.54	151.77	151.1	151.47	17964565.0
2007-06-22 10:00:00	SPY	ETF	151.47	151.48	150.82	151.23	28330854.0
2007-06-22 11:00:00	SPY	ETF	151.23	151.43	150.96	151.23	14923295.0
2007-06-22 12:00:00	SPY	ETF	151.22	151.35	149.94	150.41	38931372.0
2007-06-22 13:00:00	SPY	ETF	150.41	150.8	149.95	150.46	31803871.0
2007-06-22 14:00:00	SPY	ETF	150.47	151.03	150.12	150.58	19973884.0
2007-06-22 15:00:00	SPY	ETF	150.58	150.66	149.85	150.24	34731390.0
2007-06-22 16:00:00	SPY	ETF	150.23	150.64	150.063	150.63	10275500.0
2007-06-22 17:00:00	SPY	ETF	150.63	150.85	150.62	150.85	213400.0
2007-06-22 18:00:00	SPY	ETF	150.85	150.85	150.65	150.71	34900.0
2007-06-22 19:00:00	SPY	ETF	150.71	150.72	150.7	150.72	2300.0
2007-06-22 04:00:00	QQQ	ETF	47.58	47.6	47.58	47.6	72700.0
2007-06-22 05:00:00	QQQ	ETF	47.6	47.6	47.6	47.6	7400.0
2007-06-22 06:00:00	QQQ	ETF	47.6	47.6	47.6	47.6	5000.0
2007-06-22 07:00:00	QQQ	ETF	47.58	47.72	47.52	47.55	507601.0
2007-06-22 08:00:00	QQQ	ETF	47.55	47.64	47.52	47.61	1845204.0
2007-06-22 09:00:00	QQQ	ETF	47.61	47.71	47.49	47.62	12350384.0
2007-06-22 10:00:00	QQQ	ETF	47.62	47.65	47.45	47.58	21978260.0
2007-06-22 11:00:00	QQQ	ETF	47.58	47.59	47.36	47.5115	23663727.0
2007-06-22 12:00:00	QQQ	ETF	47.51	47.53	47.19	47.295	28848019.0
2007-06-22 13:00:00	QQQ	ETF	47.29	47.39	47.14	47.32	20489308.0
2007-06-22 14:00:00	QQQ	ETF	47.32	47.39	47.24	47.34	13113164.0
2007-06-22 15:00:00	QQQ	ETF	47.35	47.41	47.155	47.32	24049459.0
2007-06-22 16:00:00	QQQ	ETF	47.32	47.34	47.25	47.3	2387666.0
2007-06-22 17:00:00	QQQ	ETF	47.33	47.37	47.32	47.32	124782.0
2007-06-22 18:00:00	QQQ	ETF	47.32	47.35	47.31	47.32	4918.0
2007-06-22 19:00:00	QQQ	ETF	47.34	47.37	47.34	47.37	5900.0
2007-06-22 06:00:00	IWM	ETF	83.26	83.26	83.26	83.26	1000.0
2007-06-22 07:00:00	IWM	ETF	83.33	83.47	83.19	83.19	59800.0
2007-06-22 08:00:00	IWM	ETF	83.2	83.34	83.1	83.27	870000.0
2007-06-22 09:00:00	IWM	ETF	83.26	83.48	83.07	83.41	8301975.0
2007-06-22 10:00:00	IWM	ETF	83.42	83.42	82.83	83.07	16342006.0
2007-06-22 11:00:00	IWM	ETF	83.08	83.2	82.8	83.07	7195519.0
2007-06-22 12:00:00	IWM	ETF	83.07	83.08	82.31	82.55	12817875.0
2007-06-22 13:00:00	IWM	ETF	82.56	82.98	82.3	82.83	12182796.0
2007-06-22 14:00:00	IWM	ETF	82.83	82.96	82.59	82.91	8416438.0
2007-06-22 15:00:00	IWM	ETF	82.91	83.0	82.6	82.68	17079220.0
2007-06-22 16:00:00	IWM	ETF	82.68	83.25	82.68	82.92	4674900.0
2007-06-22 17:00:00	IWM	ETF	82.92	82.92	82.85	82.85	1600.0
2007-06-22 18:00:00	IWM	ETF	82.9	82.95	82.9	82.95	27600.0
2007-06-22 05:00:00	DIA	ETF	135.15	135.15	135.15	135.15	100.0
2007-06-22 07:00:00	DIA	ETF	135.16	135.16	134.94	134.94	2500.0
2007-06-22 08:00:00	DIA	ETF	134.88	135.07	134.85	135.0	14200.0
2007-06-22 09:00:00	DIA	ETF	134.96	135.18	134.7	134.92	1691100.0
2007-06-22 10:00:00	DIA	ETF	134.91	134.92	134.41	134.65	2830121.0
2007-06-22 11:00:00	DIA	ETF	134.64	134.83	134.52	134.69	1278000.0

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

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