PREVIEW / etf_1hour / 2009-11-23

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-23.parquet
  size:    149 KB
  rows:    4,637

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-11-23 04:00:00	SPY	ETF	110.47	110.57	110.44	110.44	14950.0
2009-11-23 05:00:00	SPY	ETF	110.51	110.67	110.51	110.67	8150.0
2009-11-23 06:00:00	SPY	ETF	110.6	110.69	110.57	110.61	59350.0
2009-11-23 07:00:00	SPY	ETF	110.62	110.71	110.52	110.56	509178.0
2009-11-23 08:00:00	SPY	ETF	110.57	110.75	110.37	110.59	2014577.0
2009-11-23 09:00:00	SPY	ETF	110.6	111.74	109.4	111.53	26585401.0
2009-11-23 10:00:00	SPY	ETF	111.535	111.63	111.22	111.3	31970207.0
2009-11-23 11:00:00	SPY	ETF	111.3	111.38	111.05	111.07	13337957.0
2009-11-23 12:00:00	SPY	ETF	111.07	111.17	110.85	111.0	12442415.0
2009-11-23 13:00:00	SPY	ETF	111.01	111.07	110.81	110.89	14184877.0
2009-11-23 14:00:00	SPY	ETF	110.88	110.94	110.7	110.83	10715610.0
2009-11-23 15:00:00	SPY	ETF	110.84	111.02	110.6	110.91	25994663.0
2009-11-23 16:00:00	SPY	ETF	110.91	111.45	110.74	110.79	7674164.0
2009-11-23 17:00:00	SPY	ETF	110.78	110.8	110.7	110.72	186609.0
2009-11-23 18:00:00	SPY	ETF	110.74	110.84	110.74	110.78	84990.0
2009-11-23 19:00:00	SPY	ETF	110.75	110.78	110.69	110.7	21485.0
2009-11-23 04:00:00	QQQ	ETF	43.81	43.86	43.66	43.86	3337.0
2009-11-23 05:00:00	QQQ	ETF	43.84	43.84	43.84	43.84	8000.0
2009-11-23 06:00:00	QQQ	ETF	43.85	43.9	43.85	43.9	105050.0
2009-11-23 07:00:00	QQQ	ETF	43.86	43.89	43.82	43.82	338237.0
2009-11-23 08:00:00	QQQ	ETF	43.81	43.84	43.76	43.83	1140774.0
2009-11-23 09:00:00	QQQ	ETF	43.84	44.4	43.83	44.33	16242071.0
2009-11-23 10:00:00	QQQ	ETF	44.3	44.37	44.19	44.205	19863929.0
2009-11-23 11:00:00	QQQ	ETF	44.2	44.245	44.08	44.09	5818438.0
2009-11-23 12:00:00	QQQ	ETF	44.0907	44.14	44.01	44.11	7832524.0
2009-11-23 13:00:00	QQQ	ETF	44.11	44.14	44.03	44.07	7411519.0
2009-11-23 14:00:00	QQQ	ETF	44.07	44.09	43.99	44.05	6461497.0
2009-11-23 15:00:00	QQQ	ETF	44.05	44.15	43.97	44.14	12951605.0
2009-11-23 16:00:00	QQQ	ETF	44.14	44.1562	44.07	44.08	2916118.0
2009-11-23 17:00:00	QQQ	ETF	44.08	44.09	44.06	44.09	25680.0
2009-11-23 18:00:00	QQQ	ETF	44.08	44.1	44.08	44.09	11045.0
2009-11-23 19:00:00	QQQ	ETF	44.08	44.09	44.04	44.04	34385.0
2009-11-23 04:00:00	IWM	ETF	58.75	59.0	58.75	59.0	400.0
2009-11-23 07:00:00	IWM	ETF	59.35	59.38	59.26	59.31	92414.0
2009-11-23 08:00:00	IWM	ETF	59.29	59.45	59.21	59.36	256790.0
2009-11-23 09:00:00	IWM	ETF	59.36	60.28	59.36	60.22	14050254.0
2009-11-23 10:00:00	IWM	ETF	60.24	60.32	59.91	59.95	12126851.0
2009-11-23 11:00:00	IWM	ETF	59.95	60.0	59.74	59.75	4628663.0
2009-11-23 12:00:00	IWM	ETF	59.76	59.84	59.57	59.75	4603178.0
2009-11-23 13:00:00	IWM	ETF	59.75	59.85	59.63	59.685	3681653.0
2009-11-23 14:00:00	IWM	ETF	59.67	59.68	59.4	59.59	3774675.0
2009-11-23 15:00:00	IWM	ETF	59.59	59.69	59.29	59.65	9387244.0
2009-11-23 16:00:00	IWM	ETF	59.65	59.68	58.5699	59.55	3159219.0
2009-11-23 17:00:00	IWM	ETF	59.54	59.55	59.47	59.47	10904.0
2009-11-23 18:00:00	IWM	ETF	59.56	59.58	59.56	59.58	400.0
2009-11-23 19:00:00	IWM	ETF	59.54	59.55	59.5	59.5	700.0
2009-11-23 07:00:00	DIA	ETF	104.2	104.24	104.2	104.24	400.0
2009-11-23 08:00:00	DIA	ETF	104.03	104.27	104.03	104.07	23979.0
2009-11-23 09:00:00	DIA	ETF	104.09	104.97	104.09	104.88	2069868.0
2009-11-23 10:00:00	DIA	ETF	104.9	104.98	104.67	104.73	2905621.0

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

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