PREVIEW / etf_1hour / 2009-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-22.parquet
  size:    143 KB
  rows:    4,418

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-09-22 04:00:00	SPY	ETF	107.22	107.25	107.22	107.25	1625.0
2009-09-22 05:00:00	SPY	ETF	107.15	107.19	107.15	107.19	6600.0
2009-09-22 06:00:00	SPY	ETF	107.19	107.34	107.19	107.27	51150.0
2009-09-22 07:00:00	SPY	ETF	107.26	107.29	107.16	107.21	538209.0
2009-09-22 08:00:00	SPY	ETF	107.21	107.37	107.08	107.08	1383242.0
2009-09-22 09:00:00	SPY	ETF	107.08	107.25	106.78	106.83	22124938.0
2009-09-22 10:00:00	SPY	ETF	106.83	107.05	106.6	106.83	21713232.0
2009-09-22 11:00:00	SPY	ETF	106.83	107.11	106.83	107.0775	10601017.0
2009-09-22 12:00:00	SPY	ETF	107.0701	107.35	107.0	107.1785	14893970.0
2009-09-22 13:00:00	SPY	ETF	107.18	107.37	106.96	107.09	15129406.0
2009-09-22 14:00:00	SPY	ETF	107.1	107.25	107.01	107.23	11322676.0
2009-09-22 15:00:00	SPY	ETF	107.23	107.31	107.0	107.1	25258410.0
2009-09-22 16:00:00	SPY	ETF	107.09	107.2332	106.71	107.15	9370607.0
2009-09-22 17:00:00	SPY	ETF	107.15	107.15	107.03	107.09	295236.0
2009-09-22 18:00:00	SPY	ETF	107.09	107.26	107.08	107.26	289453.0
2009-09-22 19:00:00	SPY	ETF	107.22	107.26	107.17	107.24	78880.0
2009-09-22 04:00:00	QQQ	ETF	42.84	42.86	42.84	42.84	52125.0
2009-09-22 05:00:00	QQQ	ETF	42.83	42.85	42.83	42.85	31500.0
2009-09-22 06:00:00	QQQ	ETF	42.87	42.87	42.84	42.87	56600.0
2009-09-22 07:00:00	QQQ	ETF	42.86	42.86	42.78	42.82	458036.0
2009-09-22 08:00:00	QQQ	ETF	42.82	42.9	42.77	42.77	741582.0
2009-09-22 09:00:00	QQQ	ETF	42.78	42.86	42.4398	42.62	14891930.0
2009-09-22 10:00:00	QQQ	ETF	42.62	42.72	42.49	42.57	15650398.0
2009-09-22 11:00:00	QQQ	ETF	42.56	42.7	42.56	42.68	4435811.0
2009-09-22 12:00:00	QQQ	ETF	42.68	42.77	42.65	42.68	8103013.0
2009-09-22 13:00:00	QQQ	ETF	42.6799	42.75	42.58	42.63	6516911.0
2009-09-22 14:00:00	QQQ	ETF	42.63	42.71	42.59	42.7	4345721.0
2009-09-22 15:00:00	QQQ	ETF	42.7	42.74	42.6	42.65	14588796.0
2009-09-22 16:00:00	QQQ	ETF	42.65	42.74	42.6	42.71	3397987.0
2009-09-22 17:00:00	QQQ	ETF	42.69	42.73	42.69	42.69	12389.0
2009-09-22 18:00:00	QQQ	ETF	42.66	42.74	42.66	42.74	22141.0
2009-09-22 19:00:00	QQQ	ETF	42.74	42.76	42.74	42.75	120298.0
2009-09-22 04:00:00	IWM	ETF	62.17	62.17	62.17	62.17	100.0
2009-09-22 06:00:00	IWM	ETF	62.1	62.2	62.1	62.2	4100.0
2009-09-22 07:00:00	IWM	ETF	62.14	62.17	62.09	62.11	44556.0
2009-09-22 08:00:00	IWM	ETF	62.45	62.45	62.03	62.04	713877.0
2009-09-22 09:00:00	IWM	ETF	62.04	62.09	61.72	61.73	8168275.0
2009-09-22 10:00:00	IWM	ETF	61.73	61.92	61.59	61.7395	7481384.0
2009-09-22 11:00:00	IWM	ETF	61.74	61.95	61.74	61.95	2525628.0
2009-09-22 12:00:00	IWM	ETF	61.95	62.21	61.9	62.06	3196970.0
2009-09-22 13:00:00	IWM	ETF	62.07	62.21	61.9	62.0401	3766893.0
2009-09-22 14:00:00	IWM	ETF	62.05	62.24	62.02	62.23	2656891.0
2009-09-22 15:00:00	IWM	ETF	62.23	62.24	61.99	62.04	5375088.0
2009-09-22 16:00:00	IWM	ETF	62.03	62.09	61.96	62.06	1279761.0
2009-09-22 17:00:00	IWM	ETF	62.06	62.08	62.02	62.02	10744.0
2009-09-22 18:00:00	IWM	ETF	62.07	62.12	62.07	62.12	1494.0
2009-09-22 19:00:00	IWM	ETF	62.12	62.15	62.01	62.15	5900.0
2009-09-22 06:00:00	DIA	ETF	98.44	98.44	98.44	98.44	100.0
2009-09-22 07:00:00	DIA	ETF	98.42	98.43	98.4	98.4	3051.0
2009-09-22 08:00:00	DIA	ETF	98.32	98.42	98.24	98.25	21272.0

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

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