PREVIEW / etf_1hour / 2007-06-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	151.44	151.44	151.44	151.44	1000.0
2007-06-21 05:00:00	SPY	ETF	151.42	151.42	151.38	151.38	5000.0
2007-06-21 06:00:00	SPY	ETF	151.24	151.3	151.19	151.25	122900.0
2007-06-21 07:00:00	SPY	ETF	151.21	151.25	150.6	150.83	2374700.0
2007-06-21 08:00:00	SPY	ETF	150.88	151.23	150.7	151.22	4492600.0
2007-06-21 09:00:00	SPY	ETF	151.22	151.27	150.36	150.38	23153172.0
2007-06-21 10:00:00	SPY	ETF	150.38	151.72	150.25	151.58	62587755.0
2007-06-21 11:00:00	SPY	ETF	151.58	151.79	150.88	151.06	25921186.0
2007-06-21 12:00:00	SPY	ETF	151.06	151.39	150.79	151.13	24802061.0
2007-06-21 13:00:00	SPY	ETF	151.14	152.08	151.14	152.03	17820834.0
2007-06-21 14:00:00	SPY	ETF	152.03	152.11	150.73	151.68	16537046.0
2007-06-21 15:00:00	SPY	ETF	151.68	152.04	151.58	151.98	19248213.0
2007-06-21 16:00:00	SPY	ETF	151.99	152.06	151.74	151.86	6468400.0
2007-06-21 17:00:00	SPY	ETF	151.88	151.92	151.84	151.85	149000.0
2007-06-21 18:00:00	SPY	ETF	151.88	151.91	151.83	151.83	12600.0
2007-06-21 19:00:00	SPY	ETF	151.85	151.87	151.85	151.87	1800.0
2007-06-21 07:00:00	QQQ	ETF	47.3	47.34	47.14	47.2	626962.0
2007-06-21 08:00:00	QQQ	ETF	47.21	47.32	47.15	47.32	1850361.0
2007-06-21 09:00:00	QQQ	ETF	47.32	47.4	47.12	47.16	17637951.0
2007-06-21 10:00:00	QQQ	ETF	47.1505	47.64	47.08	47.57	52502043.0
2007-06-21 11:00:00	QQQ	ETF	47.58	47.61	47.32	47.381	15871628.0
2007-06-21 12:00:00	QQQ	ETF	47.38	47.54	47.37	47.46	11100166.0
2007-06-21 13:00:00	QQQ	ETF	47.46	47.78	47.46	47.77	13262467.0
2007-06-21 14:00:00	QQQ	ETF	47.76	47.79	47.56	47.65	10664934.0
2007-06-21 15:00:00	QQQ	ETF	47.66	47.78	47.62	47.74	13057834.0
2007-06-21 16:00:00	QQQ	ETF	47.74	47.79	47.68	47.73	1299026.0
2007-06-21 17:00:00	QQQ	ETF	47.71	47.75	47.71	47.75	7938.0
2007-06-21 18:00:00	QQQ	ETF	47.72	47.73	47.72	47.73	10000.0
2007-06-21 19:00:00	QQQ	ETF	47.73	47.73	47.71	47.71	6851.0
2007-06-21 07:00:00	IWM	ETF	82.96	82.96	82.49	82.59	372500.0
2007-06-21 08:00:00	IWM	ETF	82.8	82.84	82.45	82.81	3021100.0
2007-06-21 09:00:00	IWM	ETF	82.81	83.08	82.38	82.41	15355475.0
2007-06-21 10:00:00	IWM	ETF	82.4	83.39	82.32	83.26	27306907.0
2007-06-21 11:00:00	IWM	ETF	83.26	83.33	82.7	82.83	13582850.0
2007-06-21 12:00:00	IWM	ETF	82.82	83.08	82.73	82.9	5339610.0
2007-06-21 13:00:00	IWM	ETF	82.9	83.57	82.8	83.54	11345646.0
2007-06-21 14:00:00	IWM	ETF	83.55	83.59	82.8	83.29	7393049.0
2007-06-21 15:00:00	IWM	ETF	83.28	83.55	83.19	83.46	7236580.0
2007-06-21 16:00:00	IWM	ETF	83.47	83.57	83.44	83.45	738900.0
2007-06-21 17:00:00	IWM	ETF	83.5	83.5	83.48	83.5	5300.0
2007-06-21 07:00:00	DIA	ETF	134.85	134.85	134.51	134.67	141600.0
2007-06-21 08:00:00	DIA	ETF	134.65	134.92	134.6	134.91	545800.0
2007-06-21 09:00:00	DIA	ETF	134.93	134.95	133.99	134.0	3145407.0
2007-06-21 10:00:00	DIA	ETF	134.01	135.02	133.87	134.9	6987165.0
2007-06-21 11:00:00	DIA	ETF	134.92	135.0	134.43	134.54	3335268.0
2007-06-21 12:00:00	DIA	ETF	134.54	134.8	134.27	134.52	2688800.0
2007-06-21 13:00:00	DIA	ETF	134.52	135.51	134.52	135.49	2435930.0
2007-06-21 14:00:00	DIA	ETF	135.49	135.53	134.83	135.1	3726624.0
2007-06-21 15:00:00	DIA	ETF	135.09	135.38	134.98	135.36	3188442.0
2007-06-21 16:00:00	DIA	ETF	135.35	135.55	135.29	135.29	420900.0

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

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