PREVIEW / etf_1hour / 2009-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-21.parquet
  size:    136 KB
  rows:    4,208

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
2009-04-21 04:00:00	SPY	ETF	84.06	84.24	84.02	84.02	96700.0
2009-04-21 05:00:00	SPY	ETF	84.13	84.22	83.83	83.83	28749.0
2009-04-21 06:00:00	SPY	ETF	83.8	84.13	83.19	83.32	131577.0
2009-04-21 07:00:00	SPY	ETF	83.31	83.39	83.06	83.18	1751089.0
2009-04-21 08:00:00	SPY	ETF	83.18	84.14	82.84	82.93	4340890.0
2009-04-21 09:00:00	SPY	ETF	82.93	83.6	82.75	83.41	39635262.0
2009-04-21 10:00:00	SPY	ETF	83.42	83.5	82.9	83.5	37346101.0
2009-04-21 11:00:00	SPY	ETF	83.5	84.37	83.49	84.27	47274670.0
2009-04-21 12:00:00	SPY	ETF	84.2699	84.64	84.2	84.36	25800886.0
2009-04-21 13:00:00	SPY	ETF	84.3699	84.56	83.2	84.38	25947660.0
2009-04-21 14:00:00	SPY	ETF	84.38	84.7	84.03	84.39	31077383.0
2009-04-21 15:00:00	SPY	ETF	84.39	85.13	84.3	85.06	63161552.0
2009-04-21 16:00:00	SPY	ETF	85.06	85.31	83.1297	85.07	17124551.0
2009-04-21 17:00:00	SPY	ETF	85.08	85.28	84.8	84.95	5239515.0
2009-04-21 18:00:00	SPY	ETF	84.97	85.11	84.95	84.95	111626.0
2009-04-21 19:00:00	SPY	ETF	84.98	84.99	84.91	84.93	43463.0
2009-04-21 04:00:00	QQQ	ETF	32.45	32.49	32.45	32.45	890.0
2009-04-21 05:00:00	QQQ	ETF	32.44	32.44	32.44	32.44	100.0
2009-04-21 06:00:00	QQQ	ETF	32.43	32.43	32.32	32.32	3400.0
2009-04-21 07:00:00	QQQ	ETF	32.21	32.28	32.16	32.2	77727.0
2009-04-21 08:00:00	QQQ	ETF	32.22	32.22	32.1	32.13	1175894.0
2009-04-21 09:00:00	QQQ	ETF	32.13	32.66	32.01	32.55	25512153.0
2009-04-21 10:00:00	QQQ	ETF	32.55	32.57	32.24	32.4	17797553.0
2009-04-21 11:00:00	QQQ	ETF	32.4	32.64	32.39	32.56	19916344.0
2009-04-21 12:00:00	QQQ	ETF	32.569	32.66	32.54	32.56	10511815.0
2009-04-21 13:00:00	QQQ	ETF	32.56	32.59	32.39	32.45	12493497.0
2009-04-21 14:00:00	QQQ	ETF	32.45	32.55	32.32	32.44	14110151.0
2009-04-21 15:00:00	QQQ	ETF	32.44	32.74	32.42	32.69	23182068.0
2009-04-21 16:00:00	QQQ	ETF	32.69	32.81	32.64	32.7	7893548.0
2009-04-21 17:00:00	QQQ	ETF	32.7	32.74	32.2068	32.69	1145152.0
2009-04-21 18:00:00	QQQ	ETF	32.69	32.73	32.67	32.68	18394.0
2009-04-21 19:00:00	QQQ	ETF	32.69	32.69	32.66	32.69	9500.0
2009-04-21 06:00:00	IWM	ETF	45.79	45.79	45.45	45.45	13900.0
2009-04-21 07:00:00	IWM	ETF	45.44	45.52	45.3	45.35	87412.0
2009-04-21 08:00:00	IWM	ETF	45.35	46.11	45.03	45.11	288838.0
2009-04-21 09:00:00	IWM	ETF	45.07	45.71	44.95	45.6	7716579.0
2009-04-21 10:00:00	IWM	ETF	45.6	45.76	45.26	45.75	5497953.0
2009-04-21 11:00:00	IWM	ETF	45.75	46.53	45.75	46.41	6912384.0
2009-04-21 12:00:00	IWM	ETF	46.42	46.71	46.36	46.46	4745230.0
2009-04-21 13:00:00	IWM	ETF	46.46	46.59	46.19	46.3	4566525.0
2009-04-21 14:00:00	IWM	ETF	46.31	46.68	46.12	46.47	6724599.0
2009-04-21 15:00:00	IWM	ETF	46.48	47.058	46.44	46.96	14546781.0
2009-04-21 16:00:00	IWM	ETF	46.96	47.05	46.5	46.77	2676812.0
2009-04-21 17:00:00	IWM	ETF	46.79	46.94	45.2409	46.79	2032489.0
2009-04-21 19:00:00	IWM	ETF	46.78	46.78	46.75	46.75	1200.0
2009-04-21 05:00:00	DIA	ETF	78.98	78.98	78.98	78.98	100.0
2009-04-21 06:00:00	DIA	ETF	78.96	78.96	78.25	78.25	400.0
2009-04-21 07:00:00	DIA	ETF	78.23	78.3	78.03	78.07	19263.0
2009-04-21 08:00:00	DIA	ETF	78.09	78.12	77.82	77.9	193189.0
2009-04-21 09:00:00	DIA	ETF	77.87	78.47	77.76	78.3492	2455073.0

> showing 50 of 4,208 rows — these rows as CSV

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