PREVIEW / etf_1hour / 2008-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-02.parquet
  size:    113 KB
  rows:    3,622

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-02 04:00:00	SPY	ETF	128.8	129.6	128.6	129.6	500.0
2008-09-02 05:00:00	SPY	ETF	129.55	129.55	129.55	129.55	5100.0
2008-09-02 06:00:00	SPY	ETF	129.65	129.65	129.51	129.57	352700.0
2008-09-02 07:00:00	SPY	ETF	129.51	129.73	129.5	129.71	1096025.0
2008-09-02 08:00:00	SPY	ETF	129.71	129.96	128.57	129.85	5093056.0
2008-09-02 09:00:00	SPY	ETF	129.85	130.71	128.9	130.32	31504995.0
2008-09-02 10:00:00	SPY	ETF	130.32	130.58	129.49	129.799	42433315.0
2008-09-02 11:00:00	SPY	ETF	129.79	130.04	129.58	129.66	16827589.0
2008-09-02 12:00:00	SPY	ETF	129.66	130.2	128.81	128.98	26494851.0
2008-09-02 13:00:00	SPY	ETF	128.98	129.28	128.3	128.38	27384499.0
2008-09-02 14:00:00	SPY	ETF	128.39	128.52	127.56	127.69	42272815.0
2008-09-02 15:00:00	SPY	ETF	127.69	128.15	127.52	128.09	45720861.0
2008-09-02 16:00:00	SPY	ETF	128.1386	128.623	127.95	128.623	6657004.0
2008-09-02 17:00:00	SPY	ETF	128.0	128.0912	127.93	127.95	47009.0
2008-09-02 18:00:00	SPY	ETF	127.98	127.99	127.89	127.89	53617.0
2008-09-02 19:00:00	SPY	ETF	127.87	128.02	127.84	128.02	65700.0
2008-09-02 04:00:00	QQQ	ETF	45.9	46.4	45.9	46.4	1300.0
2008-09-02 05:00:00	QQQ	ETF	46.45	46.5	46.45	46.5	590.0
2008-09-02 06:00:00	QQQ	ETF	46.49	46.7	46.27	46.7	5810.0
2008-09-02 07:00:00	QQQ	ETF	46.56	46.63	45.65	46.6	442832.0
2008-09-02 08:00:00	QQQ	ETF	46.59	46.84	46.12	46.72	1441647.0
2008-09-02 09:00:00	QQQ	ETF	46.72	47.08	46.72	46.93	28149540.0
2008-09-02 10:00:00	QQQ	ETF	46.93	47.005	46.51	46.61	24950955.0
2008-09-02 11:00:00	QQQ	ETF	46.61	46.68	46.48	46.5099	9691848.0
2008-09-02 12:00:00	QQQ	ETF	46.5085	46.54	46.13	46.2299	14905247.0
2008-09-02 13:00:00	QQQ	ETF	46.22	46.28	45.59	45.65	30090548.0
2008-09-02 14:00:00	QQQ	ETF	45.65	45.76	45.34	45.42	24940503.0
2008-09-02 15:00:00	QQQ	ETF	45.42	45.67	45.36	45.54	21126326.0
2008-09-02 16:00:00	QQQ	ETF	45.54	46.0137	45.5	45.55	3407314.0
2008-09-02 17:00:00	QQQ	ETF	45.54	45.55	45.5	45.54	64660.0
2008-09-02 18:00:00	QQQ	ETF	45.53	45.55	45.47	45.52	99216.0
2008-09-02 19:00:00	QQQ	ETF	45.51	45.53	45.51	45.53	27489.0
2008-09-02 07:00:00	IWM	ETF	74.64	74.77	74.63	74.66	204320.0
2008-09-02 08:00:00	IWM	ETF	74.66	74.9	74.64	74.78	752295.0
2008-09-02 09:00:00	IWM	ETF	74.78	75.5	74.71	75.03	19750517.0
2008-09-02 10:00:00	IWM	ETF	75.03	75.19	73.87	74.32	19131800.0
2008-09-02 11:00:00	IWM	ETF	74.33	74.52	74.17	74.25	9317557.0
2008-09-02 12:00:00	IWM	ETF	74.24	74.29	73.78	74.08	9195104.0
2008-09-02 13:00:00	IWM	ETF	74.08	74.35	73.69	73.79	8133206.0
2008-09-02 14:00:00	IWM	ETF	73.79	73.89	73.08	73.13	13320322.0
2008-09-02 15:00:00	IWM	ETF	73.13	73.83	73.0	73.83	16669141.0
2008-09-02 16:00:00	IWM	ETF	73.83	74.29	73.17	73.82	7402163.0
2008-09-02 17:00:00	IWM	ETF	73.81	73.82	73.75	73.75	6947.0
2008-09-02 18:00:00	IWM	ETF	73.73	73.74	73.73	73.74	900.0
2008-09-02 19:00:00	IWM	ETF	73.66	73.7	73.65	73.69	19889.0
2008-09-02 04:00:00	DIA	ETF	115.79	116.04	115.79	116.04	200.0
2008-09-02 06:00:00	DIA	ETF	116.43	116.43	116.43	116.43	100.0
2008-09-02 07:00:00	DIA	ETF	116.44	116.53	116.44	116.51	1887.0
2008-09-02 08:00:00	DIA	ETF	116.52	116.82	116.52	116.76	45332.0
2008-09-02 09:00:00	DIA	ETF	116.77	118.01	116.77	117.67	3369358.0

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

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