PREVIEW / etf_1hour / 2019-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-15.parquet
  size:    339 KB
  rows:    11,153

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
2019-11-15 04:00:00	SPY	ETF	310.38	310.64	310.32	310.6	27748.0
2019-11-15 05:00:00	SPY	ETF	310.6	310.6	310.21	310.25	44313.0
2019-11-15 06:00:00	SPY	ETF	310.27	310.35	310.17	310.32	11505.0
2019-11-15 07:00:00	SPY	ETF	310.3	310.59	310.3	310.45	185961.0
2019-11-15 08:00:00	SPY	ETF	310.43	310.7	310.29	310.67	153790.0
2019-11-15 09:00:00	SPY	ETF	310.67	311.04	310.26	310.31	5207018.0
2019-11-15 10:00:00	SPY	ETF	310.31	310.94	310.29	310.89	8772844.0
2019-11-15 11:00:00	SPY	ETF	310.89	311.46	310.89	311.2537	9651053.0
2019-11-15 12:00:00	SPY	ETF	311.25	311.45	311.195	311.245	3039626.0
2019-11-15 13:00:00	SPY	ETF	311.245	311.29	311.08	311.145	3668693.0
2019-11-15 14:00:00	SPY	ETF	311.14	311.52	311.11	311.49	3506474.0
2019-11-15 15:00:00	SPY	ETF	311.49	311.83	311.09	311.83	13503056.0
2019-11-15 16:00:00	SPY	ETF	311.82	311.8902	311.62	311.81	12913955.0
2019-11-15 17:00:00	SPY	ETF	311.8	311.8	311.67	311.73	123775.0
2019-11-15 18:00:00	SPY	ETF	311.73	311.74	311.65	311.71	685742.0
2019-11-15 19:00:00	SPY	ETF	311.66	311.77	311.66	311.68	26843.0
2019-11-15 04:00:00	QQQ	ETF	202.02	202.25	201.99	202.25	32077.0
2019-11-15 05:00:00	QQQ	ETF	202.28	202.28	201.96	201.97	34430.0
2019-11-15 06:00:00	QQQ	ETF	201.99	202.1	201.92	202.07	16850.0
2019-11-15 07:00:00	QQQ	ETF	202.08	202.31	202.05	202.21	98983.0
2019-11-15 08:00:00	QQQ	ETF	202.1601	202.54	201.43	202.53	85156.0
2019-11-15 09:00:00	QQQ	ETF	202.51	202.76	202.0	202.02	1852475.0
2019-11-15 10:00:00	QQQ	ETF	202.015	202.58	202.01	202.51	1846417.0
2019-11-15 11:00:00	QQQ	ETF	202.52	202.805	202.4119	202.5065	1790100.0
2019-11-15 12:00:00	QQQ	ETF	202.51	202.65	202.4	202.58	1082822.0
2019-11-15 13:00:00	QQQ	ETF	202.58	202.62	202.46	202.51	700774.0
2019-11-15 14:00:00	QQQ	ETF	202.51	202.67	202.4	202.5	847074.0
2019-11-15 15:00:00	QQQ	ETF	202.51	202.72	202.2	202.72	3162396.0
2019-11-15 16:00:00	QQQ	ETF	202.72	202.91	202.63	202.79	1204796.0
2019-11-15 17:00:00	QQQ	ETF	202.84	202.91	202.6	202.7	272187.0
2019-11-15 18:00:00	QQQ	ETF	202.71	202.74	202.65	202.65	4318.0
2019-11-15 19:00:00	QQQ	ETF	202.7	202.75	202.65	202.75	2309.0
2019-11-15 04:00:00	IWM	ETF	158.75	158.88	158.75	158.81	3400.0
2019-11-15 05:00:00	IWM	ETF	158.8	158.8	158.5	158.5	5657.0
2019-11-15 06:00:00	IWM	ETF	158.5	158.64	158.5	158.64	6604.0
2019-11-15 07:00:00	IWM	ETF	158.6	158.85	158.6	158.85	25450.0
2019-11-15 08:00:00	IWM	ETF	158.75	159.0	158.7	158.91	110695.0
2019-11-15 09:00:00	IWM	ETF	158.9301	159.29	158.53	158.585	1205622.0
2019-11-15 10:00:00	IWM	ETF	158.57	158.69	158.35	158.5	1269969.0
2019-11-15 11:00:00	IWM	ETF	158.5	159.02	158.5	158.95	1069644.0
2019-11-15 12:00:00	IWM	ETF	158.95	159.1463	158.8201	158.88	900473.0
2019-11-15 13:00:00	IWM	ETF	158.88	159.1	158.82	158.8845	678287.0
2019-11-15 14:00:00	IWM	ETF	158.88	159.06	158.865	158.99	687894.0
2019-11-15 15:00:00	IWM	ETF	158.99	159.05	158.73	158.92	2271635.0
2019-11-15 16:00:00	IWM	ETF	158.92	159.01	158.86	158.99	1238610.0
2019-11-15 17:00:00	IWM	ETF	158.95	159.01	158.86	158.86	25326.0
2019-11-15 18:00:00	IWM	ETF	158.92	158.92	158.86	158.92	1202.0
2019-11-15 19:00:00	IWM	ETF	158.92	158.92	158.92	158.92	1300.0
2019-11-15 04:00:00	DIA	ETF	278.57	278.57	278.49	278.49	1500.0
2019-11-15 05:00:00	DIA	ETF	278.48	278.48	278.48	278.48	100.0

> showing 50 of 11,153 rows — these rows as CSV

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