PREVIEW / etf_1hour / 2009-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-09.parquet
  size:    127 KB
  rows:    3,921

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-09 04:00:00	SPY	ETF	85.8	86.1	85.8	86.1	43519.0
2009-02-09 05:00:00	SPY	ETF	86.3	86.3	86.15	86.15	25800.0
2009-02-09 06:00:00	SPY	ETF	86.3	86.54	86.3	86.49	32900.0
2009-02-09 07:00:00	SPY	ETF	86.5	86.64	86.22	86.27	593375.0
2009-02-09 08:00:00	SPY	ETF	86.29	86.74	86.26	86.71	3202831.0
2009-02-09 09:00:00	SPY	ETF	86.72	87.09	86.6	86.92	25229486.0
2009-02-09 10:00:00	SPY	ETF	86.93	87.74	86.32	87.68	45822663.0
2009-02-09 11:00:00	SPY	ETF	87.68	87.7	86.91	87.11	26680484.0
2009-02-09 12:00:00	SPY	ETF	87.11	87.5	86.94	87.42	19293592.0
2009-02-09 13:00:00	SPY	ETF	87.42	87.56	86.78	87.13	27579329.0
2009-02-09 14:00:00	SPY	ETF	87.1399	87.2	86.48	86.77	28152747.0
2009-02-09 15:00:00	SPY	ETF	86.76	87.55	86.58	87.159	43847108.0
2009-02-09 16:00:00	SPY	ETF	87.15	87.19	86.65	86.7	6331635.0
2009-02-09 17:00:00	SPY	ETF	86.68	86.8	86.56	86.6	289313.0
2009-02-09 18:00:00	SPY	ETF	86.6	86.75	86.47	86.59	243305.0
2009-02-09 19:00:00	SPY	ETF	86.59	86.63	85.84	85.99	438224.0
2009-02-09 04:00:00	QQQ	ETF	31.17	31.17	31.17	31.17	323.0
2009-02-09 06:00:00	QQQ	ETF	31.31	31.35	31.31	31.34	107913.0
2009-02-09 07:00:00	QQQ	ETF	31.35	31.37	31.19	31.26	285094.0
2009-02-09 08:00:00	QQQ	ETF	31.25	31.39	31.22	31.31	2267158.0
2009-02-09 09:00:00	QQQ	ETF	31.32	31.47	31.22	31.38	10644372.0
2009-02-09 10:00:00	QQQ	ETF	31.39	31.67	31.19	31.64	25158035.0
2009-02-09 11:00:00	QQQ	ETF	31.65	31.65	31.4	31.47	9003656.0
2009-02-09 12:00:00	QQQ	ETF	31.47	31.61	31.42	31.58	5755103.0
2009-02-09 13:00:00	QQQ	ETF	31.5717	31.62	31.37	31.52	7584868.0
2009-02-09 14:00:00	QQQ	ETF	31.51	31.54	31.26	31.35	12622046.0
2009-02-09 15:00:00	QQQ	ETF	31.35	31.6	31.3	31.53	21266887.0
2009-02-09 16:00:00	QQQ	ETF	31.53	31.546	31.39	31.41	3558030.0
2009-02-09 17:00:00	QQQ	ETF	31.39	31.45	31.36	31.44	43662.0
2009-02-09 18:00:00	QQQ	ETF	31.42	31.42	31.32	31.41	69087.0
2009-02-09 19:00:00	QQQ	ETF	31.37	31.41	31.18	31.23	86068.0
2009-02-09 07:00:00	IWM	ETF	46.67	46.69	46.55	46.64	12144.0
2009-02-09 08:00:00	IWM	ETF	46.59	46.73	46.58	46.71	87201.0
2009-02-09 09:00:00	IWM	ETF	46.71	46.86	46.41	46.548	4845790.0
2009-02-09 10:00:00	IWM	ETF	46.54	47.12	46.22	47.11	11564130.0
2009-02-09 11:00:00	IWM	ETF	47.12	47.14	46.69	46.83	4562852.0
2009-02-09 12:00:00	IWM	ETF	46.84	47.03	46.73	46.97	3137761.0
2009-02-09 13:00:00	IWM	ETF	46.98	47.04	46.58	46.78	4637893.0
2009-02-09 14:00:00	IWM	ETF	46.79	46.84	46.29	46.46	5865806.0
2009-02-09 15:00:00	IWM	ETF	46.46	46.9	46.38	46.74	7839549.0
2009-02-09 16:00:00	IWM	ETF	46.74	47.0245	46.69	46.7	8284418.0
2009-02-09 17:00:00	IWM	ETF	47.0244	47.0244	46.61	46.61	2002541.0
2009-02-09 19:00:00	IWM	ETF	46.38	46.38	46.38	46.38	1300.0
2009-02-09 07:00:00	DIA	ETF	82.55	82.62	82.4	82.41	14800.0
2009-02-09 08:00:00	DIA	ETF	82.41	82.7	82.4	82.65	39730.0
2009-02-09 09:00:00	DIA	ETF	82.67	82.87	82.43	82.54	2906491.0
2009-02-09 10:00:00	DIA	ETF	82.54	83.29	82.1	83.26	3978837.0
2009-02-09 11:00:00	DIA	ETF	83.26	83.27	82.67	82.84	2669293.0
2009-02-09 12:00:00	DIA	ETF	82.8598	83.15	82.72	83.09	1634416.0
2009-02-09 13:00:00	DIA	ETF	83.1	83.21	82.5	82.78	1887410.0

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

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