PREVIEW / etf_1hour / 2009-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-02.parquet
  size:    123 KB
  rows:    3,700

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-01-02 04:00:00	SPY	ETF	89.99	89.99	89.99	89.99	100.0
2009-01-02 05:00:00	SPY	ETF	90.01	90.14	90.01	90.1	1400.0
2009-01-02 06:00:00	SPY	ETF	90.1	90.96	90.0	90.75	64440.0
2009-01-02 07:00:00	SPY	ETF	90.79	90.9	90.55	90.62	166675.0
2009-01-02 08:00:00	SPY	ETF	90.64	90.74	89.96	90.22	2273466.0
2009-01-02 09:00:00	SPY	ETF	90.22	90.66	89.85	90.08	24758273.0
2009-01-02 10:00:00	SPY	ETF	90.07	91.57	89.92	91.52	31675878.0
2009-01-02 11:00:00	SPY	ETF	91.53	91.85	91.33	91.63	25298162.0
2009-01-02 12:00:00	SPY	ETF	91.63	92.13	91.56	91.93	20001803.0
2009-01-02 13:00:00	SPY	ETF	91.92	92.57	91.85	92.36	20829522.0
2009-01-02 14:00:00	SPY	ETF	92.36	92.92	92.14	92.79	34732237.0
2009-01-02 15:00:00	SPY	ETF	92.79	93.44	92.78	92.97	57906569.0
2009-01-02 16:00:00	SPY	ETF	92.99	93.05	91.14	92.69	8003858.0
2009-01-02 17:00:00	SPY	ETF	92.69	92.75	92.65	92.65	63257.0
2009-01-02 18:00:00	SPY	ETF	92.69	92.83	92.69	92.78	28723.0
2009-01-02 19:00:00	SPY	ETF	92.78	92.83	92.67	92.77	34949.0
2009-01-02 06:00:00	QQQ	ETF	29.84	29.96	29.84	29.96	1200.0
2009-01-02 07:00:00	QQQ	ETF	29.93	29.98	29.86	29.89	23315.0
2009-01-02 08:00:00	QQQ	ETF	29.88	29.9	29.59	29.67	1526955.0
2009-01-02 09:00:00	QQQ	ETF	29.65	29.91	29.64	29.8099	9523865.0
2009-01-02 10:00:00	QQQ	ETF	29.8	30.37	29.75	30.3405	19453684.0
2009-01-02 11:00:00	QQQ	ETF	30.34	30.47	30.25	30.41	11360018.0
2009-01-02 12:00:00	QQQ	ETF	30.42	30.65	30.38	30.59	9689319.0
2009-01-02 13:00:00	QQQ	ETF	30.59	30.8	30.55	30.71	9317671.0
2009-01-02 14:00:00	QQQ	ETF	30.72	30.93	30.64	30.87	12890886.0
2009-01-02 15:00:00	QQQ	ETF	30.86	31.13	30.35	31.02	24416733.0
2009-01-02 16:00:00	QQQ	ETF	31.03	31.1	30.78	30.9	4378532.0
2009-01-02 17:00:00	QQQ	ETF	30.9	30.92	30.86	30.92	57360.0
2009-01-02 18:00:00	QQQ	ETF	30.9	30.99	30.9	30.99	15218.0
2009-01-02 19:00:00	QQQ	ETF	30.97	30.97	30.86	30.86	13200.0
2009-01-02 06:00:00	IWM	ETF	49.71	50.07	49.71	50.07	800.0
2009-01-02 07:00:00	IWM	ETF	50.21	50.21	50.03	50.1	14675.0
2009-01-02 08:00:00	IWM	ETF	50.09	50.13	49.27	49.84	783378.0
2009-01-02 09:00:00	IWM	ETF	49.82	50.05	49.22	49.36	6148542.0
2009-01-02 10:00:00	IWM	ETF	49.35	50.45	49.24	50.39	10138885.0
2009-01-02 11:00:00	IWM	ETF	50.4	50.458	50.11	50.14	5689738.0
2009-01-02 12:00:00	IWM	ETF	50.15	50.48	50.13	50.33	3090534.0
2009-01-02 13:00:00	IWM	ETF	50.33	50.58	50.3084	50.43	4293293.0
2009-01-02 14:00:00	IWM	ETF	50.43	50.59	50.19	50.49	5450223.0
2009-01-02 15:00:00	IWM	ETF	50.5	50.72	49.8	50.17	12829067.0
2009-01-02 16:00:00	IWM	ETF	50.19	50.32	49.24	50.22	3101356.0
2009-01-02 17:00:00	IWM	ETF	50.12	50.12	50.11	50.11	416.0
2009-01-02 18:00:00	IWM	ETF	50.15	50.15	50.08	50.08	975.0
2009-01-02 05:00:00	DIA	ETF	86.94	86.94	86.94	86.94	100.0
2009-01-02 06:00:00	DIA	ETF	87.66	88.31	87.66	88.24	4604.0
2009-01-02 07:00:00	DIA	ETF	88.23	88.28	88.06	88.18	3400.0
2009-01-02 08:00:00	DIA	ETF	88.16	88.2	87.62	87.77	42346.0
2009-01-02 09:00:00	DIA	ETF	87.77	88.15	87.57	87.81	2598951.0
2009-01-02 10:00:00	DIA	ETF	87.8	89.06	87.66	89.02	4613073.0
2009-01-02 11:00:00	DIA	ETF	89.03	89.33	88.87	89.13	2574630.0

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

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