PREVIEW / etf_1hour / 2009-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-22.parquet
  size:    133 KB
  rows:    4,098

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-22 04:00:00	SPY	ETF	89.69	89.99	89.69	89.9	8700.0
2009-05-22 05:00:00	SPY	ETF	89.96	90.02	89.94	90.02	5200.0
2009-05-22 06:00:00	SPY	ETF	90.02	90.02	89.9	89.92	53800.0
2009-05-22 07:00:00	SPY	ETF	89.95	89.99	89.62	89.68	603020.0
2009-05-22 08:00:00	SPY	ETF	89.933	89.99	89.61	89.71	1555523.0
2009-05-22 09:00:00	SPY	ETF	89.71	89.73	88.68	88.98	26831493.0
2009-05-22 10:00:00	SPY	ETF	88.99	89.84	88.85	89.7194	35805991.0
2009-05-22 11:00:00	SPY	ETF	89.71	89.92	89.46	89.57	19551370.0
2009-05-22 12:00:00	SPY	ETF	89.56	89.81	89.37	89.715	15119404.0
2009-05-22 13:00:00	SPY	ETF	89.7001	89.835	89.35	89.61	16518470.0
2009-05-22 14:00:00	SPY	ETF	89.61	89.89	89.5	89.87	15139456.0
2009-05-22 15:00:00	SPY	ETF	89.87	90.0	89.01	89.05	27136507.0
2009-05-22 16:00:00	SPY	ETF	89.01	89.35	88.8	89.03	7278886.0
2009-05-22 17:00:00	SPY	ETF	89.02	89.05	88.94	88.96	76022.0
2009-05-22 18:00:00	SPY	ETF	88.96	88.96	88.9	88.94	14226.0
2009-05-22 19:00:00	SPY	ETF	88.95	89.0	88.94	88.97	34878.0
2009-05-22 04:00:00	QQQ	ETF	33.89	33.97	33.87	33.93	1500.0
2009-05-22 05:00:00	QQQ	ETF	33.94	33.98	33.93	33.93	5400.0
2009-05-22 06:00:00	QQQ	ETF	33.95	33.96	33.93	33.93	10100.0
2009-05-22 07:00:00	QQQ	ETF	33.95	33.97	33.82	33.86	284740.0
2009-05-22 08:00:00	QQQ	ETF	33.83	33.98	33.8	33.82	263242.0
2009-05-22 09:00:00	QQQ	ETF	33.82	33.82	33.32	33.51	15416394.0
2009-05-22 10:00:00	QQQ	ETF	33.51	33.79	33.44	33.74	14305779.0
2009-05-22 11:00:00	QQQ	ETF	33.74	33.87	33.68	33.74	7064230.0
2009-05-22 12:00:00	QQQ	ETF	33.74	33.86	33.65	33.84	7000943.0
2009-05-22 13:00:00	QQQ	ETF	33.84	33.88	33.68	33.78	8478847.0
2009-05-22 14:00:00	QQQ	ETF	33.79	33.92	33.74	33.91	7754035.0
2009-05-22 15:00:00	QQQ	ETF	33.91	33.97	33.56	33.57	15299603.0
2009-05-22 16:00:00	QQQ	ETF	33.56	33.77	33.43	33.5	4014607.0
2009-05-22 17:00:00	QQQ	ETF	33.5	33.52	33.48	33.51	22511.0
2009-05-22 18:00:00	QQQ	ETF	33.52	33.52	33.48	33.5	4900.0
2009-05-22 19:00:00	QQQ	ETF	33.51	33.52	33.5	33.51	4980.0
2009-05-22 04:00:00	IWM	ETF	48.65	48.66	48.65	48.66	600.0
2009-05-22 06:00:00	IWM	ETF	48.72	48.72	48.72	48.72	100.0
2009-05-22 07:00:00	IWM	ETF	48.73	48.74	48.51	48.59	61600.0
2009-05-22 08:00:00	IWM	ETF	48.57	48.84	48.53	48.62	298100.0
2009-05-22 09:00:00	IWM	ETF	48.63	48.66	47.83	48.11	5287242.0
2009-05-22 10:00:00	IWM	ETF	48.12	48.51	47.97	48.41	6888209.0
2009-05-22 11:00:00	IWM	ETF	48.42	48.5	48.17	48.25	2742839.0
2009-05-22 12:00:00	IWM	ETF	48.25	48.41	48.0	48.27	4414894.0
2009-05-22 13:00:00	IWM	ETF	48.27	48.35	48.02	48.18	4645151.0
2009-05-22 14:00:00	IWM	ETF	48.18	48.4	48.11	48.39	2239822.0
2009-05-22 15:00:00	IWM	ETF	48.39	48.44	47.8	47.8	5366335.0
2009-05-22 16:00:00	IWM	ETF	47.79	48.189	47.57	47.95	3261152.0
2009-05-22 18:00:00	IWM	ETF	47.84	47.87	47.84	47.85	2500.0
2009-05-22 19:00:00	IWM	ETF	47.81	47.86	47.8	47.85	17500.0
2009-05-22 06:00:00	DIA	ETF	83.66	83.66	83.66	83.66	500.0
2009-05-22 07:00:00	DIA	ETF	83.7	83.73	83.47	83.54	4100.0
2009-05-22 08:00:00	DIA	ETF	83.48	83.74	83.44	83.55	25650.0
2009-05-22 09:00:00	DIA	ETF	83.54	83.54	82.66	82.881	1668968.0

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

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