PREVIEW / etf_1hour / 2009-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-22.parquet
  size:    145 KB
  rows:    4,428

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-22 04:00:00	SPY	ETF	108.04	108.04	107.67	107.83	3800.0
2009-10-22 05:00:00	SPY	ETF	107.84	107.9	107.79	107.88	14300.0
2009-10-22 06:00:00	SPY	ETF	108.02	108.14	107.87	108.14	45537.0
2009-10-22 07:00:00	SPY	ETF	108.14	108.22	108.0	108.19	986365.0
2009-10-22 08:00:00	SPY	ETF	108.17	108.5	107.91	108.05	5744716.0
2009-10-22 09:00:00	SPY	ETF	108.06	108.515	107.69	107.86	29217932.0
2009-10-22 10:00:00	SPY	ETF	107.86	108.32	107.5	108.25	44639914.0
2009-10-22 11:00:00	SPY	ETF	108.2484	108.51	108.19	108.25	22186560.0
2009-10-22 12:00:00	SPY	ETF	108.26	108.62	108.0	108.52	15219046.0
2009-10-22 13:00:00	SPY	ETF	108.51	108.58	108.36	108.54	13857203.0
2009-10-22 14:00:00	SPY	ETF	108.54	109.31	108.54	109.24	44108828.0
2009-10-22 15:00:00	SPY	ETF	109.24	109.68	109.15	109.33	43906819.0
2009-10-22 16:00:00	SPY	ETF	109.32	109.61	108.24	109.54	14016410.0
2009-10-22 17:00:00	SPY	ETF	109.55	109.62	108.5	109.59	2567843.0
2009-10-22 18:00:00	SPY	ETF	109.58	109.74	109.58	109.74	115909.0
2009-10-22 19:00:00	SPY	ETF	109.72	109.82	109.72	109.8	139223.0
2009-10-22 04:00:00	QQQ	ETF	42.99	42.99	42.91	42.96	800.0
2009-10-22 05:00:00	QQQ	ETF	42.96	43.02	42.96	43.02	1400.0
2009-10-22 06:00:00	QQQ	ETF	43.03	43.03	42.98	43.01	5300.0
2009-10-22 07:00:00	QQQ	ETF	43.08	43.1	43.05	43.09	43700.0
2009-10-22 08:00:00	QQQ	ETF	43.1	43.22	42.92	43.04	1426575.0
2009-10-22 09:00:00	QQQ	ETF	43.03	43.22	42.88	42.93	14786938.0
2009-10-22 10:00:00	QQQ	ETF	42.93	43.04	42.79	43.02	15626084.0
2009-10-22 11:00:00	QQQ	ETF	43.01	43.08	42.93	42.94	6913302.0
2009-10-22 12:00:00	QQQ	ETF	42.95	43.14	42.93	43.0805	5444026.0
2009-10-22 13:00:00	QQQ	ETF	43.09	43.14	43.02	43.08	4810130.0
2009-10-22 14:00:00	QQQ	ETF	43.09	43.39	43.08	43.365	16904665.0
2009-10-22 15:00:00	QQQ	ETF	43.37	43.49	43.3	43.33	15497546.0
2009-10-22 16:00:00	QQQ	ETF	43.33	43.45	43.31	43.42	3963203.0
2009-10-22 17:00:00	QQQ	ETF	43.42	43.47	43.41	43.47	55775.0
2009-10-22 18:00:00	QQQ	ETF	43.45	43.49	43.37	43.49	59013.0
2009-10-22 19:00:00	QQQ	ETF	43.5	43.51	43.48	43.51	28934.0
2009-10-22 07:00:00	IWM	ETF	60.44	60.46	60.32	60.46	83220.0
2009-10-22 08:00:00	IWM	ETF	60.15	60.71	60.15	60.44	1267095.0
2009-10-22 09:00:00	IWM	ETF	60.44	60.69	59.91	60.06	9190212.0
2009-10-22 10:00:00	IWM	ETF	60.07	60.38	59.77	60.32	10568241.0
2009-10-22 11:00:00	IWM	ETF	60.33	60.53	60.29	60.39	3969863.0
2009-10-22 12:00:00	IWM	ETF	60.4	60.61	60.31	60.55	3690031.0
2009-10-22 13:00:00	IWM	ETF	60.55	60.69	60.4701	60.65	3197373.0
2009-10-22 14:00:00	IWM	ETF	60.65	61.26	60.55	61.21	8804102.0
2009-10-22 15:00:00	IWM	ETF	61.22	61.61	61.19	61.38	12537891.0
2009-10-22 16:00:00	IWM	ETF	61.37	61.55	60.102	61.55	4019462.0
2009-10-22 17:00:00	IWM	ETF	61.54	61.57	61.49	61.51	47941.0
2009-10-22 18:00:00	IWM	ETF	61.57	61.57	61.5	61.54	2600.0
2009-10-22 19:00:00	IWM	ETF	61.61	61.61	61.61	61.61	6700.0
2009-10-22 07:00:00	DIA	ETF	99.6	99.6	99.6	99.6	100.0
2009-10-22 08:00:00	DIA	ETF	99.6	99.9	99.57	99.58	252317.0
2009-10-22 09:00:00	DIA	ETF	99.59	99.97	99.3	99.53	1870743.0
2009-10-22 10:00:00	DIA	ETF	99.52	100.08	99.2	100.01	3016514.0
2009-10-22 11:00:00	DIA	ETF	100.02	100.21	99.93	100.0	1518056.0

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

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