PREVIEW / etf_1hour / 2009-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-03.parquet
  size:    124 KB
  rows:    3,827

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-02-03 04:00:00	SPY	ETF	82.9	82.9	82.57	82.62	1600.0
2009-02-03 05:00:00	SPY	ETF	82.17	82.25	82.11	82.11	10506.0
2009-02-03 06:00:00	SPY	ETF	82.21	82.59	82.21	82.35	27200.0
2009-02-03 07:00:00	SPY	ETF	82.35	82.98	82.28	82.72	850499.0
2009-02-03 08:00:00	SPY	ETF	82.07	83.2	82.07	82.78	2219076.0
2009-02-03 09:00:00	SPY	ETF	82.78	83.24	82.22	82.48	31781177.0
2009-02-03 10:00:00	SPY	ETF	82.47	83.18	82.3	82.9	46458466.0
2009-02-03 11:00:00	SPY	ETF	82.9	83.4	82.77	82.86	27813995.0
2009-02-03 12:00:00	SPY	ETF	82.86	83.06	82.63	82.68	24087997.0
2009-02-03 13:00:00	SPY	ETF	82.67	83.17	82.59	82.95	23186724.0
2009-02-03 14:00:00	SPY	ETF	82.96	83.86	82.84	83.63	41572327.0
2009-02-03 15:00:00	SPY	ETF	83.635	84.36	83.47	83.81	64615654.0
2009-02-03 16:00:00	SPY	ETF	83.82	83.93	82.75	83.57	12612326.0
2009-02-03 17:00:00	SPY	ETF	83.57	83.85	83.55	83.78	454989.0
2009-02-03 18:00:00	SPY	ETF	83.75	83.82	83.61	83.61	31879.0
2009-02-03 19:00:00	SPY	ETF	83.61	83.84	83.59	83.8	52632.0
2009-02-03 04:00:00	QQQ	ETF	29.46	29.46	29.46	29.46	400.0
2009-02-03 05:00:00	QQQ	ETF	29.25	29.25	29.22	29.22	700.0
2009-02-03 06:00:00	QQQ	ETF	29.31	29.4	29.22	29.23	37777.0
2009-02-03 07:00:00	QQQ	ETF	29.31	29.46	29.31	29.41	106508.0
2009-02-03 08:00:00	QQQ	ETF	29.41	29.42	29.28	29.39	720510.0
2009-02-03 09:00:00	QQQ	ETF	29.4	29.54	29.03	29.11	19706740.0
2009-02-03 10:00:00	QQQ	ETF	29.11	29.55	29.1	29.44	25060279.0
2009-02-03 11:00:00	QQQ	ETF	29.4405	29.65	29.44	29.47	13115925.0
2009-02-03 12:00:00	QQQ	ETF	29.47	29.51	29.38	29.3801	7837684.0
2009-02-03 13:00:00	QQQ	ETF	29.38	29.54	29.35	29.47	7641923.0
2009-02-03 14:00:00	QQQ	ETF	29.47	29.82	29.46	29.72	15397516.0
2009-02-03 15:00:00	QQQ	ETF	29.73	29.99	29.67	29.87	22884574.0
2009-02-03 16:00:00	QQQ	ETF	29.86	29.998	29.68	29.73	6719122.0
2009-02-03 17:00:00	QQQ	ETF	29.76	29.87	29.76	29.85	235168.0
2009-02-03 18:00:00	QQQ	ETF	29.84	29.85	29.81	29.81	54269.0
2009-02-03 19:00:00	QQQ	ETF	29.79	29.84	29.79	29.82	39349.0
2009-02-03 07:00:00	IWM	ETF	44.87	44.94	44.83	44.92	55712.0
2009-02-03 08:00:00	IWM	ETF	44.97	45.06	44.17	45.03	710794.0
2009-02-03 09:00:00	IWM	ETF	45.05	45.38	44.53	44.65	7685731.0
2009-02-03 10:00:00	IWM	ETF	44.65	45.03	44.45	44.8	11173225.0
2009-02-03 11:00:00	IWM	ETF	44.8	45.15	44.67	44.71	5330431.0
2009-02-03 12:00:00	IWM	ETF	44.72	45.0	44.57	44.57	3057433.0
2009-02-03 13:00:00	IWM	ETF	44.56	44.86	44.54	44.71	3179721.0
2009-02-03 14:00:00	IWM	ETF	44.72	45.26	44.69	45.08	9107813.0
2009-02-03 15:00:00	IWM	ETF	45.08	45.58	45.04	45.2	11888559.0
2009-02-03 16:00:00	IWM	ETF	45.18	45.21	44.8	44.83	2349891.0
2009-02-03 17:00:00	IWM	ETF	44.94	45.08	44.94	45.08	90223.0
2009-02-03 18:00:00	IWM	ETF	45.08	45.11	45.08	45.08	1300.0
2009-02-03 19:00:00	IWM	ETF	45.06	45.06	45.06	45.06	1925.0
2009-02-03 06:00:00	DIA	ETF	79.21	79.21	79.2	79.2	1162.0
2009-02-03 07:00:00	DIA	ETF	79.27	79.65	79.27	79.45	1000.0
2009-02-03 08:00:00	DIA	ETF	79.5	79.65	79.3	79.63	17614.0
2009-02-03 09:00:00	DIA	ETF	79.6	79.88	79.02	79.2	3386489.0
2009-02-03 10:00:00	DIA	ETF	79.2	79.8	79.14	79.62	4586080.0

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

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