PREVIEW / etf_1hour / 2009-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-04.parquet
  size:    138 KB
  rows:    4,271

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-06-04 04:00:00	SPY	ETF	94.16	94.22	94.04	94.04	3755.0
2009-06-04 05:00:00	SPY	ETF	94.07	94.27	94.04	94.27	51300.0
2009-06-04 06:00:00	SPY	ETF	94.15	94.3	94.02	94.1	30250.0
2009-06-04 07:00:00	SPY	ETF	94.09	94.09	93.56	93.56	847786.0
2009-06-04 08:00:00	SPY	ETF	93.59	94.11	93.46	93.99	5254955.0
2009-06-04 09:00:00	SPY	ETF	94.01	94.3	93.49	93.75	24037025.0
2009-06-04 10:00:00	SPY	ETF	93.74	94.25	93.3	94.15	34289813.0
2009-06-04 11:00:00	SPY	ETF	94.15	94.27	93.92	93.92	26770625.0
2009-06-04 12:00:00	SPY	ETF	93.92	94.28	93.76	94.15	19508464.0
2009-06-04 13:00:00	SPY	ETF	94.1401	94.59	94.09	94.49	21852100.0
2009-06-04 14:00:00	SPY	ETF	94.4901	94.63	94.37	94.42	25667193.0
2009-06-04 15:00:00	SPY	ETF	94.42	94.67	94.26	94.55	42030248.0
2009-06-04 16:00:00	SPY	ETF	94.57	94.6529	93.5806	94.64	7173744.0
2009-06-04 17:00:00	SPY	ETF	94.63	94.64	94.54	94.62	194833.0
2009-06-04 18:00:00	SPY	ETF	94.58	94.64	94.55	94.61	155755.0
2009-06-04 19:00:00	SPY	ETF	94.62	94.65	94.59	94.65	73490.0
2009-06-04 04:00:00	QQQ	ETF	36.55	36.55	36.55	36.55	100.0
2009-06-04 05:00:00	QQQ	ETF	36.55	36.58	36.55	36.58	10100.0
2009-06-04 06:00:00	QQQ	ETF	36.54	36.54	36.45	36.45	800.0
2009-06-04 07:00:00	QQQ	ETF	36.44	36.47	36.33	36.33	104860.0
2009-06-04 08:00:00	QQQ	ETF	36.33	36.47	36.31	36.44	1395870.0
2009-06-04 09:00:00	QQQ	ETF	36.44	36.67	36.34	36.61	14522025.0
2009-06-04 10:00:00	QQQ	ETF	36.62	36.62	36.38	36.57	14867333.0
2009-06-04 11:00:00	QQQ	ETF	36.56	36.59	36.48	36.48	10210211.0
2009-06-04 12:00:00	QQQ	ETF	36.49	36.62	36.41	36.57	6760489.0
2009-06-04 13:00:00	QQQ	ETF	36.56	36.74	36.5	36.67	7388348.0
2009-06-04 14:00:00	QQQ	ETF	36.67	36.73	36.6	36.65	8874571.0
2009-06-04 15:00:00	QQQ	ETF	36.65	36.79	36.57	36.73	15901829.0
2009-06-04 16:00:00	QQQ	ETF	36.73	36.78	36.6701	36.76	4058470.0
2009-06-04 17:00:00	QQQ	ETF	36.76	36.78	36.75	36.77	126608.0
2009-06-04 18:00:00	QQQ	ETF	36.77	36.78	36.75	36.76	14900.0
2009-06-04 19:00:00	QQQ	ETF	36.78	36.82	36.76	36.81	154265.0
2009-06-04 06:00:00	IWM	ETF	52.84	52.84	52.82	52.82	200.0
2009-06-04 07:00:00	IWM	ETF	52.81	52.85	52.51	52.51	141068.0
2009-06-04 08:00:00	IWM	ETF	52.53	53.05	52.42	52.74	580695.0
2009-06-04 09:00:00	IWM	ETF	52.73	52.83	52.29	52.46	4724340.0
2009-06-04 10:00:00	IWM	ETF	52.46	52.79	52.09	52.76	6071311.0
2009-06-04 11:00:00	IWM	ETF	52.76	52.8	52.61	52.61	4474838.0
2009-06-04 12:00:00	IWM	ETF	52.61	52.88	52.51	52.81	4388215.0
2009-06-04 13:00:00	IWM	ETF	52.81	53.23	52.8	53.142	3862497.0
2009-06-04 14:00:00	IWM	ETF	53.15	53.19	52.98	53.01	4065311.0
2009-06-04 15:00:00	IWM	ETF	53.02	53.26	52.91	53.23	9218229.0
2009-06-04 16:00:00	IWM	ETF	53.23	53.2474	52.355	53.24	3658833.0
2009-06-04 17:00:00	IWM	ETF	53.22	53.24	53.22	53.22	1300.0
2009-06-04 19:00:00	IWM	ETF	53.2	53.2	53.2	53.2	100.0
2009-06-04 06:00:00	DIA	ETF	87.4	87.4	87.38	87.38	3000.0
2009-06-04 07:00:00	DIA	ETF	87.27	87.27	86.91	86.91	7400.0
2009-06-04 08:00:00	DIA	ETF	86.84	87.3	86.79	87.15	1057053.0
2009-06-04 09:00:00	DIA	ETF	87.13	87.18	86.64	86.84	2221720.0
2009-06-04 10:00:00	DIA	ETF	86.86	87.3916	86.49	87.3	1870238.0

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

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