PREVIEW / etf_1hour / 2008-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-22.parquet
  size:    101 KB
  rows:    3,372

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-02-22 05:00:00	SPY	ETF	134.64	134.86	134.64	134.86	4100.0
2008-02-22 06:00:00	SPY	ETF	134.51	134.53	134.49	134.52	143900.0
2008-02-22 07:00:00	SPY	ETF	134.52	134.7	134.36	134.52	357300.0
2008-02-22 08:00:00	SPY	ETF	134.52	135.27	134.52	135.22	1677100.0
2008-02-22 09:00:00	SPY	ETF	135.23	135.24	134.3	134.47	16183305.0
2008-02-22 10:00:00	SPY	ETF	134.47	134.47	133.24	133.53	36983264.0
2008-02-22 11:00:00	SPY	ETF	133.54	134.02	133.4	133.69	18317290.0
2008-02-22 12:00:00	SPY	ETF	133.68	133.7	133.01	133.32	17091164.0
2008-02-22 13:00:00	SPY	ETF	133.32	133.68	133.06	133.35	17825410.0
2008-02-22 14:00:00	SPY	ETF	133.34	133.67	133.04	133.42	18592423.0
2008-02-22 15:00:00	SPY	ETF	133.43	135.65	132.86	135.64	65288256.0
2008-02-22 16:00:00	SPY	ETF	135.67	135.85	134.4613	135.41	5865948.0
2008-02-22 17:00:00	SPY	ETF	135.38	135.75	135.26	135.54	266100.0
2008-02-22 18:00:00	SPY	ETF	135.47	135.55	135.47	135.55	28000.0
2008-02-22 19:00:00	SPY	ETF	135.55	135.59	135.45	135.53	14400.0
2008-02-22 05:00:00	QQQ	ETF	43.73	43.73	43.68	43.68	2600.0
2008-02-22 06:00:00	QQQ	ETF	43.66	43.66	43.64	43.64	1100.0
2008-02-22 07:00:00	QQQ	ETF	43.56	43.63	43.54	43.57	270792.0
2008-02-22 08:00:00	QQQ	ETF	43.58	43.79	43.57	43.79	670004.0
2008-02-22 09:00:00	QQQ	ETF	43.79	43.79	43.48	43.569	11201491.0
2008-02-22 10:00:00	QQQ	ETF	43.57	43.58	43.11	43.13	23981779.0
2008-02-22 11:00:00	QQQ	ETF	43.13	43.25	43.05	43.13	15910739.0
2008-02-22 12:00:00	QQQ	ETF	43.1301	43.14	42.86	43.0	14877323.0
2008-02-22 13:00:00	QQQ	ETF	43.0	43.08	42.83	42.9199	13685208.0
2008-02-22 14:00:00	QQQ	ETF	42.91	43.07	42.81	42.9901	13559264.0
2008-02-22 15:00:00	QQQ	ETF	42.99	43.66	42.78	43.66	46261193.0
2008-02-22 16:00:00	QQQ	ETF	43.65	43.89	43.4556	43.78	16588050.0
2008-02-22 17:00:00	QQQ	ETF	43.77	43.79	43.61	43.68	342919.0
2008-02-22 18:00:00	QQQ	ETF	43.7	43.73	43.7	43.7	5950.0
2008-02-22 19:00:00	QQQ	ETF	43.71	43.8	43.7	43.8	6195.0
2008-02-22 05:00:00	IWM	ETF	69.54	69.54	69.54	69.54	5000.0
2008-02-22 06:00:00	IWM	ETF	69.36	69.36	69.32	69.32	3000.0
2008-02-22 07:00:00	IWM	ETF	69.36	69.37	69.24	69.24	15500.0
2008-02-22 08:00:00	IWM	ETF	69.25	69.65	69.25	69.65	208700.0
2008-02-22 09:00:00	IWM	ETF	69.61	69.63	68.83	68.92	4470856.0
2008-02-22 10:00:00	IWM	ETF	68.93	68.93	68.12	68.45	14242454.0
2008-02-22 11:00:00	IWM	ETF	68.44	68.87	68.36	68.59	8372469.0
2008-02-22 12:00:00	IWM	ETF	68.61	68.64	68.04	68.38	16211722.0
2008-02-22 13:00:00	IWM	ETF	68.39	68.55	68.13	68.35	5755166.0
2008-02-22 14:00:00	IWM	ETF	68.35	68.54	68.19	68.4	5995919.0
2008-02-22 15:00:00	IWM	ETF	68.4	69.45	68.15	69.43	24928484.0
2008-02-22 16:00:00	IWM	ETF	69.42	69.5	68.57	69.14	6002200.0
2008-02-22 17:00:00	IWM	ETF	69.14	69.5	68.8	69.15	17500.0
2008-02-22 18:00:00	IWM	ETF	69.15	69.15	69.1	69.1	1800.0
2008-02-22 19:00:00	IWM	ETF	69.1	69.25	69.1	69.24	1700.0
2008-02-22 07:00:00	DIA	ETF	123.03	123.05	122.84	122.88	12300.0
2008-02-22 08:00:00	DIA	ETF	123.1	123.5	123.1	123.5	8900.0
2008-02-22 09:00:00	DIA	ETF	123.44	123.49	122.75	122.87	1280435.0
2008-02-22 10:00:00	DIA	ETF	122.87	122.87	121.95	122.14	2782015.0
2008-02-22 11:00:00	DIA	ETF	122.12	122.44	122.02	122.17	1042997.0

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

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