PREVIEW / etf_1hour / 2007-05-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-05-29.parquet
  size:    77 KB
  rows:    2,614

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-29 06:00:00	SPY	ETF	152.13	152.13	151.9	151.9	10000.0
2007-05-29 07:00:00	SPY	ETF	152.03	152.07	152.0	152.05	115600.0
2007-05-29 08:00:00	SPY	ETF	152.04	152.14	151.73	152.04	562600.0
2007-05-29 09:00:00	SPY	ETF	152.03	152.38	151.89	152.36	10755886.0
2007-05-29 10:00:00	SPY	ETF	152.35	152.5	152.01	152.29	15568913.0
2007-05-29 11:00:00	SPY	ETF	152.3	152.44	151.97	151.98	8963782.0
2007-05-29 12:00:00	SPY	ETF	151.98	152.05	151.72	151.95	8738109.0
2007-05-29 13:00:00	SPY	ETF	151.96	152.07	151.45	151.67	12033528.0
2007-05-29 14:00:00	SPY	ETF	151.66	151.83	151.5	151.76	10171920.0
2007-05-29 15:00:00	SPY	ETF	151.75	152.17	151.73	152.08	13054256.0
2007-05-29 16:00:00	SPY	ETF	152.11	152.28	152.08	152.15	1293000.0
2007-05-29 17:00:00	SPY	ETF	152.14	152.15	152.13	152.13	4900.0
2007-05-29 18:00:00	SPY	ETF	152.1	152.14	152.1	152.14	1939600.0
2007-05-29 19:00:00	SPY	ETF	152.12	152.14	152.12	152.14	1100.0
2007-05-29 07:00:00	QQQ	ETF	46.52	46.52	46.49	46.52	56997.0
2007-05-29 08:00:00	QQQ	ETF	46.51	46.55	46.51	46.53	315688.0
2007-05-29 09:00:00	QQQ	ETF	46.51	46.81	46.48	46.75	12850158.0
2007-05-29 10:00:00	QQQ	ETF	46.75	46.86	46.65	46.79	17404175.0
2007-05-29 11:00:00	QQQ	ETF	46.79	46.82	46.66	46.66	11000693.0
2007-05-29 12:00:00	QQQ	ETF	46.67	46.7	46.56	46.66	8666071.0
2007-05-29 13:00:00	QQQ	ETF	46.66	46.7	46.41	46.49	11704490.0
2007-05-29 14:00:00	QQQ	ETF	46.5	46.6	46.44	46.57	9683947.0
2007-05-29 15:00:00	QQQ	ETF	46.57	46.76	46.56	46.75	12444154.0
2007-05-29 16:00:00	QQQ	ETF	46.76	46.82	46.5	46.74	3975073.0
2007-05-29 17:00:00	QQQ	ETF	46.74	46.77	46.71	46.74	16098.0
2007-05-29 18:00:00	QQQ	ETF	46.75	46.75	46.72	46.74	8617.0
2007-05-29 19:00:00	QQQ	ETF	46.72	46.75	46.72	46.75	11030.0
2007-05-29 08:00:00	IWM	ETF	82.74	82.82	82.74	82.75	57800.0
2007-05-29 09:00:00	IWM	ETF	82.75	83.2	82.72	83.13	5647100.0
2007-05-29 10:00:00	IWM	ETF	83.13	83.32	82.87	83.18	9675646.0
2007-05-29 11:00:00	IWM	ETF	83.19	83.39	83.06	83.07	5844833.0
2007-05-29 12:00:00	IWM	ETF	83.06	83.06	82.81	82.95	8550974.0
2007-05-29 13:00:00	IWM	ETF	82.96	83.09	82.72	82.89	12865239.0
2007-05-29 14:00:00	IWM	ETF	82.89	82.98	82.76	82.96	5489600.0
2007-05-29 15:00:00	IWM	ETF	82.96	83.25	82.94	83.22	7680830.0
2007-05-29 16:00:00	IWM	ETF	83.22	83.33	83.15	83.33	1707000.0
2007-05-29 17:00:00	IWM	ETF	83.27	83.27	83.27	83.27	1100.0
2007-05-29 18:00:00	IWM	ETF	83.27	83.27	83.27	83.27	7000.0
2007-05-29 07:00:00	DIA	ETF	135.0	135.0	135.0	135.0	1800.0
2007-05-29 08:00:00	DIA	ETF	135.15	135.25	135.15	135.22	34900.0
2007-05-29 09:00:00	DIA	ETF	135.2	135.47	135.13	135.45	1491642.0
2007-05-29 10:00:00	DIA	ETF	135.46	135.9	135.17	135.25	1882400.0
2007-05-29 11:00:00	DIA	ETF	135.25	135.37	134.92	134.93	1389750.0
2007-05-29 12:00:00	DIA	ETF	134.92	135.02	134.73	134.96	1299900.0
2007-05-29 13:00:00	DIA	ETF	134.96	135.04	134.57	134.76	1803200.0
2007-05-29 14:00:00	DIA	ETF	134.76	134.86	134.58	134.75	1787901.0
2007-05-29 15:00:00	DIA	ETF	134.76	135.18	134.74	135.09	1752500.0
2007-05-29 16:00:00	DIA	ETF	135.1	135.25	135.0	135.21	705900.0
2007-05-29 17:00:00	DIA	ETF	135.2	135.2	135.2	135.2	100.0
2007-05-29 19:00:00	DIA	ETF	135.21	135.21	135.21	135.21	300.0

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

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