PREVIEW / etf_1hour / 2007-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-26.parquet
  size:    84 KB
  rows:    2,810

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-26 05:00:00	SPY	ETF	149.83	149.83	149.83	149.83	5000.0
2007-06-26 06:00:00	SPY	ETF	150.06	150.11	150.03	150.03	24000.0
2007-06-26 07:00:00	SPY	ETF	150.13	150.37	150.13	150.27	522900.0
2007-06-26 08:00:00	SPY	ETF	150.23	150.3	150.08	150.11	3126600.0
2007-06-26 09:00:00	SPY	ETF	150.16	150.3	149.95	150.14	15987527.0
2007-06-26 10:00:00	SPY	ETF	150.14	150.4	149.23	149.3	40020309.0
2007-06-26 11:00:00	SPY	ETF	149.3	150.33	149.21	150.29	24459401.0
2007-06-26 12:00:00	SPY	ETF	150.3	150.46	149.86	149.94	13981817.0
2007-06-26 13:00:00	SPY	ETF	149.94	150.3	149.55	149.73	16049939.0
2007-06-26 14:00:00	SPY	ETF	149.73	149.91	148.93	149.07	36579891.0
2007-06-26 15:00:00	SPY	ETF	149.07	150.1715	148.82	149.06	31130050.0
2007-06-26 16:00:00	SPY	ETF	149.07	149.12	148.29	148.42	9690900.0
2007-06-26 17:00:00	SPY	ETF	148.42	148.68	148.41	148.46	344700.0
2007-06-26 18:00:00	SPY	ETF	148.47	148.47	148.32	148.35	810400.0
2007-06-26 19:00:00	SPY	ETF	148.35	148.36	148.3	148.35	97500.0
2007-06-26 06:00:00	QQQ	ETF	47.26	47.26	47.23	47.23	11000.0
2007-06-26 07:00:00	QQQ	ETF	47.27	47.35	47.27	47.29	216466.0
2007-06-26 08:00:00	QQQ	ETF	47.3	47.3	47.21	47.24	1976194.0
2007-06-26 09:00:00	QQQ	ETF	47.23	47.33	47.16	47.19	10486943.0
2007-06-26 10:00:00	QQQ	ETF	47.19	47.29	46.93	46.95	31486570.0
2007-06-26 11:00:00	QQQ	ETF	46.94	47.18	46.88	47.14	18632913.0
2007-06-26 12:00:00	QQQ	ETF	47.15	47.2	47.03	47.07	11761188.0
2007-06-26 13:00:00	QQQ	ETF	47.09	47.2	46.99	47.0225	8526809.0
2007-06-26 14:00:00	QQQ	ETF	47.03	47.09	46.82	46.82	16001736.0
2007-06-26 15:00:00	QQQ	ETF	46.82	46.96	46.74	46.91	19294262.0
2007-06-26 16:00:00	QQQ	ETF	46.94	46.95	46.76	46.79	4011464.0
2007-06-26 17:00:00	QQQ	ETF	46.79	46.87	46.79	46.86	608815.0
2007-06-26 18:00:00	QQQ	ETF	46.82	46.82	46.76	46.78	130973.0
2007-06-26 19:00:00	QQQ	ETF	46.78	46.79	46.77	46.77	63199.0
2007-06-26 07:00:00	IWM	ETF	82.8	82.81	82.8	82.81	10000.0
2007-06-26 08:00:00	IWM	ETF	82.75	82.76	82.62	82.68	1167400.0
2007-06-26 09:00:00	IWM	ETF	82.68	82.93	82.61	82.66	6266440.0
2007-06-26 10:00:00	IWM	ETF	82.66	82.85	81.94	81.94	19178764.0
2007-06-26 11:00:00	IWM	ETF	81.94	82.7	81.9	82.65	14635097.0
2007-06-26 12:00:00	IWM	ETF	82.65	82.81	82.46	82.55	5086998.0
2007-06-26 13:00:00	IWM	ETF	82.55	82.73	82.42	82.56	8582124.0
2007-06-26 14:00:00	IWM	ETF	82.55	82.69	82.08	82.21	11704658.0
2007-06-26 15:00:00	IWM	ETF	82.2	82.43	82.04	82.23	12852050.0
2007-06-26 16:00:00	IWM	ETF	82.22	82.23	81.74	81.9	3298200.0
2007-06-26 17:00:00	IWM	ETF	81.88	81.89	81.8	81.81	71600.0
2007-06-26 18:00:00	IWM	ETF	81.81	81.81	81.81	81.81	200.0
2007-06-26 19:00:00	IWM	ETF	81.78	81.78	81.76	81.76	2800.0
2007-06-26 07:00:00	DIA	ETF	133.95	134.01	133.92	133.92	14600.0
2007-06-26 08:00:00	DIA	ETF	133.92	133.92	133.8	133.83	9400.0
2007-06-26 09:00:00	DIA	ETF	133.84	134.0	133.64	133.85	1495501.0
2007-06-26 10:00:00	DIA	ETF	133.85	134.11	133.26	133.33	5037603.0
2007-06-26 11:00:00	DIA	ETF	133.33	134.3	133.26	134.27	3388742.0
2007-06-26 12:00:00	DIA	ETF	134.29	134.43	133.89	133.95	1565501.0
2007-06-26 13:00:00	DIA	ETF	133.96	134.27	133.57	133.69	2271534.0
2007-06-26 14:00:00	DIA	ETF	133.69	133.9	133.12	133.19	4224453.0

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

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