PREVIEW / etf_1hour / 2008-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-20.parquet
  size:    110 KB
  rows:    3,504

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-06-20 04:00:00	SPY	ETF	133.44	133.52	133.43	133.43	5700.0
2008-06-20 05:00:00	SPY	ETF	133.55	133.71	133.55	133.64	174100.0
2008-06-20 06:00:00	SPY	ETF	133.65	133.65	133.12	133.13	726900.0
2008-06-20 07:00:00	SPY	ETF	133.08	133.18	132.75	132.87	2329096.0
2008-06-20 08:00:00	SPY	ETF	132.89	133.16	132.78	133.0	7728299.0
2008-06-20 09:00:00	SPY	ETF	132.96	133.26	132.49	132.66	44487682.0
2008-06-20 10:00:00	SPY	ETF	132.66	132.832	132.01	132.439	52712835.0
2008-06-20 11:00:00	SPY	ETF	132.43	132.98	132.33	132.64	30381216.0
2008-06-20 12:00:00	SPY	ETF	132.63	132.65	132.32	132.44	16076726.0
2008-06-20 13:00:00	SPY	ETF	132.44	132.74	131.75	131.86	34993394.0
2008-06-20 14:00:00	SPY	ETF	131.87	132.5	131.22	131.29	33272101.0
2008-06-20 15:00:00	SPY	ETF	131.29	132.0	131.23	131.59	48799741.0
2008-06-20 16:00:00	SPY	ETF	131.6299	134.0817	131.5	131.7	10278424.0
2008-06-20 17:00:00	SPY	ETF	131.68	134.0817	131.63	131.63	2839363.0
2008-06-20 18:00:00	SPY	ETF	131.75	131.8	131.69	131.75	10762.0
2008-06-20 19:00:00	SPY	ETF	131.73	131.79	131.7	131.79	13938.0
2008-06-20 04:00:00	QQQ	ETF	48.57	48.6	48.54	48.54	14500.0
2008-06-20 05:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	200.0
2008-06-20 06:00:00	QQQ	ETF	48.5	48.5	48.5	48.5	200.0
2008-06-20 07:00:00	QQQ	ETF	48.45	48.47	48.32	48.42	121400.0
2008-06-20 08:00:00	QQQ	ETF	48.43	48.45	48.34	48.36	1978646.0
2008-06-20 09:00:00	QQQ	ETF	48.36	48.45	47.93	47.98	26607831.0
2008-06-20 10:00:00	QQQ	ETF	47.97	48.0	47.49	47.68	36676830.0
2008-06-20 11:00:00	QQQ	ETF	47.68	47.82	47.56	47.74	20424028.0
2008-06-20 12:00:00	QQQ	ETF	47.74	47.7699	47.57	47.61	12851664.0
2008-06-20 13:00:00	QQQ	ETF	47.6	47.74	47.39	47.51	20463856.0
2008-06-20 14:00:00	QQQ	ETF	47.5	47.53	47.28	47.3	18680118.0
2008-06-20 15:00:00	QQQ	ETF	47.31	47.54	47.21	47.42	33212536.0
2008-06-20 16:00:00	QQQ	ETF	47.42	48.7604	47.3225	47.54	10622912.0
2008-06-20 17:00:00	QQQ	ETF	47.55	47.57	47.49	47.5	171046.0
2008-06-20 18:00:00	QQQ	ETF	47.52	47.52	47.45	47.49	43405.0
2008-06-20 19:00:00	QQQ	ETF	47.49	47.55	47.47	47.55	7634.0
2008-06-20 07:00:00	IWM	ETF	73.43	73.43	73.2	73.27	572057.0
2008-06-20 08:00:00	IWM	ETF	73.29	73.43	73.25	73.42	885823.0
2008-06-20 09:00:00	IWM	ETF	73.37	73.54	73.1	73.24	12504991.0
2008-06-20 10:00:00	IWM	ETF	73.24	73.27	72.17	72.48	23237392.0
2008-06-20 11:00:00	IWM	ETF	72.48	73.05	72.45	72.81	10400619.0
2008-06-20 12:00:00	IWM	ETF	72.81	72.82	72.43	72.7	7931778.0
2008-06-20 13:00:00	IWM	ETF	72.69	72.82	71.85	72.17	17259846.0
2008-06-20 14:00:00	IWM	ETF	72.16	72.24	71.93	71.97	13416914.0
2008-06-20 15:00:00	IWM	ETF	71.97	72.61	71.97	72.58	18719994.0
2008-06-20 16:00:00	IWM	ETF	72.58	73.75	72.04	72.62	12770829.0
2008-06-20 17:00:00	IWM	ETF	72.62	72.62	72.59	72.59	2700.0
2008-06-20 18:00:00	IWM	ETF	72.62	72.63	72.62	72.63	4200.0
2008-06-20 19:00:00	IWM	ETF	72.63	72.63	72.63	72.63	200.0
2008-06-20 06:00:00	DIA	ETF	119.85	119.85	119.79	119.79	1500.0
2008-06-20 07:00:00	DIA	ETF	119.83	119.83	119.49	119.6	43750.0
2008-06-20 08:00:00	DIA	ETF	119.58	119.77	119.54	119.65	103699.0
2008-06-20 09:00:00	DIA	ETF	119.61	119.9	119.02	119.17	3443045.0
2008-06-20 10:00:00	DIA	ETF	119.16	119.19	118.66	119.07	4430637.0

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

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