PREVIEW / etf_1hour / 2008-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-18.parquet
  size:    110 KB
  rows:    3,551

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-18 05:00:00	SPY	ETF	129.97	129.99	129.97	129.98	10000.0
2008-08-18 06:00:00	SPY	ETF	130.0	130.79	130.0	130.79	97500.0
2008-08-18 07:00:00	SPY	ETF	130.71	130.79	130.51	130.52	161084.0
2008-08-18 08:00:00	SPY	ETF	130.53	130.76	130.45	130.76	1056855.0
2008-08-18 09:00:00	SPY	ETF	130.77	130.79	129.44	129.635	22650925.0
2008-08-18 10:00:00	SPY	ETF	129.64	129.8	129.27	129.73	26061144.0
2008-08-18 11:00:00	SPY	ETF	129.72	129.85	129.08	129.09	17797612.0
2008-08-18 12:00:00	SPY	ETF	129.09	129.09	128.44	128.51	23326432.0
2008-08-18 13:00:00	SPY	ETF	128.51	128.73	128.2	128.2	15157852.0
2008-08-18 14:00:00	SPY	ETF	128.2	128.33	127.85	128.13	21511874.0
2008-08-18 15:00:00	SPY	ETF	128.13	128.32	127.66	128.25	37681490.0
2008-08-18 16:00:00	SPY	ETF	128.28	128.54	128.19	128.47	2450285.0
2008-08-18 17:00:00	SPY	ETF	128.49	128.54	128.39	128.51	1079826.0
2008-08-18 18:00:00	SPY	ETF	128.51	128.53	128.39	128.49	298620.0
2008-08-18 19:00:00	SPY	ETF	128.45	128.5	128.37	128.38	57880.0
2008-08-18 04:00:00	QQQ	ETF	48.11	48.11	48.11	48.11	800.0
2008-08-18 06:00:00	QQQ	ETF	48.48	48.5	48.4	48.5	114700.0
2008-08-18 07:00:00	QQQ	ETF	48.51	48.51	48.39	48.41	150512.0
2008-08-18 08:00:00	QQQ	ETF	48.41	48.49	48.37	48.47	744573.0
2008-08-18 09:00:00	QQQ	ETF	48.47	48.47	47.9	48.07	22550882.0
2008-08-18 10:00:00	QQQ	ETF	48.07	48.13	47.84	48.09	22218116.0
2008-08-18 11:00:00	QQQ	ETF	48.09	48.15	47.87	47.8701	8982845.0
2008-08-18 12:00:00	QQQ	ETF	47.87	47.88	47.47	47.52	17664788.0
2008-08-18 13:00:00	QQQ	ETF	47.53	47.72	47.41	47.42	12632683.0
2008-08-18 14:00:00	QQQ	ETF	47.42	47.53	47.34	47.4299	12201436.0
2008-08-18 15:00:00	QQQ	ETF	47.422	47.6	47.26	47.59	24342179.0
2008-08-18 16:00:00	QQQ	ETF	47.6	48.1543	47.4143	47.75	11974242.0
2008-08-18 17:00:00	QQQ	ETF	47.75	47.76	47.6	47.76	4024984.0
2008-08-18 18:00:00	QQQ	ETF	47.76	47.76	47.6	47.73	69791.0
2008-08-18 19:00:00	QQQ	ETF	47.73	47.73	47.7	47.71	30722.0
2008-08-18 04:00:00	IWM	ETF	75.04	75.04	75.04	75.04	300.0
2008-08-18 06:00:00	IWM	ETF	75.4	75.53	75.4	75.53	5200.0
2008-08-18 07:00:00	IWM	ETF	75.6	75.6	75.42	75.47	145288.0
2008-08-18 08:00:00	IWM	ETF	75.46	75.52	75.35	75.5	434045.0
2008-08-18 09:00:00	IWM	ETF	75.51	75.54	74.63	74.82	11249538.0
2008-08-18 10:00:00	IWM	ETF	74.82	75.36	74.68	75.28	13857421.0
2008-08-18 11:00:00	IWM	ETF	75.28	75.42	74.83	74.86	7740557.0
2008-08-18 12:00:00	IWM	ETF	74.85	75.15	74.29	74.42	12058002.0
2008-08-18 13:00:00	IWM	ETF	74.43	74.68	74.03	74.03	11539353.0
2008-08-18 14:00:00	IWM	ETF	74.03	74.12	73.56	73.84	15362914.0
2008-08-18 15:00:00	IWM	ETF	73.83	74.03	73.6	73.87	19398736.0
2008-08-18 16:00:00	IWM	ETF	73.86	75.18	73.82	74.26	5065483.0
2008-08-18 17:00:00	IWM	ETF	74.24	74.26	74.18	74.18	8452.0
2008-08-18 18:00:00	IWM	ETF	74.25	74.25	74.18	74.18	5300.0
2008-08-18 07:00:00	DIA	ETF	116.96	117.02	116.93	116.95	12088.0
2008-08-18 08:00:00	DIA	ETF	116.9	117.1	116.86	117.07	22623.0
2008-08-18 09:00:00	DIA	ETF	117.04	117.07	116.15	116.31	1907780.0
2008-08-18 10:00:00	DIA	ETF	116.3	116.35	115.71	116.16	3578968.0
2008-08-18 11:00:00	DIA	ETF	116.17	116.29	115.58	115.59	1465631.0
2008-08-18 12:00:00	DIA	ETF	115.55	115.55	114.67	114.74	3666724.0

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

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