PREVIEW / etf_1hour / 2009-12-31

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-31.parquet
  size:    148 KB
  rows:    4,596

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
2009-12-31 04:00:00	SPY	ETF	112.6	112.6	112.6	112.6	100.0
2009-12-31 05:00:00	SPY	ETF	112.74	112.74	112.74	112.74	100.0
2009-12-31 06:00:00	SPY	ETF	112.84	112.84	112.84	112.84	200.0
2009-12-31 07:00:00	SPY	ETF	112.84	112.9	112.8	112.84	68388.0
2009-12-31 08:00:00	SPY	ETF	112.84	112.92	112.71	112.86	1781288.0
2009-12-31 09:00:00	SPY	ETF	112.85	112.86	112.61	112.62	6786961.0
2009-12-31 10:00:00	SPY	ETF	112.6174	112.62	112.33	112.4	9401473.0
2009-12-31 11:00:00	SPY	ETF	112.4	112.41	112.15	112.23	10642872.0
2009-12-31 12:00:00	SPY	ETF	112.22	112.33	112.22	112.28	7438493.0
2009-12-31 13:00:00	SPY	ETF	112.28	112.6386	112.15	112.27	9342838.0
2009-12-31 14:00:00	SPY	ETF	112.26	112.6386	112.2	112.3	7248367.0
2009-12-31 15:00:00	SPY	ETF	112.3	112.35	111.43	111.44	26330956.0
2009-12-31 16:00:00	SPY	ETF	111.44	112.6386	111.42	111.48	10233414.0
2009-12-31 17:00:00	SPY	ETF	111.5	111.59	111.4	111.41	113295.0
2009-12-31 18:00:00	SPY	ETF	111.44	111.46	111.01	111.02	237525.0
2009-12-31 19:00:00	SPY	ETF	111.02	111.2	110.92	111.0	246412.0
2009-12-31 07:00:00	QQQ	ETF	46.24	46.24	46.22	46.23	5600.0
2009-12-31 08:00:00	QQQ	ETF	46.23	46.29	46.21	46.28	606660.0
2009-12-31 09:00:00	QQQ	ETF	46.27	46.275	46.15	46.175	6095974.0
2009-12-31 10:00:00	QQQ	ETF	46.1737	46.19	46.03	46.08	7018633.0
2009-12-31 11:00:00	QQQ	ETF	46.08	46.09	45.965	46.02	4525683.0
2009-12-31 12:00:00	QQQ	ETF	46.02	46.06	46.02	46.03	1548866.0
2009-12-31 13:00:00	QQQ	ETF	46.038	46.04	45.95	46.009	2019433.0
2009-12-31 14:00:00	QQQ	ETF	46.0074	46.01	45.96	45.995	2307588.0
2009-12-31 15:00:00	QQQ	ETF	45.9999	46.0431	45.75	45.76	14578956.0
2009-12-31 16:00:00	QQQ	ETF	45.75	46.0431	45.74	45.86	10798696.0
2009-12-31 17:00:00	QQQ	ETF	45.86	45.9	45.84	45.85	29340.0
2009-12-31 18:00:00	QQQ	ETF	45.85	45.87	45.81	45.82	75780.0
2009-12-31 19:00:00	QQQ	ETF	45.83	45.84	45.53	45.53	288261.0
2009-12-31 07:00:00	IWM	ETF	63.36	63.41	63.32	63.33	10000.0
2009-12-31 08:00:00	IWM	ETF	63.38	63.44	63.26	63.32	391988.0
2009-12-31 09:00:00	IWM	ETF	63.31	63.57	63.22	63.44	4506364.0
2009-12-31 10:00:00	IWM	ETF	63.44	63.46	63.23	63.329	3543417.0
2009-12-31 11:00:00	IWM	ETF	63.329	63.36	63.07	63.1299	4232480.0
2009-12-31 12:00:00	IWM	ETF	63.125	63.21	63.075	63.19	1843237.0
2009-12-31 13:00:00	IWM	ETF	63.195	63.25	63.1	63.19	1269470.0
2009-12-31 14:00:00	IWM	ETF	63.1901	63.21	63.12	63.165	1479896.0
2009-12-31 15:00:00	IWM	ETF	63.17	63.3	62.33	62.35	12639422.0
2009-12-31 16:00:00	IWM	ETF	62.34	63.3002	62.24	62.4	4322976.0
2009-12-31 17:00:00	IWM	ETF	62.39	62.52	62.33	62.43	16158.0
2009-12-31 19:00:00	IWM	ETF	62.37	62.37	62.37	62.37	200.0
2009-12-31 07:00:00	DIA	ETF	105.22	105.36	105.22	105.36	700.0
2009-12-31 08:00:00	DIA	ETF	105.42	105.49	105.35	105.39	26920.0
2009-12-31 09:00:00	DIA	ETF	105.41	105.41	105.17	105.18	375923.0
2009-12-31 10:00:00	DIA	ETF	105.18	105.18	104.91	104.991	800613.0
2009-12-31 11:00:00	DIA	ETF	104.9901	105.01	104.67	104.68	656130.0
2009-12-31 12:00:00	DIA	ETF	104.67	104.85	104.67	104.8	455290.0
2009-12-31 13:00:00	DIA	ETF	104.8	104.86	104.7	104.78	357346.0
2009-12-31 14:00:00	DIA	ETF	104.78	104.82	104.71	104.82	428403.0
2009-12-31 15:00:00	DIA	ETF	104.83	104.86	104.03	104.06	1868279.0

> showing 50 of 4,596 rows — these rows as CSV

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