PREVIEW / etf_1hour / 2009-05-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-18.parquet
  size:    137 KB
  rows:    4,185

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-18 04:00:00	SPY	ETF	88.65	88.76	88.55	88.76	3300.0
2009-05-18 05:00:00	SPY	ETF	88.93	89.35	88.9	89.19	27100.0
2009-05-18 06:00:00	SPY	ETF	89.19	89.25	89.0	89.13	72225.0
2009-05-18 07:00:00	SPY	ETF	89.11	89.64	89.1	89.48	1169221.0
2009-05-18 08:00:00	SPY	ETF	89.47	89.61	88.76	89.46	3472922.0
2009-05-18 09:00:00	SPY	ETF	89.46	89.88	88.4925	89.62	27653019.0
2009-05-18 10:00:00	SPY	ETF	89.62	90.21	89.37	90.14	35731229.0
2009-05-18 11:00:00	SPY	ETF	90.15	90.3	90.0091	90.09	24839928.0
2009-05-18 12:00:00	SPY	ETF	90.09	90.63	90.07	90.56	20896360.0
2009-05-18 13:00:00	SPY	ETF	90.57	90.605	89.77	90.34	17558385.0
2009-05-18 14:00:00	SPY	ETF	90.34	90.85	90.19	90.8	24287302.0
2009-05-18 15:00:00	SPY	ETF	90.8099	91.34	90.55	91.25	43928943.0
2009-05-18 16:00:00	SPY	ETF	91.26	91.33	90.2	91.21	17679934.0
2009-05-18 17:00:00	SPY	ETF	91.23	91.24	90.2281	91.22	264139.0
2009-05-18 18:00:00	SPY	ETF	91.22	91.2806	89.38	91.22	699959.0
2009-05-18 19:00:00	SPY	ETF	91.24	91.26	91.18	91.25	74590.0
2009-05-18 04:00:00	QQQ	ETF	33.3	33.3	33.26	33.26	200.0
2009-05-18 05:00:00	QQQ	ETF	33.5	33.52	33.5	33.5	400.0
2009-05-18 06:00:00	QQQ	ETF	33.47	33.48	33.43	33.43	300.0
2009-05-18 07:00:00	QQQ	ETF	33.48	33.67	33.47	33.63	598447.0
2009-05-18 08:00:00	QQQ	ETF	33.62	33.65	33.52	33.56	1617208.0
2009-05-18 09:00:00	QQQ	ETF	33.56	33.73	33.51	33.59	14757459.0
2009-05-18 10:00:00	QQQ	ETF	33.58	33.77	33.3901	33.7386	17832058.0
2009-05-18 11:00:00	QQQ	ETF	33.73	33.77	33.6	33.68	9167228.0
2009-05-18 12:00:00	QQQ	ETF	33.69	34.02	33.68	33.97	12356005.0
2009-05-18 13:00:00	QQQ	ETF	33.96	33.98	33.88	33.92	8197529.0
2009-05-18 14:00:00	QQQ	ETF	33.92	34.2	33.88	34.18	11424680.0
2009-05-18 15:00:00	QQQ	ETF	34.18	34.28	34.06	34.24	20484745.0
2009-05-18 16:00:00	QQQ	ETF	34.24	34.29	33.3485	34.22	7010493.0
2009-05-18 17:00:00	QQQ	ETF	34.22	34.27	34.19	34.22	5754527.0
2009-05-18 18:00:00	QQQ	ETF	34.22	34.22	34.2	34.22	18200.0
2009-05-18 19:00:00	QQQ	ETF	34.2	34.23	34.2	34.23	10826.0
2009-05-18 20:00:00	QQQ	ETF	34.23	34.23	34.23	34.23	1800.0
2009-05-18 06:00:00	IWM	ETF	48.0	48.05	48.0	48.05	400.0
2009-05-18 07:00:00	IWM	ETF	48.08	48.38	48.07	48.37	302183.0
2009-05-18 08:00:00	IWM	ETF	48.35	48.39	48.05	48.32	1757205.0
2009-05-18 09:00:00	IWM	ETF	48.32	48.66	48.21	48.4	7353581.0
2009-05-18 10:00:00	IWM	ETF	48.4	48.85	48.11	48.72	7984358.0
2009-05-18 11:00:00	IWM	ETF	48.72	48.76	48.43	48.58	4745185.0
2009-05-18 12:00:00	IWM	ETF	48.59	49.02	48.5722	48.94	4015689.0
2009-05-18 13:00:00	IWM	ETF	48.94	48.97	48.73	48.88	3418276.0
2009-05-18 14:00:00	IWM	ETF	48.89	49.37	48.79	49.29	5845383.0
2009-05-18 15:00:00	IWM	ETF	49.29	49.57	49.12	49.4	12036082.0
2009-05-18 16:00:00	IWM	ETF	49.4	49.6	49.35	49.44	2256048.0
2009-05-18 17:00:00	IWM	ETF	49.43	49.52	49.36	49.52	5683.0
2009-05-18 18:00:00	IWM	ETF	49.45	49.46	49.45	49.46	900.0
2009-05-18 19:00:00	IWM	ETF	49.41	49.41	49.34	49.34	2000.0
2009-05-18 05:00:00	DIA	ETF	83.05	83.33	83.05	83.33	500.0
2009-05-18 06:00:00	DIA	ETF	83.14	83.18	83.08	83.12	3598.0
2009-05-18 07:00:00	DIA	ETF	83.17	83.51	83.16	83.46	8502.0

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

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