PREVIEW / etf_1hour / 2009-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-23.parquet
  size:    143 KB
  rows:    4,397

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-10-23 04:00:00	SPY	ETF	109.81	109.81	109.53	109.68	2020.0
2009-10-23 05:00:00	SPY	ETF	109.49	109.61	109.43	109.61	500.0
2009-10-23 06:00:00	SPY	ETF	109.58	109.58	109.44	109.54	10500.0
2009-10-23 07:00:00	SPY	ETF	109.5	109.78	109.45	109.68	264773.0
2009-10-23 08:00:00	SPY	ETF	109.66	109.95	109.58	109.9	3282471.0
2009-10-23 09:00:00	SPY	ETF	109.91	109.98	109.19	109.41	28889163.0
2009-10-23 10:00:00	SPY	ETF	109.41	109.73	108.51	108.57	42997448.0
2009-10-23 11:00:00	SPY	ETF	108.57	108.76	108.06	108.469	31444608.0
2009-10-23 12:00:00	SPY	ETF	108.47	108.73	108.25	108.47	18346688.0
2009-10-23 13:00:00	SPY	ETF	108.46	108.55	107.77	108.01	24564245.0
2009-10-23 14:00:00	SPY	ETF	108.01	108.29	107.76	107.95	24551814.0
2009-10-23 15:00:00	SPY	ETF	107.95	108.21	107.63	108.07	50557342.0
2009-10-23 16:00:00	SPY	ETF	108.08	109.49	107.91	108.1	13107707.0
2009-10-23 17:00:00	SPY	ETF	108.09	108.14	108.03	108.05	44866.0
2009-10-23 18:00:00	SPY	ETF	108.09	108.24	108.0	108.12	92821.0
2009-10-23 19:00:00	SPY	ETF	108.14	108.16	108.12	108.16	14701.0
2009-10-23 05:00:00	QQQ	ETF	43.5	43.5	43.5	43.5	2000.0
2009-10-23 06:00:00	QQQ	ETF	43.47	43.47	43.45	43.45	700.0
2009-10-23 07:00:00	QQQ	ETF	43.48	43.53	43.48	43.5	45614.0
2009-10-23 08:00:00	QQQ	ETF	43.52	43.79	43.48	43.78	5833269.0
2009-10-23 09:00:00	QQQ	ETF	43.78	43.79	43.31	43.62	15514591.0
2009-10-23 10:00:00	QQQ	ETF	43.62	43.71	43.19	43.21	25710189.0
2009-10-23 11:00:00	QQQ	ETF	43.21	43.34	43.11	43.29	19595002.0
2009-10-23 12:00:00	QQQ	ETF	43.29	43.368	43.23	43.2505	6772467.0
2009-10-23 13:00:00	QQQ	ETF	43.25	43.31	43.0399	43.13	10582127.0
2009-10-23 14:00:00	QQQ	ETF	43.14	43.275	43.04	43.15	9081301.0
2009-10-23 15:00:00	QQQ	ETF	43.15	43.24	43.02	43.13	14122563.0
2009-10-23 16:00:00	QQQ	ETF	43.14	43.3738	43.13	43.15	8342952.0
2009-10-23 17:00:00	QQQ	ETF	43.16	43.16	43.1	43.12	37232.0
2009-10-23 18:00:00	QQQ	ETF	43.14	43.14	43.09	43.11	16808.0
2009-10-23 19:00:00	QQQ	ETF	43.1	43.16	43.1	43.16	7708.0
2009-10-23 06:00:00	IWM	ETF	61.36	61.36	61.35	61.35	1400.0
2009-10-23 07:00:00	IWM	ETF	61.36	61.53	61.36	61.53	9150.0
2009-10-23 08:00:00	IWM	ETF	61.49	61.76	61.44	61.69	178290.0
2009-10-23 09:00:00	IWM	ETF	61.7	61.72	61.21	61.4125	8465767.0
2009-10-23 10:00:00	IWM	ETF	61.42	61.68	60.42	60.53	12388067.0
2009-10-23 11:00:00	IWM	ETF	60.51	60.61	60.16	60.46	8967332.0
2009-10-23 12:00:00	IWM	ETF	60.46	60.61	60.31	60.46	3315538.0
2009-10-23 13:00:00	IWM	ETF	60.44	60.53	60.04	60.21	6720811.0
2009-10-23 14:00:00	IWM	ETF	60.2	60.44	60.05	60.225	8768940.0
2009-10-23 15:00:00	IWM	ETF	60.22	60.41	59.97	60.06	13304209.0
2009-10-23 16:00:00	IWM	ETF	60.06	61.3711	60.058	60.23	3934546.0
2009-10-23 17:00:00	IWM	ETF	60.24	60.26	60.17	60.17	10043.0
2009-10-23 18:00:00	IWM	ETF	60.17	60.25	60.17	60.25	2500.0
2009-10-23 19:00:00	IWM	ETF	60.25	60.25	60.25	60.25	1400.0
2009-10-23 07:00:00	DIA	ETF	101.74	101.74	100.98	100.98	6500.0
2009-10-23 08:00:00	DIA	ETF	100.94	101.15	100.94	101.14	47275.0
2009-10-23 09:00:00	DIA	ETF	101.13	101.21	100.6	100.76	1289300.0
2009-10-23 10:00:00	DIA	ETF	100.78	101.07	100.08	100.13	2445903.0
2009-10-23 11:00:00	DIA	ETF	100.13	100.32	99.75	100.07	1935597.0

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

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