PREVIEW / etf_1hour / 2008-02-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-07.parquet
  size:    99 KB
  rows:    3,249

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-07 04:00:00	SPY	ETF	133.03	133.2	132.95	133.08	2500.0
2008-02-07 05:00:00	SPY	ETF	133.07	133.13	132.9	132.9	16100.0
2008-02-07 06:00:00	SPY	ETF	132.77	132.77	132.49	132.76	64400.0
2008-02-07 07:00:00	SPY	ETF	132.75	132.9	131.47	131.82	3554800.0
2008-02-07 08:00:00	SPY	ETF	131.82	132.32	131.25	131.57	6620100.0
2008-02-07 09:00:00	SPY	ETF	131.58	132.84	131.54	131.96	34958722.0
2008-02-07 10:00:00	SPY	ETF	131.96	133.87	131.8	132.87	64496313.0
2008-02-07 11:00:00	SPY	ETF	132.86	133.12	132.21	132.82	23909329.0
2008-02-07 12:00:00	SPY	ETF	132.82	133.76	132.64	133.69	23768888.0
2008-02-07 13:00:00	SPY	ETF	133.7	134.58	133.11	134.47	28853263.0
2008-02-07 14:00:00	SPY	ETF	134.51	134.79	133.0	133.12	46203724.0
2008-02-07 15:00:00	SPY	ETF	133.12	133.8	132.33	133.78	49497479.0
2008-02-07 16:00:00	SPY	ETF	133.82	134.3	132.71	133.93	9360800.0
2008-02-07 17:00:00	SPY	ETF	133.93	134.17	133.93	134.06	328700.0
2008-02-07 18:00:00	SPY	ETF	134.1	134.25	133.71	133.73	140500.0
2008-02-07 19:00:00	SPY	ETF	133.72	133.95	133.7	133.95	40500.0
2008-02-07 04:00:00	QQQ	ETF	42.49	42.52	42.49	42.52	1200.0
2008-02-07 06:00:00	QQQ	ETF	42.36	42.36	42.34	42.34	3500.0
2008-02-07 07:00:00	QQQ	ETF	42.37	42.4	42.11	42.14	857014.0
2008-02-07 08:00:00	QQQ	ETF	42.14	42.3	42.02	42.13	2799777.0
2008-02-07 09:00:00	QQQ	ETF	42.13	42.85	42.13	42.23	36809626.0
2008-02-07 10:00:00	QQQ	ETF	42.2295	43.07	42.2295	42.71	78359948.0
2008-02-07 11:00:00	QQQ	ETF	42.71	42.8	42.52	42.775	18060352.0
2008-02-07 12:00:00	QQQ	ETF	42.77	43.16	42.73	43.12	20962040.0
2008-02-07 13:00:00	QQQ	ETF	43.12	43.67	42.96	43.62	28229046.0
2008-02-07 14:00:00	QQQ	ETF	43.63	43.79	42.88	42.892	46406364.0
2008-02-07 15:00:00	QQQ	ETF	42.89	43.15	42.5	43.11	47107113.0
2008-02-07 16:00:00	QQQ	ETF	43.11	43.4	42.8879	43.3	7290568.0
2008-02-07 17:00:00	QQQ	ETF	43.3	43.39	43.25	43.37	70571.0
2008-02-07 18:00:00	QQQ	ETF	43.37	43.4	43.26	43.26	73237.0
2008-02-07 19:00:00	QQQ	ETF	43.27	43.34	43.24	43.34	41845.0
2008-02-07 07:00:00	IWM	ETF	68.7	68.74	68.29	68.42	195400.0
2008-02-07 08:00:00	IWM	ETF	68.42	68.98	68.27	68.45	3353400.0
2008-02-07 09:00:00	IWM	ETF	68.44	69.4	68.44	68.78	13863980.0
2008-02-07 10:00:00	IWM	ETF	68.76	70.1	68.74	69.05	28829102.0
2008-02-07 11:00:00	IWM	ETF	69.05	69.17	68.7	69.13	8467179.0
2008-02-07 12:00:00	IWM	ETF	69.13	69.69	69.05	69.67	9390113.0
2008-02-07 13:00:00	IWM	ETF	69.67	70.24	69.27	70.19	11693200.0
2008-02-07 14:00:00	IWM	ETF	70.19	70.52	68.75	69.61	21579747.0
2008-02-07 15:00:00	IWM	ETF	69.61	70.07	69.13	70.03	21201302.0
2008-02-07 16:00:00	IWM	ETF	70.02	70.35	68.98	68.98	7715300.0
2008-02-07 17:00:00	IWM	ETF	70.21	70.21	70.17	70.17	800.0
2008-02-07 18:00:00	IWM	ETF	70.26	70.29	70.26	70.29	400.0
2008-02-07 19:00:00	IWM	ETF	70.27	70.28	70.26	70.28	20000.0
2008-02-07 07:00:00	DIA	ETF	121.93	121.98	121.23	121.39	20400.0
2008-02-07 08:00:00	DIA	ETF	121.43	121.46	121.07	121.19	80900.0
2008-02-07 09:00:00	DIA	ETF	121.28	122.14	121.25	121.38	2574203.0
2008-02-07 10:00:00	DIA	ETF	121.39	122.73	121.34	122.01	4399857.0
2008-02-07 11:00:00	DIA	ETF	122.0	122.2	121.45	121.89	1289498.0
2008-02-07 12:00:00	DIA	ETF	121.89	122.59	121.75	122.5	1519534.0

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

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