PREVIEW / etf_1hour / 2008-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-03.parquet
  size:    108 KB
  rows:    3,505

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-03 04:00:00	SPY	ETF	128.28	128.28	128.28	128.28	100.0
2008-09-03 05:00:00	SPY	ETF	128.06	128.06	127.89	127.89	2100.0
2008-09-03 06:00:00	SPY	ETF	127.96	127.96	127.77	127.77	113300.0
2008-09-03 07:00:00	SPY	ETF	127.8	127.8	127.29	127.35	1135055.0
2008-09-03 08:00:00	SPY	ETF	127.34	127.99	127.31	127.85	1718168.0
2008-09-03 09:00:00	SPY	ETF	127.87	128.19	127.52	128.13	24292523.0
2008-09-03 10:00:00	SPY	ETF	128.13	128.5	127.58	127.86	46785633.0
2008-09-03 11:00:00	SPY	ETF	127.86	128.29	127.01	127.12	37076308.0
2008-09-03 12:00:00	SPY	ETF	127.13	127.29	126.93	127.15	24371880.0
2008-09-03 13:00:00	SPY	ETF	127.15	127.69	126.97	127.64	27347287.0
2008-09-03 14:00:00	SPY	ETF	127.63	127.83	127.0	127.34	38393896.0
2008-09-03 15:00:00	SPY	ETF	127.33	128.03	127.05	127.96	45627955.0
2008-09-03 16:00:00	SPY	ETF	127.979	127.98	127.78	127.94	3052130.0
2008-09-03 17:00:00	SPY	ETF	127.94	128.04	127.83	127.97	287040.0
2008-09-03 18:00:00	SPY	ETF	128.0	128.05	127.95	128.05	37724.0
2008-09-03 19:00:00	SPY	ETF	128.02	128.04	128.01	128.04	25778.0
2008-09-03 04:00:00	QQQ	ETF	45.67	45.67	45.67	45.67	100.0
2008-09-03 06:00:00	QQQ	ETF	45.37	45.37	45.35	45.35	3000.0
2008-09-03 07:00:00	QQQ	ETF	45.31	45.31	45.15	45.21	248298.0
2008-09-03 08:00:00	QQQ	ETF	45.22	45.44	45.21	45.42	3596080.0
2008-09-03 09:00:00	QQQ	ETF	45.43	45.5	45.23	45.48	26872774.0
2008-09-03 10:00:00	QQQ	ETF	45.48	45.6381	45.23	45.38	26043803.0
2008-09-03 11:00:00	QQQ	ETF	45.39	45.54	44.92	44.968	17305208.0
2008-09-03 12:00:00	QQQ	ETF	44.96	45.03	44.82	44.99	17176890.0
2008-09-03 13:00:00	QQQ	ETF	45.0	45.21	44.91	45.16	21711027.0
2008-09-03 14:00:00	QQQ	ETF	45.16	45.29	44.9	44.94	19664897.0
2008-09-03 15:00:00	QQQ	ETF	44.94	45.15	44.79	45.12	22927985.0
2008-09-03 16:00:00	QQQ	ETF	45.12	45.15	44.8777	45.09	4191645.0
2008-09-03 17:00:00	QQQ	ETF	45.1	45.12	45.08	45.08	73947.0
2008-09-03 18:00:00	QQQ	ETF	45.08	45.12	45.08	45.12	23030.0
2008-09-03 19:00:00	QQQ	ETF	45.12	45.14	45.12	45.14	16242.0
2008-09-03 05:00:00	IWM	ETF	73.86	73.86	73.86	73.86	2500.0
2008-09-03 07:00:00	IWM	ETF	73.68	73.68	73.28	73.34	140504.0
2008-09-03 08:00:00	IWM	ETF	73.34	73.7	73.33	73.67	371139.0
2008-09-03 09:00:00	IWM	ETF	73.66	74.17	73.39	74.12	10719046.0
2008-09-03 10:00:00	IWM	ETF	74.12	74.7	73.95	74.35	20897964.0
2008-09-03 11:00:00	IWM	ETF	74.35	74.55	73.54	73.62	13152550.0
2008-09-03 12:00:00	IWM	ETF	73.61	73.98	73.51	73.83	8606032.0
2008-09-03 13:00:00	IWM	ETF	73.83	74.19	73.69	74.14	9657216.0
2008-09-03 14:00:00	IWM	ETF	74.14	74.24	73.69	73.85	11521633.0
2008-09-03 15:00:00	IWM	ETF	73.84	74.23	73.59	74.22	18176984.0
2008-09-03 16:00:00	IWM	ETF	74.21	74.21	73.75	73.98	2001447.0
2008-09-03 17:00:00	IWM	ETF	74.11	74.11	74.05	74.05	5160.0
2008-09-03 18:00:00	IWM	ETF	74.09	74.1	74.09	74.1	42773.0
2008-09-03 19:00:00	IWM	ETF	74.13	74.16	74.13	74.16	51900.0
2008-09-03 07:00:00	DIA	ETF	114.91	114.91	114.71	114.71	2006.0
2008-09-03 08:00:00	DIA	ETF	114.66	115.14	114.64	115.12	84685.0
2008-09-03 09:00:00	DIA	ETF	115.12	115.36	114.72	115.31	2071877.0
2008-09-03 10:00:00	DIA	ETF	115.3	115.74	114.87	115.15	3072694.0
2008-09-03 11:00:00	DIA	ETF	115.15	115.55	114.41	114.5	2898550.0

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

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