PREVIEW / etf_1hour / 2009-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-01.parquet
  size:    149 KB
  rows:    4,549

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-01 04:00:00	SPY	ETF	105.59	105.59	105.23	105.41	26250.0
2009-10-01 05:00:00	SPY	ETF	105.37	105.51	105.21	105.21	9300.0
2009-10-01 06:00:00	SPY	ETF	105.27	105.31	105.07	105.16	32556.0
2009-10-01 07:00:00	SPY	ETF	105.16	105.3	105.1	105.18	313256.0
2009-10-01 08:00:00	SPY	ETF	105.2	105.49	104.98	105.42	5296403.0
2009-10-01 09:00:00	SPY	ETF	105.43	105.56	104.72	104.98	35466728.0
2009-10-01 10:00:00	SPY	ETF	104.92	105.28	103.81	104.33	54625246.0
2009-10-01 11:00:00	SPY	ETF	104.34	104.35	103.63	103.82	34328640.0
2009-10-01 12:00:00	SPY	ETF	103.83	104.04	103.65	103.85	14447557.0
2009-10-01 13:00:00	SPY	ETF	103.85	103.87	103.36	103.665	28407242.0
2009-10-01 14:00:00	SPY	ETF	103.66	103.95	103.5	103.67	20654589.0
2009-10-01 15:00:00	SPY	ETF	103.67	103.76	102.95	102.99	50826406.0
2009-10-01 16:00:00	SPY	ETF	102.99	105.7331	102.95	103.2	20192800.0
2009-10-01 17:00:00	SPY	ETF	103.72	105.7331	103.1	103.11	9806323.0
2009-10-01 18:00:00	SPY	ETF	103.12	105.7329	103.02	103.08	1144975.0
2009-10-01 19:00:00	SPY	ETF	103.11	105.56	103.0	103.0	57259.0
2009-10-01 05:00:00	QQQ	ETF	42.05	42.05	42.05	42.05	4000.0
2009-10-01 06:00:00	QQQ	ETF	42.06	42.07	42.04	42.05	17489.0
2009-10-01 07:00:00	QQQ	ETF	42.05	42.1	42.02	42.03	124229.0
2009-10-01 08:00:00	QQQ	ETF	42.07	42.17	41.97	42.14	1071192.0
2009-10-01 09:00:00	QQQ	ETF	42.14	42.16	41.87	41.96	14717731.0
2009-10-01 10:00:00	QQQ	ETF	41.96	42.05	41.5	41.58	33604887.0
2009-10-01 11:00:00	QQQ	ETF	41.57	41.58	41.17	41.28	19295378.0
2009-10-01 12:00:00	QQQ	ETF	41.27	41.39	41.21	41.29	7271326.0
2009-10-01 13:00:00	QQQ	ETF	41.29	41.305	41.11	41.248	11777738.0
2009-10-01 14:00:00	QQQ	ETF	41.25	41.39	41.2	41.27	8579729.0
2009-10-01 15:00:00	QQQ	ETF	41.28	41.33	41.0	41.0	30978501.0
2009-10-01 16:00:00	QQQ	ETF	41.01	41.591	40.98	41.12	8610968.0
2009-10-01 17:00:00	QQQ	ETF	41.12	41.14	41.07	41.09	71791.0
2009-10-01 18:00:00	QQQ	ETF	41.09	41.11	40.99	41.06	111306.0
2009-10-01 19:00:00	QQQ	ETF	41.07	41.08	41.04	41.05	22819.0
2009-10-01 06:00:00	IWM	ETF	60.14	60.14	60.14	60.14	400.0
2009-10-01 07:00:00	IWM	ETF	60.1	60.1	59.95	59.96	46345.0
2009-10-01 08:00:00	IWM	ETF	60.03	60.24	59.9	60.2	1111716.0
2009-10-01 09:00:00	IWM	ETF	60.2	60.25	59.65	59.83	7535983.0
2009-10-01 10:00:00	IWM	ETF	59.79	59.92	59.15	59.5	16042899.0
2009-10-01 11:00:00	IWM	ETF	59.495	59.5	58.87	59.02	7454496.0
2009-10-01 12:00:00	IWM	ETF	59.02	59.17	58.84	58.98	3364137.0
2009-10-01 13:00:00	IWM	ETF	58.98	59.02	58.6	58.79	5763880.0
2009-10-01 14:00:00	IWM	ETF	58.79	58.98	58.71	58.79	4105715.0
2009-10-01 15:00:00	IWM	ETF	58.8	58.805	58.36	58.38	11216688.0
2009-10-01 16:00:00	IWM	ETF	58.38	60.4301	58.34	58.56	4785749.0
2009-10-01 17:00:00	IWM	ETF	58.59	58.6	58.51	58.54	5590.0
2009-10-01 18:00:00	IWM	ETF	58.49	58.49	58.37	58.39	3431.0
2009-10-01 19:00:00	IWM	ETF	58.46	58.46	58.4	58.4	1000.0
2009-10-01 06:00:00	DIA	ETF	96.83	96.84	96.73	96.74	700.0
2009-10-01 07:00:00	DIA	ETF	96.71	96.81	96.71	96.72	25000.0
2009-10-01 08:00:00	DIA	ETF	96.8	97.0	96.61	96.98	89701.0
2009-10-01 09:00:00	DIA	ETF	96.9	96.95	96.34	96.45	1908316.0
2009-10-01 10:00:00	DIA	ETF	96.52	96.67	95.77	96.04	4501938.0

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

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