PREVIEW / etf_1hour / 2008-02-20

all etf 1-hour files

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

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-20 04:00:00	SPY	ETF	134.81	135.06	134.81	135.06	300.0
2008-02-20 05:00:00	SPY	ETF	134.99	134.99	134.8	134.81	6600.0
2008-02-20 06:00:00	SPY	ETF	134.73	134.83	134.6	134.67	57200.0
2008-02-20 07:00:00	SPY	ETF	134.6	134.65	134.12	134.42	1332300.0
2008-02-20 08:00:00	SPY	ETF	134.42	135.4	133.5	133.81	8289200.0
2008-02-20 09:00:00	SPY	ETF	133.82	134.47	133.61	134.14	24797813.0
2008-02-20 10:00:00	SPY	ETF	134.14	134.62	133.76	134.19	30079652.0
2008-02-20 11:00:00	SPY	ETF	134.19	134.56	134.0	134.33	10417113.0
2008-02-20 12:00:00	SPY	ETF	134.34	135.98	134.22	135.2	39174286.0
2008-02-20 13:00:00	SPY	ETF	135.2	135.9	135.04	135.46	22327034.0
2008-02-20 14:00:00	SPY	ETF	135.45	137.6	135.0	136.34	44821633.0
2008-02-20 15:00:00	SPY	ETF	136.34	136.43	135.65	136.11	35589657.0
2008-02-20 16:00:00	SPY	ETF	136.09	136.14	135.86	135.96	1898900.0
2008-02-20 17:00:00	SPY	ETF	135.96	136.08	135.91	136.06	208200.0
2008-02-20 18:00:00	SPY	ETF	136.05	136.2	136.05	136.17	68200.0
2008-02-20 19:00:00	SPY	ETF	136.19	136.4	136.11	136.24	32700.0
2008-02-20 04:00:00	QQQ	ETF	43.45	43.45	43.45	43.45	100.0
2008-02-20 05:00:00	QQQ	ETF	43.58	43.58	43.58	43.58	800.0
2008-02-20 06:00:00	QQQ	ETF	43.51	43.52	43.48	43.5	20900.0
2008-02-20 07:00:00	QQQ	ETF	43.48	43.48	43.31	43.37	562368.0
2008-02-20 08:00:00	QQQ	ETF	43.38	43.48	43.05	43.1	3166407.0
2008-02-20 09:00:00	QQQ	ETF	43.1	43.51	43.09	43.37	14086461.0
2008-02-20 10:00:00	QQQ	ETF	43.38	43.6	43.24	43.36	24503532.0
2008-02-20 11:00:00	QQQ	ETF	43.36	43.42	43.26	43.3385	6102032.0
2008-02-20 12:00:00	QQQ	ETF	43.34	43.87	43.32	43.645	22458066.0
2008-02-20 13:00:00	QQQ	ETF	43.6495	43.91	43.56	43.78	15338262.0
2008-02-20 14:00:00	QQQ	ETF	43.78	44.09	43.56	44.04	25432913.0
2008-02-20 15:00:00	QQQ	ETF	44.05	44.06	43.7899	43.97	21916003.0
2008-02-20 16:00:00	QQQ	ETF	43.95	44.05	43.89	43.93	3636315.0
2008-02-20 17:00:00	QQQ	ETF	43.93	44.0	43.93	43.99	46181.0
2008-02-20 18:00:00	QQQ	ETF	44.0	44.03	43.96	44.02	38339.0
2008-02-20 19:00:00	QQQ	ETF	44.03	44.04	43.94	44.04	30194.0
2008-02-20 05:00:00	IWM	ETF	70.03	70.03	69.97	69.97	12500.0
2008-02-20 06:00:00	IWM	ETF	69.97	69.97	69.92	69.95	5800.0
2008-02-20 07:00:00	IWM	ETF	69.91	69.91	69.69	69.75	64100.0
2008-02-20 08:00:00	IWM	ETF	69.85	69.85	69.45	69.59	495800.0
2008-02-20 09:00:00	IWM	ETF	69.59	69.77	69.29	69.57	7572923.0
2008-02-20 10:00:00	IWM	ETF	69.57	69.76	69.17	69.61	8722915.0
2008-02-20 11:00:00	IWM	ETF	69.61	69.93	69.56	69.74	4544081.0
2008-02-20 12:00:00	IWM	ETF	69.74	70.58	69.7	70.27	12241826.0
2008-02-20 13:00:00	IWM	ETF	70.28	70.66	70.08	70.38	9468434.0
2008-02-20 14:00:00	IWM	ETF	70.38	70.91	70.1	70.81	15929159.0
2008-02-20 15:00:00	IWM	ETF	70.81	70.84	70.23	70.75	9789131.0
2008-02-20 16:00:00	IWM	ETF	70.75	70.94	70.19	70.82	2324600.0
2008-02-20 17:00:00	IWM	ETF	70.85	70.88	70.8	70.88	13400.0
2008-02-20 18:00:00	IWM	ETF	70.86	70.99	70.86	70.95	18900.0
2008-02-20 19:00:00	IWM	ETF	71.01	71.05	71.01	71.05	200.0
2008-02-20 07:00:00	DIA	ETF	122.75	122.99	122.75	122.9	3900.0
2008-02-20 08:00:00	DIA	ETF	123.07	123.07	122.3	122.48	212700.0
2008-02-20 09:00:00	DIA	ETF	122.46	122.85	122.35	122.61	1719536.0

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

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