PREVIEW / etf_1hour / 2008-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-23.parquet
  size:    109 KB
  rows:    3,640

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-01-23 04:00:00	SPY	ETF	130.04	130.22	129.34	129.71	10100.0
2008-01-23 05:00:00	SPY	ETF	129.71	129.77	129.0	129.27	17400.0
2008-01-23 06:00:00	SPY	ETF	129.37	129.45	128.2	128.55	848000.0
2008-01-23 07:00:00	SPY	ETF	128.8	129.47	128.25	128.35	2099200.0
2008-01-23 08:00:00	SPY	ETF	128.98	130.92	126.02	127.11	24461750.0
2008-01-23 09:00:00	SPY	ETF	127.08	129.46	126.94	129.23	55222049.0
2008-01-23 10:00:00	SPY	ETF	129.24	131.0	128.94	129.6	79273314.0
2008-01-23 11:00:00	SPY	ETF	129.6	130.9691	128.24	128.5	42514578.0
2008-01-23 12:00:00	SPY	ETF	128.5	130.9691	126.84	127.64	52417406.0
2008-01-23 13:00:00	SPY	ETF	127.64	129.56	127.22	129.19	55433339.0
2008-01-23 14:00:00	SPY	ETF	129.18	130.72	128.86	130.1	58502598.0
2008-01-23 15:00:00	SPY	ETF	130.11	133.88	129.97	133.81	106216544.0
2008-01-23 16:00:00	SPY	ETF	133.7901	134.5	129.04	134.07	17543600.0
2008-01-23 17:00:00	SPY	ETF	134.07	134.34	130.97	134.34	4648900.0
2008-01-23 18:00:00	SPY	ETF	134.34	134.65	134.01	134.16	250300.0
2008-01-23 19:00:00	SPY	ETF	134.1	134.24	134.05	134.18	429900.0
2008-01-23 06:00:00	QQQ	ETF	43.53	43.53	42.92	43.08	113800.0
2008-01-23 07:00:00	QQQ	ETF	43.13	43.22	42.82	42.93	997457.0
2008-01-23 08:00:00	QQQ	ETF	42.93	43.619	42.25	42.51	7350079.0
2008-01-23 09:00:00	QQQ	ETF	42.51	43.07	42.37	43.01	33680192.0
2008-01-23 10:00:00	QQQ	ETF	43.0401	43.41	42.83	42.99	47071340.0
2008-01-23 11:00:00	QQQ	ETF	42.9999	43.04	42.14	42.1695	43911879.0
2008-01-23 12:00:00	QQQ	ETF	42.16	42.4	41.61	41.91	46927363.0
2008-01-23 13:00:00	QQQ	ETF	41.92	42.4	41.77	42.32	35681600.0
2008-01-23 14:00:00	QQQ	ETF	42.32	42.98	42.18	42.7	54102180.0
2008-01-23 15:00:00	QQQ	ETF	42.7	44.15	42.64	43.99	98180181.0
2008-01-23 16:00:00	QQQ	ETF	44.0	44.5	42.2076	44.25	20096554.0
2008-01-23 17:00:00	QQQ	ETF	44.26	44.35	43.68	44.33	2700091.0
2008-01-23 18:00:00	QQQ	ETF	44.33	44.47	44.33	44.38	210176.0
2008-01-23 19:00:00	QQQ	ETF	44.38	44.47	44.38	44.45	112359.0
2008-01-23 06:00:00	IWM	ETF	65.7	65.7	65.48	65.48	700.0
2008-01-23 07:00:00	IWM	ETF	65.76	66.0	65.45	65.45	460200.0
2008-01-23 08:00:00	IWM	ETF	65.48	65.72	64.59	64.97	1463300.0
2008-01-23 09:00:00	IWM	ETF	64.93	66.51	64.93	66.45	16166329.0
2008-01-23 10:00:00	IWM	ETF	66.45	67.35	66.03	66.62	26523063.0
2008-01-23 11:00:00	IWM	ETF	66.62	66.74	65.89	65.98	14607979.0
2008-01-23 12:00:00	IWM	ETF	65.97	66.42	65.09	65.49	21304043.0
2008-01-23 13:00:00	IWM	ETF	65.5	66.34	65.41	66.13	15054176.0
2008-01-23 14:00:00	IWM	ETF	66.12	67.22	65.95	66.91	18810076.0
2008-01-23 15:00:00	IWM	ETF	66.91	69.14	66.86	69.09	57253345.0
2008-01-23 16:00:00	IWM	ETF	69.08	69.28	66.87	69.24	11491257.0
2008-01-23 17:00:00	IWM	ETF	69.24	69.31	69.02	69.3	156900.0
2008-01-23 18:00:00	IWM	ETF	69.3	69.41	69.04	69.06	45900.0
2008-01-23 19:00:00	IWM	ETF	69.15	69.15	69.1	69.15	1400.0
2008-01-23 07:00:00	DIA	ETF	118.04	118.5	117.71	117.75	39100.0
2008-01-23 08:00:00	DIA	ETF	117.76	118.08	116.25	116.95	223829.0
2008-01-23 09:00:00	DIA	ETF	116.98	118.31	116.98	118.3	4831665.0
2008-01-23 10:00:00	DIA	ETF	118.14	119.49	117.93	118.51	6250127.0
2008-01-23 11:00:00	DIA	ETF	118.52	119.07	117.55	117.8	3776765.0
2008-01-23 12:00:00	DIA	ETF	117.76	118.24	116.38	116.99	4305594.0

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

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