PREVIEW / etf_1hour / 2009-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-22.parquet
  size:    139 KB
  rows:    4,280

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-07-22 04:00:00	SPY	ETF	95.18	95.28	95.03	95.19	11950.0
2009-07-22 05:00:00	SPY	ETF	95.19	95.35	95.13	95.35	10100.0
2009-07-22 06:00:00	SPY	ETF	95.39	95.5	95.23	95.26	115601.0
2009-07-22 07:00:00	SPY	ETF	95.3	95.55	95.29	95.48	657036.0
2009-07-22 08:00:00	SPY	ETF	95.46	95.57	94.82	94.98	5379096.0
2009-07-22 09:00:00	SPY	ETF	94.98	95.69	94.89	95.59	28216376.0
2009-07-22 10:00:00	SPY	ETF	95.59	95.89	95.23	95.61	34959281.0
2009-07-22 11:00:00	SPY	ETF	95.61	95.77	95.37	95.53	19839992.0
2009-07-22 12:00:00	SPY	ETF	95.53	96.13	95.44	95.93	22849956.0
2009-07-22 13:00:00	SPY	ETF	95.93	96.1	95.572	95.82	17358798.0
2009-07-22 14:00:00	SPY	ETF	95.81	95.9	95.52	95.779	19164296.0
2009-07-22 15:00:00	SPY	ETF	95.77	95.88	95.29	95.54	33742744.0
2009-07-22 16:00:00	SPY	ETF	95.53	95.95	95.29	95.52	11671657.0
2009-07-22 17:00:00	SPY	ETF	95.52	95.52	95.39	95.4	78838.0
2009-07-22 18:00:00	SPY	ETF	95.4	95.44	95.38	95.4	50550.0
2009-07-22 19:00:00	SPY	ETF	95.41	95.48	95.38	95.39	81817.0
2009-07-22 04:00:00	QQQ	ETF	38.14	38.14	38.06	38.06	1300.0
2009-07-22 06:00:00	QQQ	ETF	38.25	38.25	38.15	38.16	3000.0
2009-07-22 07:00:00	QQQ	ETF	38.21	38.31	38.19	38.27	412004.0
2009-07-22 08:00:00	QQQ	ETF	38.28	38.3	38.09	38.12	1097004.0
2009-07-22 09:00:00	QQQ	ETF	38.12	38.5001	38.12	38.44	17619478.0
2009-07-22 10:00:00	QQQ	ETF	38.45	38.54	38.22	38.38	20694446.0
2009-07-22 11:00:00	QQQ	ETF	38.39	38.52	38.34	38.45	12746036.0
2009-07-22 12:00:00	QQQ	ETF	38.45	38.69	38.43	38.5795	13688500.0
2009-07-22 13:00:00	QQQ	ETF	38.5701	38.64	38.448	38.5099	8882019.0
2009-07-22 14:00:00	QQQ	ETF	38.502	38.57	38.4	38.56	10034401.0
2009-07-22 15:00:00	QQQ	ETF	38.55	38.59	38.36	38.4905	16902661.0
2009-07-22 16:00:00	QQQ	ETF	38.5	38.55	38.3	38.37	6720315.0
2009-07-22 17:00:00	QQQ	ETF	38.39	38.4	38.31	38.33	164066.0
2009-07-22 18:00:00	QQQ	ETF	38.32	38.33	38.3	38.33	133458.0
2009-07-22 19:00:00	QQQ	ETF	38.33	38.35	38.32	38.34	36569.0
2009-07-22 06:00:00	IWM	ETF	52.46	52.46	52.45	52.45	5000.0
2009-07-22 07:00:00	IWM	ETF	52.55	52.61	52.46	52.55	47446.0
2009-07-22 08:00:00	IWM	ETF	52.55	52.58	52.1	52.18	866966.0
2009-07-22 09:00:00	IWM	ETF	52.17	52.9101	52.14	52.75	6180469.0
2009-07-22 10:00:00	IWM	ETF	52.75	53.05	52.44	52.6799	8013027.0
2009-07-22 11:00:00	IWM	ETF	52.68	52.85	52.57	52.69	2736420.0
2009-07-22 12:00:00	IWM	ETF	52.69	53.21	52.67	53.08	7703103.0
2009-07-22 13:00:00	IWM	ETF	53.08	53.13	52.86	53.01	3581096.0
2009-07-22 14:00:00	IWM	ETF	53.03	53.08	52.85	52.97	5832552.0
2009-07-22 15:00:00	IWM	ETF	52.96	53.05	52.67	52.85	7451064.0
2009-07-22 16:00:00	IWM	ETF	52.85	52.89	52.5259	52.72	1726540.0
2009-07-22 17:00:00	IWM	ETF	52.72	52.72	52.65	52.65	14047.0
2009-07-22 18:00:00	IWM	ETF	52.68	52.68	52.63	52.64	2342.0
2009-07-22 19:00:00	IWM	ETF	52.65	52.71	52.65	52.7	3700.0
2009-07-22 04:00:00	DIA	ETF	88.76	88.76	88.76	88.76	100.0
2009-07-22 06:00:00	DIA	ETF	88.89	88.89	88.89	88.89	500.0
2009-07-22 07:00:00	DIA	ETF	88.94	89.03	88.9	89.02	4960.0
2009-07-22 08:00:00	DIA	ETF	89.02	89.04	88.58	88.73	145547.0
2009-07-22 09:00:00	DIA	ETF	88.78	89.36	88.69	89.2703	1820548.0

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

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