PREVIEW / etf_1hour / 2007-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-27.parquet
  size:    94 KB
  rows:    3,122

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-12-27 06:00:00	SPY	ETF	149.41	149.43	149.41	149.43	6500.0
2007-12-27 07:00:00	SPY	ETF	149.5	149.63	149.5	149.59	67200.0
2007-12-27 08:00:00	SPY	ETF	149.63	149.63	148.73	148.87	5990800.0
2007-12-27 09:00:00	SPY	ETF	148.87	149.03	148.58	148.6	11913486.0
2007-12-27 10:00:00	SPY	ETF	148.6	148.97	148.38	148.46	13906756.0
2007-12-27 11:00:00	SPY	ETF	148.46	148.57	148.26	148.5	14283057.0
2007-12-27 12:00:00	SPY	ETF	148.5	148.52	147.78	147.98	20947179.0
2007-12-27 13:00:00	SPY	ETF	147.98	148.24	147.73	148.08	9349939.0
2007-12-27 14:00:00	SPY	ETF	148.09	148.34	147.87	148.04	11118766.0
2007-12-27 15:00:00	SPY	ETF	148.04	148.27	147.32	147.52	19792765.0
2007-12-27 16:00:00	SPY	ETF	147.55	149.06	147.39	147.81	7297778.0
2007-12-27 17:00:00	SPY	ETF	147.82	149.53	147.78	147.9	4049500.0
2007-12-27 18:00:00	SPY	ETF	147.82	148.01	147.77	147.97	30600.0
2007-12-27 19:00:00	SPY	ETF	148.0	148.01	147.77	147.88	36600.0
2007-12-27 04:00:00	QQQ	ETF	52.48	52.48	52.48	52.48	200.0
2007-12-27 06:00:00	QQQ	ETF	52.63	52.63	52.63	52.63	100.0
2007-12-27 07:00:00	QQQ	ETF	52.66	52.71	52.59	52.65	362300.0
2007-12-27 08:00:00	QQQ	ETF	52.67	52.74	52.3	52.41	2329814.0
2007-12-27 09:00:00	QQQ	ETF	52.43	52.45	52.25	52.26	8104689.0
2007-12-27 10:00:00	QQQ	ETF	52.26	52.5	52.25	52.27	8246235.0
2007-12-27 11:00:00	QQQ	ETF	52.27	52.301	52.08	52.2605	5909633.0
2007-12-27 12:00:00	QQQ	ETF	52.26	52.27	51.98	52.08	7394054.0
2007-12-27 13:00:00	QQQ	ETF	52.08	52.21	51.98	52.141	6611575.0
2007-12-27 14:00:00	QQQ	ETF	52.13	52.25	52.03	52.07	6692037.0
2007-12-27 15:00:00	QQQ	ETF	52.06	52.13	51.71	51.84	13679902.0
2007-12-27 16:00:00	QQQ	ETF	51.85	51.94	51.73	51.85	6419576.0
2007-12-27 17:00:00	QQQ	ETF	51.87	51.88	51.84	51.84	14862.0
2007-12-27 18:00:00	QQQ	ETF	51.87	51.92	51.82	51.92	8688.0
2007-12-27 19:00:00	QQQ	ETF	51.9	51.92	51.9	51.92	5230.0
2007-12-27 06:00:00	IWM	ETF	79.2	79.2	79.2	79.2	5000.0
2007-12-27 07:00:00	IWM	ETF	79.22	79.25	79.22	79.25	5200.0
2007-12-27 08:00:00	IWM	ETF	79.22	79.25	78.84	78.85	634400.0
2007-12-27 09:00:00	IWM	ETF	78.8	79.08	78.54	78.54	8680060.0
2007-12-27 10:00:00	IWM	ETF	78.54	78.81	78.22	78.23	11291614.0
2007-12-27 11:00:00	IWM	ETF	78.23	78.3	77.97	78.08	6005000.0
2007-12-27 12:00:00	IWM	ETF	78.07	78.09	77.47	77.63	7597700.0
2007-12-27 13:00:00	IWM	ETF	77.63	77.86	77.56	77.77	5613525.0
2007-12-27 14:00:00	IWM	ETF	77.77	78.1	77.65	77.73	8047633.0
2007-12-27 15:00:00	IWM	ETF	77.73	77.9	76.91	77.06	19204761.0
2007-12-27 16:00:00	IWM	ETF	77.06	78.58	76.99	77.35	4391962.0
2007-12-27 17:00:00	IWM	ETF	77.35	77.4	77.35	77.4	2900.0
2007-12-27 18:00:00	IWM	ETF	77.38	77.4	77.38	77.38	4000.0
2007-12-27 19:00:00	IWM	ETF	77.4	77.4	77.37	77.38	6300.0
2007-12-27 08:00:00	DIA	ETF	135.32	135.42	134.75	134.91	26600.0
2007-12-27 09:00:00	DIA	ETF	134.82	134.99	134.52	134.53	752110.0
2007-12-27 10:00:00	DIA	ETF	134.55	134.8	134.27	134.31	946100.0
2007-12-27 11:00:00	DIA	ETF	134.31	134.39	134.08	134.27	1377200.0
2007-12-27 12:00:00	DIA	ETF	134.25	134.26	133.66	133.79	1129267.0
2007-12-27 13:00:00	DIA	ETF	133.79	134.03	133.6	133.94	921000.0
2007-12-27 14:00:00	DIA	ETF	133.94	134.14	133.72	133.91	966666.0

> showing 50 of 3,122 rows — these rows as CSV

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