PREVIEW / etf_1hour / 2010-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-04.parquet
  size:    152 KB
  rows:    4,790

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
2010-01-04 04:00:00	SPY	ETF	112.25	112.25	112.17	112.23	33074.0
2010-01-04 05:00:00	SPY	ETF	112.22	112.25	112.14	112.25	7000.0
2010-01-04 06:00:00	SPY	ETF	112.22	112.23	112.16	112.2	17990.0
2010-01-04 07:00:00	SPY	ETF	112.2	112.2	112.12	112.15	140108.0
2010-01-04 08:00:00	SPY	ETF	112.12	112.33	112.09	112.32	3815410.0
2010-01-04 09:00:00	SPY	ETF	112.33	112.94	111.44	112.83	23416500.0
2010-01-04 10:00:00	SPY	ETF	112.84	113.24	112.73	113.1	22366655.0
2010-01-04 11:00:00	SPY	ETF	113.1	113.39	113.1	113.275	12190084.0
2010-01-04 12:00:00	SPY	ETF	113.28	113.36	113.25	113.295	8758922.0
2010-01-04 13:00:00	SPY	ETF	113.33	113.38	113.17	113.19	7174390.0
2010-01-04 14:00:00	SPY	ETF	113.2	113.38	113.17	113.28	10016638.0
2010-01-04 15:00:00	SPY	ETF	113.28	113.36	113.18	113.32	19243820.0
2010-01-04 16:00:00	SPY	ETF	113.3	113.33	113.0643	113.29	10542567.0
2010-01-04 17:00:00	SPY	ETF	113.29	113.31	113.25	113.29	97793.0
2010-01-04 18:00:00	SPY	ETF	113.26	113.33	113.18	113.26	56122.0
2010-01-04 19:00:00	SPY	ETF	113.23	113.23	113.16	113.21	31050.0
2010-01-04 04:00:00	QQQ	ETF	46.19	46.24	46.19	46.23	1560.0
2010-01-04 05:00:00	QQQ	ETF	46.24	46.25	46.21	46.23	5650.0
2010-01-04 06:00:00	QQQ	ETF	46.21	46.24	46.2	46.24	31000.0
2010-01-04 07:00:00	QQQ	ETF	46.22	46.25	46.19	46.21	89886.0
2010-01-04 08:00:00	QQQ	ETF	46.19	46.33	45.92	46.32	2849290.0
2010-01-04 09:00:00	QQQ	ETF	46.33	46.44	46.27	46.35	15002998.0
2010-01-04 10:00:00	QQQ	ETF	46.36	46.48	46.28	46.4	12732958.0
2010-01-04 11:00:00	QQQ	ETF	46.39	46.47	46.39	46.425	6051262.0
2010-01-04 12:00:00	QQQ	ETF	46.43	46.46	46.41	46.43	2703070.0
2010-01-04 13:00:00	QQQ	ETF	46.43	46.485	46.33	46.34	3311660.0
2010-01-04 14:00:00	QQQ	ETF	46.34	46.43	46.33	46.378	2197575.0
2010-01-04 15:00:00	QQQ	ETF	46.3724	46.43	46.3214	46.389	7017414.0
2010-01-04 16:00:00	QQQ	ETF	46.4	46.44	45.7405	46.42	5131439.0
2010-01-04 17:00:00	QQQ	ETF	46.42	46.42	46.39	46.42	6380.0
2010-01-04 18:00:00	QQQ	ETF	46.43	46.43	46.41	46.43	33000.0
2010-01-04 19:00:00	QQQ	ETF	46.43	46.44	46.41	46.43	10834.0
2010-01-04 06:00:00	IWM	ETF	63.06	63.06	63.02	63.03	5600.0
2010-01-04 07:00:00	IWM	ETF	63.03	63.03	62.95	62.97	35500.0
2010-01-04 08:00:00	IWM	ETF	62.92	63.21	62.26	63.19	889991.0
2010-01-04 09:00:00	IWM	ETF	63.19	63.69	62.44	63.62	8749126.0
2010-01-04 10:00:00	IWM	ETF	63.63	64.04	63.48	63.9	11096145.0
2010-01-04 11:00:00	IWM	ETF	63.91	64.02	63.88	63.965	2995745.0
2010-01-04 12:00:00	IWM	ETF	63.97	63.98	63.83	63.9	2436596.0
2010-01-04 13:00:00	IWM	ETF	63.9	63.9	63.65	63.68	2328351.0
2010-01-04 14:00:00	IWM	ETF	63.68	63.84	63.65	63.68	3218419.0
2010-01-04 15:00:00	IWM	ETF	63.68	63.96	63.63	63.96	8214198.0
2010-01-04 16:00:00	IWM	ETF	63.96	63.99	63.7	63.91	1257576.0
2010-01-04 17:00:00	IWM	ETF	63.9	63.91	63.84	63.88	19074.0
2010-01-04 18:00:00	IWM	ETF	63.89	63.89	63.85	63.85	2000.0
2010-01-04 19:00:00	IWM	ETF	63.91	63.91	63.91	63.91	300.0
2010-01-04 08:00:00	DIA	ETF	104.05	104.78	104.05	104.78	53762.0
2010-01-04 09:00:00	DIA	ETF	104.83	105.365	104.76	105.33	1739020.0
2010-01-04 10:00:00	DIA	ETF	105.34	105.6	105.28	105.5278	2341423.0
2010-01-04 11:00:00	DIA	ETF	105.53	105.8	105.52	105.7	708349.0

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

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