PREVIEW / etf_1hour / 2008-06-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-25.parquet
  size:    109 KB
  rows:    3,465

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-25 04:00:00	SPY	ETF	131.84	131.84	131.84	131.84	200.0
2008-06-25 05:00:00	SPY	ETF	132.0	132.0	132.0	132.0	100.0
2008-06-25 06:00:00	SPY	ETF	131.92	132.02	131.9	131.94	104500.0
2008-06-25 07:00:00	SPY	ETF	131.91	132.08	131.82	131.88	1465461.0
2008-06-25 08:00:00	SPY	ETF	131.89	132.08	131.78	131.9	3651572.0
2008-06-25 09:00:00	SPY	ETF	131.91	132.35	131.62	132.17	23037493.0
2008-06-25 10:00:00	SPY	ETF	132.17	132.73	131.94	132.56	36523448.0
2008-06-25 11:00:00	SPY	ETF	132.56	132.675	132.36	132.49	18805226.0
2008-06-25 12:00:00	SPY	ETF	132.49	132.58	132.28	132.36	9654992.0
2008-06-25 13:00:00	SPY	ETF	132.36	132.57	132.28	132.32	13677707.0
2008-06-25 14:00:00	SPY	ETF	132.33	133.1	131.92	132.83	78418971.0
2008-06-25 15:00:00	SPY	ETF	132.83	133.4	131.74	132.0	80227642.0
2008-06-25 16:00:00	SPY	ETF	132.01	132.5	131.2391	131.61	15626971.0
2008-06-25 17:00:00	SPY	ETF	131.59	132.2466	131.16	131.29	2467594.0
2008-06-25 18:00:00	SPY	ETF	131.3	131.45	131.3	131.38	39033.0
2008-06-25 19:00:00	SPY	ETF	131.35	131.56	131.35	131.54	41633.0
2008-06-25 04:00:00	QQQ	ETF	47.04	47.04	47.04	47.04	200.0
2008-06-25 05:00:00	QQQ	ETF	47.06	47.06	47.06	47.06	1000.0
2008-06-25 06:00:00	QQQ	ETF	47.07	47.14	47.06	47.14	2300.0
2008-06-25 07:00:00	QQQ	ETF	47.11	47.24	47.07	47.15	1394510.0
2008-06-25 08:00:00	QQQ	ETF	47.15	47.23	47.09	47.17	6185608.0
2008-06-25 09:00:00	QQQ	ETF	47.17	47.35	46.94	47.25	18922271.0
2008-06-25 10:00:00	QQQ	ETF	47.25	47.66	47.1	47.58	20529767.0
2008-06-25 11:00:00	QQQ	ETF	47.59	47.65	47.46	47.58	11289298.0
2008-06-25 12:00:00	QQQ	ETF	47.57	47.65	47.5	47.58	6312473.0
2008-06-25 13:00:00	QQQ	ETF	47.57	47.63	47.45	47.47	6319682.0
2008-06-25 14:00:00	QQQ	ETF	47.47	47.8	47.36	47.72	43522696.0
2008-06-25 15:00:00	QQQ	ETF	47.73	48.0	47.33	47.56	40112343.0
2008-06-25 16:00:00	QQQ	ETF	47.56	47.68	47.14	47.19	15443407.0
2008-06-25 17:00:00	QQQ	ETF	47.22	47.22	46.97	47.03	1382047.0
2008-06-25 18:00:00	QQQ	ETF	47.02	47.07	47.02	47.06	164282.0
2008-06-25 19:00:00	QQQ	ETF	47.03	47.08	47.03	47.07	50225.0
2008-06-25 07:00:00	IWM	ETF	71.08	71.27	71.06	71.16	593210.0
2008-06-25 08:00:00	IWM	ETF	71.17	71.3	71.11	71.12	2160371.0
2008-06-25 09:00:00	IWM	ETF	71.13	71.47	70.86	71.13	9642055.0
2008-06-25 10:00:00	IWM	ETF	71.13	71.92	71.13	71.78	16803202.0
2008-06-25 11:00:00	IWM	ETF	71.79	71.87	71.44	71.56	8193575.0
2008-06-25 12:00:00	IWM	ETF	71.56	71.73	71.43	71.47	5406621.0
2008-06-25 13:00:00	IWM	ETF	71.47	71.65	71.43	71.56	3938711.0
2008-06-25 14:00:00	IWM	ETF	71.56	71.88	71.08	71.65	27303134.0
2008-06-25 15:00:00	IWM	ETF	71.65	72.1	70.98	71.63	30163050.0
2008-06-25 16:00:00	IWM	ETF	71.63	71.65	70.77	71.33	4309198.0
2008-06-25 17:00:00	IWM	ETF	71.29	71.29	71.08	71.1	42125.0
2008-06-25 18:00:00	IWM	ETF	71.14	71.2	71.13	71.2	5130.0
2008-06-25 19:00:00	IWM	ETF	71.2	71.26	71.17	71.19	17616.0
2008-06-25 06:00:00	DIA	ETF	118.62	118.62	118.62	118.62	400.0
2008-06-25 07:00:00	DIA	ETF	118.47	118.47	118.47	118.47	1000.0
2008-06-25 08:00:00	DIA	ETF	118.45	118.5	118.34	118.39	73417.0
2008-06-25 09:00:00	DIA	ETF	118.38	118.49	117.78	118.33	1713408.0
2008-06-25 10:00:00	DIA	ETF	118.34	118.81	118.16	118.7	2929249.0

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

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