PREVIEW / etf_1hour / 2008-09-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-04.parquet
  size:    112 KB
  rows:    3,616

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-09-04 04:00:00	SPY	ETF	127.5	127.5	127.5	127.5	100.0
2008-09-04 05:00:00	SPY	ETF	127.39	127.39	127.37	127.37	1000.0
2008-09-04 06:00:00	SPY	ETF	127.36	127.7	127.3	127.64	98900.0
2008-09-04 07:00:00	SPY	ETF	127.68	127.69	127.36	127.6	478258.0
2008-09-04 08:00:00	SPY	ETF	127.58	127.88	127.11	127.29	4250401.0
2008-09-04 09:00:00	SPY	ETF	127.28	127.88	126.58	126.83	30673461.0
2008-09-04 10:00:00	SPY	ETF	126.83	127.23	125.59	125.82	63506428.0
2008-09-04 11:00:00	SPY	ETF	125.81	126.1	125.2	125.38	47230228.0
2008-09-04 12:00:00	SPY	ETF	125.38	125.78	125.03	125.12	27609239.0
2008-09-04 13:00:00	SPY	ETF	125.12	126.52	124.56	124.87	36404233.0
2008-09-04 14:00:00	SPY	ETF	124.87	126.2	124.09	124.6	48083433.0
2008-09-04 15:00:00	SPY	ETF	124.6	125.0	124.0	124.08	72666631.0
2008-09-04 16:00:00	SPY	ETF	124.1001	124.468	123.96	124.16	5393737.0
2008-09-04 17:00:00	SPY	ETF	124.17	126.2	123.94	123.95	287772.0
2008-09-04 18:00:00	SPY	ETF	123.99	124.32	123.08	123.34	511373.0
2008-09-04 19:00:00	SPY	ETF	123.33	123.56	123.33	123.5	146410.0
2008-09-04 04:00:00	QQQ	ETF	45.0	45.0	44.9	44.9	900.0
2008-09-04 06:00:00	QQQ	ETF	44.85	44.85	44.85	44.85	300.0
2008-09-04 07:00:00	QQQ	ETF	44.92	44.96	44.85	44.94	161629.0
2008-09-04 08:00:00	QQQ	ETF	44.95	44.96	44.7	44.85	1176683.0
2008-09-04 09:00:00	QQQ	ETF	44.84	44.86	44.62	44.69	19671813.0
2008-09-04 10:00:00	QQQ	ETF	44.68	44.91	44.35	44.47	42317616.0
2008-09-04 11:00:00	QQQ	ETF	44.46	44.55	44.26	44.42	29909926.0
2008-09-04 12:00:00	QQQ	ETF	44.4195	44.62	44.19	44.2701	21125300.0
2008-09-04 13:00:00	QQQ	ETF	44.275	44.318	43.96	44.05	16719755.0
2008-09-04 14:00:00	QQQ	ETF	44.04	44.05	43.81	43.92	23031228.0
2008-09-04 15:00:00	QQQ	ETF	43.92	44.09	43.67	43.67	44330623.0
2008-09-04 16:00:00	QQQ	ETF	43.67	44.45	43.6	43.65	7674615.0
2008-09-04 17:00:00	QQQ	ETF	43.66	43.68	43.57	43.64	283993.0
2008-09-04 18:00:00	QQQ	ETF	43.61	43.61	43.31	43.42	285028.0
2008-09-04 19:00:00	QQQ	ETF	43.44	43.49	43.41	43.48	144185.0
2008-09-04 07:00:00	IWM	ETF	73.99	73.99	73.8	73.89	127800.0
2008-09-04 08:00:00	IWM	ETF	73.88	73.98	73.5	73.69	658666.0
2008-09-04 09:00:00	IWM	ETF	73.68	73.69	73.01	73.17	14437259.0
2008-09-04 10:00:00	IWM	ETF	73.16	73.44	72.09	72.39	30106287.0
2008-09-04 11:00:00	IWM	ETF	72.38	72.46	72.12	72.33	14050759.0
2008-09-04 12:00:00	IWM	ETF	72.33	72.52	72.05	72.12	9118359.0
2008-09-04 13:00:00	IWM	ETF	72.12	72.18	71.78	71.97	9429805.0
2008-09-04 14:00:00	IWM	ETF	71.96	71.96	71.48	71.94	14981062.0
2008-09-04 15:00:00	IWM	ETF	71.95	72.18	71.75	71.82	22544751.0
2008-09-04 16:00:00	IWM	ETF	71.83	74.09	71.73	71.93	9005618.0
2008-09-04 17:00:00	IWM	ETF	71.96	71.96	71.82	71.82	11099.0
2008-09-04 18:00:00	IWM	ETF	71.77	71.88	71.3	71.3	60796.0
2008-09-04 19:00:00	IWM	ETF	71.97	71.97	71.42	71.56	21895.0
2008-09-04 06:00:00	DIA	ETF	115.26	115.26	115.26	115.26	100.0
2008-09-04 07:00:00	DIA	ETF	115.18	115.29	115.18	115.28	1272.0
2008-09-04 08:00:00	DIA	ETF	115.29	115.29	114.79	114.91	60846.0
2008-09-04 09:00:00	DIA	ETF	114.91	114.92	114.1	114.3	3088401.0
2008-09-04 10:00:00	DIA	ETF	114.29	114.74	113.15	113.36	7354111.0
2008-09-04 11:00:00	DIA	ETF	113.35	113.43	112.8	113.02	5551584.0

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

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