PREVIEW / etf_1hour / 2008-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-30.parquet
  size:    107 KB
  rows:    3,436

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-04-30 04:00:00	SPY	ETF	139.11	139.11	139.11	139.11	800.0
2008-04-30 06:00:00	SPY	ETF	138.8	138.8	138.53	138.8	162400.0
2008-04-30 07:00:00	SPY	ETF	138.8	139.03	138.71	138.77	517976.0
2008-04-30 08:00:00	SPY	ETF	138.76	139.65	138.75	139.45	7072861.0
2008-04-30 09:00:00	SPY	ETF	139.48	139.69	139.24	139.43	10292461.0
2008-04-30 10:00:00	SPY	ETF	139.43	139.66	139.27	139.53	13356643.0
2008-04-30 11:00:00	SPY	ETF	139.52	139.93	139.52	139.81	15473663.0
2008-04-30 12:00:00	SPY	ETF	139.8	139.86	139.43	139.53	12747407.0
2008-04-30 13:00:00	SPY	ETF	139.53	139.81	139.5	139.59	13753349.0
2008-04-30 14:00:00	SPY	ETF	139.59	140.59	139.17	139.1799	64809894.0
2008-04-30 15:00:00	SPY	ETF	139.17	139.28	138.35	138.43	56907453.0
2008-04-30 16:00:00	SPY	ETF	138.4799	139.57	138.22	138.35	10082369.0
2008-04-30 17:00:00	SPY	ETF	138.36	138.5	138.36	138.44	196248.0
2008-04-30 18:00:00	SPY	ETF	138.45	138.56	138.45	138.5	39103.0
2008-04-30 19:00:00	SPY	ETF	138.48	138.57	138.48	138.55	19060.0
2008-04-30 04:00:00	QQQ	ETF	47.59	47.59	47.59	47.59	5000.0
2008-04-30 06:00:00	QQQ	ETF	47.55	47.55	47.43	47.5	16391.0
2008-04-30 07:00:00	QQQ	ETF	47.48	47.58	47.45	47.47	519552.0
2008-04-30 08:00:00	QQQ	ETF	47.47	47.8	47.46	47.71	2444864.0
2008-04-30 09:00:00	QQQ	ETF	47.71	47.79	47.6	47.719	8057768.0
2008-04-30 10:00:00	QQQ	ETF	47.7	47.87	47.65	47.82	10245769.0
2008-04-30 11:00:00	QQQ	ETF	47.82	47.96	47.79	47.87	11580427.0
2008-04-30 12:00:00	QQQ	ETF	47.87	47.89	47.73	47.81	6738090.0
2008-04-30 13:00:00	QQQ	ETF	47.8	47.88	47.7	47.74	5745024.0
2008-04-30 14:00:00	QQQ	ETF	47.74	48.06	47.35	47.36	38025558.0
2008-04-30 15:00:00	QQQ	ETF	47.36	47.3789	47.03	47.21	41619113.0
2008-04-30 16:00:00	QQQ	ETF	47.22	47.55	47.0726	47.19	4808774.0
2008-04-30 17:00:00	QQQ	ETF	47.2	47.24	47.19	47.22	429696.0
2008-04-30 18:00:00	QQQ	ETF	47.23	47.24	47.22	47.23	35418.0
2008-04-30 19:00:00	QQQ	ETF	47.24	47.24	47.22	47.24	65843.0
2008-04-30 06:00:00	IWM	ETF	71.67	71.67	71.67	71.67	5000.0
2008-04-30 07:00:00	IWM	ETF	71.71	71.71	71.7	71.71	600.0
2008-04-30 08:00:00	IWM	ETF	71.71	72.15	71.71	72.03	656481.0
2008-04-30 09:00:00	IWM	ETF	72.05	72.21	71.88	72.03	4343582.0
2008-04-30 10:00:00	IWM	ETF	72.02	72.33	71.92	72.27	6386542.0
2008-04-30 11:00:00	IWM	ETF	72.27	72.46	72.19	72.3	4644861.0
2008-04-30 12:00:00	IWM	ETF	72.3	72.34	72.08	72.18	2702710.0
2008-04-30 13:00:00	IWM	ETF	72.18	72.34	72.13	72.17	3059816.0
2008-04-30 14:00:00	IWM	ETF	72.18	72.66	71.55	71.55	16248116.0
2008-04-30 15:00:00	IWM	ETF	71.54	71.57	71.1	71.42	20587448.0
2008-04-30 16:00:00	IWM	ETF	71.41	71.85	71.33	71.4	3134948.0
2008-04-30 17:00:00	IWM	ETF	71.45	71.47	71.44	71.46	2709.0
2008-04-30 18:00:00	IWM	ETF	71.43	71.5	71.43	71.5	2194.0
2008-04-30 19:00:00	IWM	ETF	71.5	71.5	71.5	71.5	100.0
2008-04-30 07:00:00	DIA	ETF	128.18	128.19	128.18	128.19	400.0
2008-04-30 08:00:00	DIA	ETF	128.12	128.96	128.12	128.66	42172.0
2008-04-30 09:00:00	DIA	ETF	128.66	128.87	128.44	128.71	1380305.0
2008-04-30 10:00:00	DIA	ETF	128.68	129.11	128.57	129.06	1505425.0
2008-04-30 11:00:00	DIA	ETF	129.07	129.48	129.07	129.39	1818551.0
2008-04-30 12:00:00	DIA	ETF	129.39	129.44	129.15	129.24	921673.0

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

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