PREVIEW / etf_1hour / 2009-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-05.parquet
  size:    135 KB
  rows:    4,203

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-05-05 04:00:00	SPY	ETF	90.39	90.69	90.35	90.69	5075.0
2009-05-05 05:00:00	SPY	ETF	90.67	90.97	90.67	90.89	24101.0
2009-05-05 06:00:00	SPY	ETF	90.83	90.84	90.71	90.77	33670.0
2009-05-05 07:00:00	SPY	ETF	90.79	90.85	90.32	90.39	876441.0
2009-05-05 08:00:00	SPY	ETF	90.39	90.54	90.28	90.4	1581715.0
2009-05-05 09:00:00	SPY	ETF	90.4	90.93	90.37	90.67	31076422.0
2009-05-05 10:00:00	SPY	ETF	90.67	90.9	89.88	89.8874	49686666.0
2009-05-05 11:00:00	SPY	ETF	89.8801	90.46	89.88	90.35	27363300.0
2009-05-05 12:00:00	SPY	ETF	90.35	90.46	90.08	90.205	14875256.0
2009-05-05 13:00:00	SPY	ETF	90.2	90.41	89.97	90.21	22112194.0
2009-05-05 14:00:00	SPY	ETF	90.218	90.39	89.84	90.06	28333718.0
2009-05-05 15:00:00	SPY	ETF	90.06	90.69	90.03	90.51	53323534.0
2009-05-05 16:00:00	SPY	ETF	90.52	90.85	90.08	90.79	12519260.0
2009-05-05 17:00:00	SPY	ETF	90.81	90.87	90.76	90.83	179177.0
2009-05-05 18:00:00	SPY	ETF	90.84	90.91	90.75	90.86	65925.0
2009-05-05 19:00:00	SPY	ETF	90.85	90.85	90.73	90.76	49093.0
2009-05-05 04:00:00	QQQ	ETF	35.0	35.06	35.0	35.06	200.0
2009-05-05 05:00:00	QQQ	ETF	35.08	35.12	35.08	35.09	400.0
2009-05-05 06:00:00	QQQ	ETF	35.05	35.09	35.05	35.09	5478.0
2009-05-05 07:00:00	QQQ	ETF	35.09	35.09	34.94	34.97	396209.0
2009-05-05 08:00:00	QQQ	ETF	34.95	35.0	34.93	34.97	761301.0
2009-05-05 09:00:00	QQQ	ETF	34.97	35.06	34.8	34.92	16464732.0
2009-05-05 10:00:00	QQQ	ETF	34.92	34.98	34.65	34.6522	18716041.0
2009-05-05 11:00:00	QQQ	ETF	34.66	34.87	34.65	34.8	13008955.0
2009-05-05 12:00:00	QQQ	ETF	34.81	34.86	34.73	34.77	5758508.0
2009-05-05 13:00:00	QQQ	ETF	34.77	34.86	34.7	34.81	9331847.0
2009-05-05 14:00:00	QQQ	ETF	34.82	34.9	34.63	34.73	20673143.0
2009-05-05 15:00:00	QQQ	ETF	34.73	35.06	34.72	35.02	21086863.0
2009-05-05 16:00:00	QQQ	ETF	35.02	35.16	35.02	35.13	4430850.0
2009-05-05 17:00:00	QQQ	ETF	35.13	35.14	35.09	35.12	48812.0
2009-05-05 18:00:00	QQQ	ETF	35.12	35.14	35.11	35.14	14635.0
2009-05-05 19:00:00	QQQ	ETF	35.12	35.13	35.1	35.13	58467.0
2009-05-05 06:00:00	IWM	ETF	50.58	50.58	50.58	50.58	3000.0
2009-05-05 07:00:00	IWM	ETF	50.45	50.46	50.23	50.29	130646.0
2009-05-05 08:00:00	IWM	ETF	50.28	50.49	50.26	50.3	220300.0
2009-05-05 09:00:00	IWM	ETF	50.31	50.612	50.15	50.26	5208282.0
2009-05-05 10:00:00	IWM	ETF	50.28	50.45	49.64	49.64	9708451.0
2009-05-05 11:00:00	IWM	ETF	49.63	50.13	49.63	49.96	5381478.0
2009-05-05 12:00:00	IWM	ETF	49.96	50.01	49.8	49.92	3715109.0
2009-05-05 13:00:00	IWM	ETF	49.92	50.01	49.76	49.94	3535926.0
2009-05-05 14:00:00	IWM	ETF	49.93	50.07	49.67	49.88	7663071.0
2009-05-05 15:00:00	IWM	ETF	49.87	50.4	49.8	50.24	11720928.0
2009-05-05 16:00:00	IWM	ETF	50.25	50.7019	49.95	50.2121	4864043.0
2009-05-05 17:00:00	IWM	ETF	50.45	50.54	50.39	50.49	7641.0
2009-05-05 06:00:00	DIA	ETF	84.16	84.2	84.16	84.17	600.0
2009-05-05 07:00:00	DIA	ETF	84.13	84.13	83.83	83.85	13321.0
2009-05-05 08:00:00	DIA	ETF	83.89	83.94	83.8	83.84	46952.0
2009-05-05 09:00:00	DIA	ETF	83.88	84.42	83.88	84.38	1988941.0
2009-05-05 10:00:00	DIA	ETF	84.38	84.56	83.75	83.76	3020445.0
2009-05-05 11:00:00	DIA	ETF	83.75	84.19	83.75	84.08	1378554.0

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

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