PREVIEW / etf_1hour / 2007-05-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-21.parquet
  size:    76 KB
  rows:    2,605

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-21 05:00:00	SPY	ETF	152.57	152.57	152.57	152.57	3000.0
2007-05-21 06:00:00	SPY	ETF	152.58	152.66	152.58	152.64	27500.0
2007-05-21 07:00:00	SPY	ETF	152.62	152.76	152.6	152.76	137600.0
2007-05-21 08:00:00	SPY	ETF	152.64	152.75	152.56	152.58	772900.0
2007-05-21 09:00:00	SPY	ETF	152.59	152.76	152.5	152.61	17635848.0
2007-05-21 10:00:00	SPY	ETF	152.61	152.92	152.58	152.87	38876121.0
2007-05-21 11:00:00	SPY	ETF	152.88	152.91	152.73	152.85	75040885.0
2007-05-21 12:00:00	SPY	ETF	152.85	153.2	152.84	153.02	11211340.0
2007-05-21 13:00:00	SPY	ETF	153.025	153.17	152.87	152.98	5048985.0
2007-05-21 14:00:00	SPY	ETF	152.975	153.23	152.93	153.03	5322258.0
2007-05-21 15:00:00	SPY	ETF	153.03	153.03	152.5	152.71	15593710.0
2007-05-21 16:00:00	SPY	ETF	152.72	152.72	152.44	152.47	2281100.0
2007-05-21 17:00:00	SPY	ETF	152.5	152.55	152.5	152.5	1285800.0
2007-05-21 18:00:00	SPY	ETF	152.5	152.57	152.47	152.57	41800.0
2007-05-21 19:00:00	SPY	ETF	152.63	152.63	152.59	152.61	2700.0
2007-05-21 06:00:00	QQQ	ETF	46.8	46.8	46.8	46.8	2500.0
2007-05-21 07:00:00	QQQ	ETF	46.77	46.8	46.77	46.8	228766.0
2007-05-21 08:00:00	QQQ	ETF	46.8	46.83	46.76	46.76	280689.0
2007-05-21 09:00:00	QQQ	ETF	46.76	46.79	46.67	46.72	9357627.0
2007-05-21 10:00:00	QQQ	ETF	46.73	47.1	46.72	47.08	26742621.0
2007-05-21 11:00:00	QQQ	ETF	47.08	47.14	47.0105	47.13	12388941.0
2007-05-21 12:00:00	QQQ	ETF	47.13	47.24	47.08	47.12	10748409.0
2007-05-21 13:00:00	QQQ	ETF	47.12	47.16	47.03	47.09	9547733.0
2007-05-21 14:00:00	QQQ	ETF	47.09	47.18	47.06	47.085	10388387.0
2007-05-21 15:00:00	QQQ	ETF	47.087	47.09	46.83	47.02	28052090.0
2007-05-21 16:00:00	QQQ	ETF	47.01	47.04	46.92	46.95	4143089.0
2007-05-21 17:00:00	QQQ	ETF	46.96	46.98	46.95	46.97	48240.0
2007-05-21 18:00:00	QQQ	ETF	46.96	46.97	46.95	46.96	33800.0
2007-05-21 19:00:00	QQQ	ETF	46.97	46.99	46.95	46.95	14053.0
2007-05-21 07:00:00	IWM	ETF	81.65	81.9	81.65	81.9	17200.0
2007-05-21 08:00:00	IWM	ETF	81.9	81.92	81.76	81.76	400600.0
2007-05-21 09:00:00	IWM	ETF	81.78	82.05	81.66	81.96	4965100.0
2007-05-21 10:00:00	IWM	ETF	81.96	82.72	81.91	82.66	12963167.0
2007-05-21 11:00:00	IWM	ETF	82.66	83.0	82.51	82.96	6332139.0
2007-05-21 12:00:00	IWM	ETF	82.96	83.23	81.12	82.92	7594635.0
2007-05-21 13:00:00	IWM	ETF	82.92	83.01	82.71	82.81	1948100.0
2007-05-21 14:00:00	IWM	ETF	82.82	83.11	82.66	82.87	3540726.0
2007-05-21 15:00:00	IWM	ETF	82.86	82.88	82.4	82.81	7192456.0
2007-05-21 16:00:00	IWM	ETF	82.8	82.85	82.6	82.76	1585500.0
2007-05-21 17:00:00	IWM	ETF	82.7	82.72	82.7	82.72	1600.0
2007-05-21 18:00:00	IWM	ETF	82.68	82.68	82.68	82.68	2000.0
2007-05-21 19:00:00	IWM	ETF	82.74	82.74	82.74	82.74	200.0
2007-05-21 07:00:00	DIA	ETF	135.64	135.69	135.6	135.69	61300.0
2007-05-21 08:00:00	DIA	ETF	135.65	135.69	135.45	135.45	9300.0
2007-05-21 09:00:00	DIA	ETF	135.43	135.45	135.23	135.33	1048350.0
2007-05-21 10:00:00	DIA	ETF	135.35	135.58	135.3	135.55	1215270.0
2007-05-21 11:00:00	DIA	ETF	135.56	135.56	135.35	135.5	451700.0
2007-05-21 12:00:00	DIA	ETF	135.51	135.73	135.48	135.6	564200.0
2007-05-21 13:00:00	DIA	ETF	135.6	135.72	135.54	135.59	358600.0
2007-05-21 14:00:00	DIA	ETF	135.61	135.74	135.55	135.6	409800.0

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

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