PREVIEW / etf_1hour / 2008-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-25.parquet
  size:    106 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-08-25 04:00:00	SPY	ETF	129.09	129.12	129.09	129.12	200.0
2008-08-25 05:00:00	SPY	ETF	129.14	129.14	129.14	129.14	500.0
2008-08-25 06:00:00	SPY	ETF	129.06	129.06	129.03	129.03	12500.0
2008-08-25 07:00:00	SPY	ETF	129.07	129.4	129.07	129.4	157262.0
2008-08-25 08:00:00	SPY	ETF	129.4	129.45	128.62	128.75	3166186.0
2008-08-25 09:00:00	SPY	ETF	128.75	129.15	128.35	128.48	19354741.0
2008-08-25 10:00:00	SPY	ETF	128.47	128.77	128.01	128.12	26786943.0
2008-08-25 11:00:00	SPY	ETF	128.12	129.65	127.22	127.33	18607892.0
2008-08-25 12:00:00	SPY	ETF	127.33	127.35	126.89	127.09	24807576.0
2008-08-25 13:00:00	SPY	ETF	127.08	127.48	127.04	127.3486	25530656.0
2008-08-25 14:00:00	SPY	ETF	127.34	127.54	127.01	127.09	18952415.0
2008-08-25 15:00:00	SPY	ETF	127.09	127.21	126.75	127.08	27739423.0
2008-08-25 16:00:00	SPY	ETF	127.11	127.13	126.92	127.01	3755105.0
2008-08-25 17:00:00	SPY	ETF	127.01	127.08	127.0	127.05	168920.0
2008-08-25 18:00:00	SPY	ETF	127.07	127.07	127.02	127.04	17568.0
2008-08-25 19:00:00	SPY	ETF	127.04	127.05	127.01	127.05	8537.0
2008-08-25 04:00:00	QQQ	ETF	47.29	47.29	47.27	47.27	1000.0
2008-08-25 05:00:00	QQQ	ETF	47.27	47.27	47.27	47.27	200.0
2008-08-25 07:00:00	QQQ	ETF	47.3	47.41	47.29	47.41	63636.0
2008-08-25 08:00:00	QQQ	ETF	47.4	47.42	47.12	47.15	1356908.0
2008-08-25 09:00:00	QQQ	ETF	47.16	47.21	46.97	47.02	13333189.0
2008-08-25 10:00:00	QQQ	ETF	47.02	47.21	46.81	46.86	20188700.0
2008-08-25 11:00:00	QQQ	ETF	46.86	46.87	46.52	46.53	16668274.0
2008-08-25 12:00:00	QQQ	ETF	46.53	46.58	46.41	46.51	16655288.0
2008-08-25 13:00:00	QQQ	ETF	46.5	46.65	46.49	46.54	12814142.0
2008-08-25 14:00:00	QQQ	ETF	46.53	46.63	46.42	46.48	9836874.0
2008-08-25 15:00:00	QQQ	ETF	46.48	47.02	46.37	46.55	22687139.0
2008-08-25 16:00:00	QQQ	ETF	46.56	46.6699	46.4626	46.59	9615483.0
2008-08-25 17:00:00	QQQ	ETF	46.59	46.59	46.56	46.59	100465.0
2008-08-25 18:00:00	QQQ	ETF	46.6	46.6	46.57	46.57	20059.0
2008-08-25 19:00:00	QQQ	ETF	46.56	46.59	46.55	46.59	10503.0
2008-08-25 07:00:00	IWM	ETF	73.58	73.68	73.57	73.67	123504.0
2008-08-25 08:00:00	IWM	ETF	73.68	73.69	73.22	73.23	383837.0
2008-08-25 09:00:00	IWM	ETF	73.25	73.45	70.69	72.82	8870182.0
2008-08-25 10:00:00	IWM	ETF	72.83	73.02	72.27	72.36	11612811.0
2008-08-25 11:00:00	IWM	ETF	72.35	73.68	71.83	71.86	9764604.0
2008-08-25 12:00:00	IWM	ETF	71.86	71.91	71.61	71.76	14848457.0
2008-08-25 13:00:00	IWM	ETF	71.76	72.09	71.74	71.97	8951754.0
2008-08-25 14:00:00	IWM	ETF	71.97	72.22	71.9	71.98	9095849.0
2008-08-25 15:00:00	IWM	ETF	71.98	72.12	71.8	71.93	15571880.0
2008-08-25 16:00:00	IWM	ETF	71.93	73.63	71.91	72.07	5721784.0
2008-08-25 17:00:00	IWM	ETF	72.1	72.14	72.1	72.11	5732.0
2008-08-25 18:00:00	IWM	ETF	72.1	72.15	72.1	72.15	19440.0
2008-08-25 06:00:00	DIA	ETF	115.98	115.98	115.98	115.98	100.0
2008-08-25 07:00:00	DIA	ETF	115.96	116.21	115.95	116.2	2362.0
2008-08-25 08:00:00	DIA	ETF	116.26	116.27	115.55	115.64	50389.0
2008-08-25 09:00:00	DIA	ETF	115.68	115.71	115.22	115.27	1715332.0
2008-08-25 10:00:00	DIA	ETF	115.28	115.54	115.02	115.09	2665304.0
2008-08-25 11:00:00	DIA	ETF	115.07	115.1	114.1	114.17	2441561.0
2008-08-25 12:00:00	DIA	ETF	114.18	114.18	113.79	114.03	3574483.0

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

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