PREVIEW / etf_1hour / 2007-05-04

all etf 1-hour files

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

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-05-04 05:00:00	SPY	ETF	150.49	150.49	150.49	150.49	9700.0
2007-05-04 06:00:00	SPY	ETF	150.76	150.82	150.74	150.8	38800.0
2007-05-04 07:00:00	SPY	ETF	150.78	150.85	150.69	150.78	594500.0
2007-05-04 08:00:00	SPY	ETF	150.77	151.25	150.77	150.79	6250400.0
2007-05-04 09:00:00	SPY	ETF	150.79	150.92	150.43	150.77	11875523.0
2007-05-04 10:00:00	SPY	ETF	150.77	151.12	150.67	150.98	14496005.0
2007-05-04 11:00:00	SPY	ETF	150.98	151.03	150.72	150.74	9311099.0
2007-05-04 12:00:00	SPY	ETF	150.74	150.77	150.22	150.56	18263097.0
2007-05-04 13:00:00	SPY	ETF	150.57	151.1	150.36	150.44	7105299.0
2007-05-04 14:00:00	SPY	ETF	150.44	151.03	150.34	150.48	7024202.0
2007-05-04 15:00:00	SPY	ETF	150.48	150.7	150.35	150.65	17690204.0
2007-05-04 16:00:00	SPY	ETF	150.65	151.05	150.54	150.95	1789700.0
2007-05-04 17:00:00	SPY	ETF	150.97	150.98	150.89	150.98	164000.0
2007-05-04 18:00:00	SPY	ETF	150.98	151.0	150.94	150.94	9500.0
2007-05-04 19:00:00	SPY	ETF	150.94	150.99	150.94	150.96	5800.0
2007-05-04 04:00:00	QQQ	ETF	46.7	46.7	46.7	46.7	100.0
2007-05-04 05:00:00	QQQ	ETF	46.7	46.8	46.7	46.8	25900.0
2007-05-04 06:00:00	QQQ	ETF	46.82	46.83	46.82	46.83	750.0
2007-05-04 07:00:00	QQQ	ETF	46.82	46.88	46.79	46.84	640770.0
2007-05-04 08:00:00	QQQ	ETF	46.84	46.99	46.83	46.84	4634001.0
2007-05-04 09:00:00	QQQ	ETF	46.83	46.87	46.66	46.74	9199714.0
2007-05-04 10:00:00	QQQ	ETF	46.75	46.89	46.71	46.8	11055506.0
2007-05-04 11:00:00	QQQ	ETF	46.8	46.83	46.72	46.74	4895265.0
2007-05-04 12:00:00	QQQ	ETF	46.74	46.76	46.42	46.63	19532135.0
2007-05-04 13:00:00	QQQ	ETF	46.63	46.66	46.47	46.51	14157181.0
2007-05-04 14:00:00	QQQ	ETF	46.51	46.59	46.48	46.54	9843973.0
2007-05-04 15:00:00	QQQ	ETF	46.54	46.63	46.49	46.62	13463459.0
2007-05-04 16:00:00	QQQ	ETF	46.63	46.7	46.6	46.66	4584770.0
2007-05-04 17:00:00	QQQ	ETF	46.66	46.7	46.66	46.67	36250.0
2007-05-04 18:00:00	QQQ	ETF	46.68	46.69	46.68	46.69	10600.0
2007-05-04 19:00:00	QQQ	ETF	46.69	46.75	46.66	46.66	26585.0
2007-05-04 07:00:00	IWM	ETF	82.5	82.55	82.39	82.55	67700.0
2007-05-04 08:00:00	IWM	ETF	82.52	82.8	82.48	82.52	1630900.0
2007-05-04 09:00:00	IWM	ETF	82.52	82.65	82.32	82.52	4701572.0
2007-05-04 10:00:00	IWM	ETF	82.52	82.67	82.39	82.59	4739019.0
2007-05-04 11:00:00	IWM	ETF	82.58	82.65	82.4	82.52	7277600.0
2007-05-04 12:00:00	IWM	ETF	82.52	82.58	82.15	82.47	10910398.0
2007-05-04 13:00:00	IWM	ETF	82.47	82.49	82.23	82.29	4121591.0
2007-05-04 14:00:00	IWM	ETF	82.28	82.4	82.21	82.36	3756100.0
2007-05-04 15:00:00	IWM	ETF	82.36	82.74	82.35	82.73	5954329.0
2007-05-04 16:00:00	IWM	ETF	82.73	82.87	82.42	82.8	800500.0
2007-05-04 17:00:00	IWM	ETF	82.82	82.83	82.82	82.82	10100.0
2007-05-04 18:00:00	IWM	ETF	82.47	82.47	82.47	82.47	300.0
2007-05-04 07:00:00	DIA	ETF	132.73	132.85	132.73	132.85	13400.0
2007-05-04 08:00:00	DIA	ETF	132.82	133.0	132.72	132.72	136800.0
2007-05-04 09:00:00	DIA	ETF	132.72	132.79	132.3	132.54	1878799.0
2007-05-04 10:00:00	DIA	ETF	132.54	132.8	132.47	132.74	2026300.0
2007-05-04 11:00:00	DIA	ETF	132.74	132.79	132.59	132.63	784300.0
2007-05-04 12:00:00	DIA	ETF	132.62	132.65	132.23	132.5	2538300.0
2007-05-04 13:00:00	DIA	ETF	132.5	132.59	132.35	132.44	657600.0

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

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