PREVIEW / etf_1hour / 2008-01-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-24.parquet
  size:    103 KB
  rows:    3,431

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
2008-01-24 04:00:00	SPY	ETF	133.37	133.37	133.27	133.27	1200.0
2008-01-24 05:00:00	SPY	ETF	133.98	134.08	133.98	134.08	25000.0
2008-01-24 06:00:00	SPY	ETF	134.4	135.0	134.4	134.68	125200.0
2008-01-24 07:00:00	SPY	ETF	134.85	134.85	134.19	134.19	807200.0
2008-01-24 08:00:00	SPY	ETF	134.21	134.68	133.75	134.57	6789000.0
2008-01-24 09:00:00	SPY	ETF	134.57	135.04	133.91	134.58	36562125.0
2008-01-24 10:00:00	SPY	ETF	134.56	135.26	133.31	133.96	63870636.0
2008-01-24 11:00:00	SPY	ETF	133.96	134.97	133.61	134.51	25123326.0
2008-01-24 12:00:00	SPY	ETF	134.49	134.73	133.58	134.46	17712234.0
2008-01-24 13:00:00	SPY	ETF	134.46	134.91	133.74	134.57	21917570.0
2008-01-24 14:00:00	SPY	ETF	134.57	135.46	134.0	134.36	39992089.0
2008-01-24 15:00:00	SPY	ETF	134.38	135.11	134.17	135.0	32310655.0
2008-01-24 16:00:00	SPY	ETF	135.06	136.3	133.78	135.75	7579800.0
2008-01-24 17:00:00	SPY	ETF	135.75	135.96	135.62	135.73	1066300.0
2008-01-24 18:00:00	SPY	ETF	135.74	135.74	135.61	135.7	86800.0
2008-01-24 19:00:00	SPY	ETF	135.68	135.68	135.47	135.54	69000.0
2008-01-24 04:00:00	QQQ	ETF	44.15	44.15	44.15	44.15	600.0
2008-01-24 05:00:00	QQQ	ETF	44.37	44.37	44.37	44.37	1500.0
2008-01-24 06:00:00	QQQ	ETF	44.48	45.53	44.48	44.58	308900.0
2008-01-24 07:00:00	QQQ	ETF	44.6	44.63	44.46	44.46	795679.0
2008-01-24 08:00:00	QQQ	ETF	44.47	44.57	44.15	44.39	5970736.0
2008-01-24 09:00:00	QQQ	ETF	44.39	44.9	44.14	44.75	32620991.0
2008-01-24 10:00:00	QQQ	ETF	44.75	44.93	44.06	44.42	64688311.0
2008-01-24 11:00:00	QQQ	ETF	44.44	44.7	44.23	44.54	22972286.0
2008-01-24 12:00:00	QQQ	ETF	44.54	44.63	44.18	44.43	17247995.0
2008-01-24 13:00:00	QQQ	ETF	44.43	44.52	44.2	44.4	14777796.0
2008-01-24 14:00:00	QQQ	ETF	44.4001	44.82	44.35	44.54	29568008.0
2008-01-24 15:00:00	QQQ	ETF	44.54	44.92	44.44	44.92	35291525.0
2008-01-24 16:00:00	QQQ	ETF	44.91	45.59	43.9966	45.46	24589795.0
2008-01-24 17:00:00	QQQ	ETF	45.47	45.5	43.9966	45.43	2297418.0
2008-01-24 18:00:00	QQQ	ETF	45.42	45.43	45.35	45.38	79421.0
2008-01-24 19:00:00	QQQ	ETF	45.39	45.39	45.35	45.38	66090.0
2008-01-24 05:00:00	IWM	ETF	69.0	69.0	69.0	69.0	200.0
2008-01-24 06:00:00	IWM	ETF	69.52	69.52	69.5	69.52	15000.0
2008-01-24 07:00:00	IWM	ETF	69.5	69.5	69.22	69.26	189000.0
2008-01-24 08:00:00	IWM	ETF	69.21	69.63	68.91	69.52	967400.0
2008-01-24 09:00:00	IWM	ETF	69.52	70.23	69.32	69.87	18109619.0
2008-01-24 10:00:00	IWM	ETF	69.87	70.14	68.91	69.19	25691256.0
2008-01-24 11:00:00	IWM	ETF	69.2	69.4	68.83	69.12	14288654.0
2008-01-24 12:00:00	IWM	ETF	69.1	69.2	68.15	68.84	12419238.0
2008-01-24 13:00:00	IWM	ETF	68.84	69.24	68.43	69.0	11902169.0
2008-01-24 14:00:00	IWM	ETF	69.01	69.65	68.83	69.01	12670571.0
2008-01-24 15:00:00	IWM	ETF	69.02	69.28	68.8	69.03	14595313.0
2008-01-24 16:00:00	IWM	ETF	69.03	69.8	68.86	69.45	4296610.0
2008-01-24 17:00:00	IWM	ETF	69.47	69.61	68.97	68.97	200700.0
2008-01-24 18:00:00	IWM	ETF	69.53	69.53	69.42	69.43	31200.0
2008-01-24 19:00:00	IWM	ETF	69.36	69.44	69.36	69.44	1600.0
2008-01-24 07:00:00	DIA	ETF	123.13	123.13	122.78	122.83	19000.0
2008-01-24 08:00:00	DIA	ETF	122.81	123.15	122.45	123.0	384200.0
2008-01-24 09:00:00	DIA	ETF	123.0	123.41	122.5	123.15	2706169.0

> showing 50 of 3,431 rows — these rows as CSV

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