PREVIEW / etf_1hour / 2009-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-15.parquet
  size:    146 KB
  rows:    4,557

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-12-15 04:00:00	SPY	ETF	111.61	111.61	111.5	111.5	2545.0
2009-12-15 05:00:00	SPY	ETF	111.5	111.53	111.5	111.52	13800.0
2009-12-15 06:00:00	SPY	ETF	111.57	111.57	111.47	111.51	27700.0
2009-12-15 07:00:00	SPY	ETF	111.56	111.6	111.42	111.54	258960.0
2009-12-15 08:00:00	SPY	ETF	111.54	111.87	111.19	111.36	3993686.0
2009-12-15 09:00:00	SPY	ETF	111.36	111.56	111.3	111.37	17843798.0
2009-12-15 10:00:00	SPY	ETF	111.37	111.92	111.34	111.82	21652549.0
2009-12-15 11:00:00	SPY	ETF	111.82	111.9024	111.64	111.69	10587055.0
2009-12-15 12:00:00	SPY	ETF	111.69	111.77	111.51	111.56	7693543.0
2009-12-15 13:00:00	SPY	ETF	111.56	111.63	111.39	111.5191	10947856.0
2009-12-15 14:00:00	SPY	ETF	111.51	111.58	111.44	111.46	7587881.0
2009-12-15 15:00:00	SPY	ETF	111.46	111.9024	111.0	111.31	29022606.0
2009-12-15 16:00:00	SPY	ETF	111.32	111.9024	111.12	111.41	8711109.0
2009-12-15 17:00:00	SPY	ETF	111.43	111.44	111.3	111.4	113495.0
2009-12-15 18:00:00	SPY	ETF	111.4	111.41	111.35	111.38	24196.0
2009-12-15 19:00:00	SPY	ETF	111.42	111.42	111.3	111.32	34737.0
2009-12-15 04:00:00	QQQ	ETF	44.51	44.51	44.51	44.51	1000.0
2009-12-15 05:00:00	QQQ	ETF	44.48	44.48	44.48	44.48	10000.0
2009-12-15 06:00:00	QQQ	ETF	44.46	44.46	44.46	44.46	200.0
2009-12-15 07:00:00	QQQ	ETF	44.46	44.46	44.4	44.45	56331.0
2009-12-15 08:00:00	QQQ	ETF	44.44	44.47	44.3	44.37	1319360.0
2009-12-15 09:00:00	QQQ	ETF	44.38	44.44	44.27	44.3	8827465.0
2009-12-15 10:00:00	QQQ	ETF	44.29	44.67	44.27	44.65	12362175.0
2009-12-15 11:00:00	QQQ	ETF	44.64	44.66	44.51	44.53	5134134.0
2009-12-15 12:00:00	QQQ	ETF	44.53	44.576	44.49	44.53	2022986.0
2009-12-15 13:00:00	QQQ	ETF	44.54	44.575	44.41	44.46	5304630.0
2009-12-15 14:00:00	QQQ	ETF	44.47	44.49	44.4	44.4299	4403501.0
2009-12-15 15:00:00	QQQ	ETF	44.42	44.44	44.17	44.3	15914444.0
2009-12-15 16:00:00	QQQ	ETF	44.3	44.37	44.24	44.3	3930291.0
2009-12-15 17:00:00	QQQ	ETF	44.31	44.31	44.28	44.3	39490.0
2009-12-15 18:00:00	QQQ	ETF	44.3	44.3	44.29	44.29	8570.0
2009-12-15 19:00:00	QQQ	ETF	44.29	44.3	44.27	44.28	16579.0
2009-12-15 06:00:00	IWM	ETF	60.85	60.94	60.85	60.94	2700.0
2009-12-15 07:00:00	IWM	ETF	60.95	61.06	60.9	61.02	193046.0
2009-12-15 08:00:00	IWM	ETF	60.95	61.06	60.78	60.88	1565054.0
2009-12-15 09:00:00	IWM	ETF	60.88	61.07	60.78	60.83	6476377.0
2009-12-15 10:00:00	IWM	ETF	60.83	61.52	60.82	61.43	9290955.0
2009-12-15 11:00:00	IWM	ETF	61.4201	61.44	61.302	61.38	3819697.0
2009-12-15 12:00:00	IWM	ETF	61.38	61.44	61.23	61.32	3302571.0
2009-12-15 13:00:00	IWM	ETF	61.32	61.36	61.15	61.32	3295470.0
2009-12-15 14:00:00	IWM	ETF	61.31	61.4	61.23	61.25	4058693.0
2009-12-15 15:00:00	IWM	ETF	61.25	61.33	60.79	60.9	13344278.0
2009-12-15 16:00:00	IWM	ETF	60.91	61.5	60.7936	60.97	6524045.0
2009-12-15 17:00:00	IWM	ETF	60.94	60.98	60.93	60.98	5943.0
2009-12-15 18:00:00	IWM	ETF	60.97	60.97	60.91	60.93	461.0
2009-12-15 19:00:00	IWM	ETF	60.98	60.98	60.98	60.98	900.0
2009-12-15 07:00:00	DIA	ETF	104.96	104.96	104.84	104.84	800.0
2009-12-15 08:00:00	DIA	ETF	104.9	105.0	104.67	104.82	36350.0
2009-12-15 09:00:00	DIA	ETF	104.84	104.98	104.712	104.78	1080855.0
2009-12-15 10:00:00	DIA	ETF	104.78	105.15	104.76	105.06	925804.0

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

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