PREVIEW / etf_1hour / 2019-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-11.parquet
  size:    326 KB
  rows:    10,795

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-11 04:00:00	SPY	ETF	308.11	308.11	307.67	307.78	51701.0
2019-11-11 05:00:00	SPY	ETF	307.81	307.81	307.54	307.62	68636.0
2019-11-11 06:00:00	SPY	ETF	307.67	307.92	307.52	307.81	90377.0
2019-11-11 07:00:00	SPY	ETF	307.78	307.85	307.63	307.71	217293.0
2019-11-11 08:00:00	SPY	ETF	307.71	308.04	307.51	307.62	244490.0
2019-11-11 09:00:00	SPY	ETF	307.62	308.02	307.27	308.01	6047052.0
2019-11-11 10:00:00	SPY	ETF	308.02	308.19	307.87	307.91	5552052.0
2019-11-11 11:00:00	SPY	ETF	307.91	308.12	307.84	308.11	3498462.0
2019-11-11 12:00:00	SPY	ETF	308.11	308.35	308.01	308.32	2893301.0
2019-11-11 13:00:00	SPY	ETF	308.33	308.54	308.29	308.505	2630839.0
2019-11-11 14:00:00	SPY	ETF	308.5	308.51	308.3	308.39	2885294.0
2019-11-11 15:00:00	SPY	ETF	308.4	308.495	308.11	308.39	4999291.0
2019-11-11 16:00:00	SPY	ETF	308.37	308.6	308.1533	308.58	6042688.0
2019-11-11 17:00:00	SPY	ETF	308.51	308.54	308.47	308.5	42248.0
2019-11-11 18:00:00	SPY	ETF	308.55	308.59	308.33	308.33	117555.0
2019-11-11 19:00:00	SPY	ETF	308.34	308.46	308.17	308.42	40720.0
2019-11-11 04:00:00	QQQ	ETF	200.4	200.4	200.18	200.28	10399.0
2019-11-11 05:00:00	QQQ	ETF	200.25	200.33	200.16	200.2	7920.0
2019-11-11 06:00:00	QQQ	ETF	200.24	200.33	200.16	200.28	11235.0
2019-11-11 07:00:00	QQQ	ETF	200.27	200.35	200.21	200.32	53866.0
2019-11-11 08:00:00	QQQ	ETF	200.25	200.56	200.21	200.36	87905.0
2019-11-11 09:00:00	QQQ	ETF	200.36	200.4696	199.94	200.455	1890259.0
2019-11-11 10:00:00	QQQ	ETF	200.46	200.81	200.3	200.58	1301421.0
2019-11-11 11:00:00	QQQ	ETF	200.58	200.73	200.51	200.685	701051.0
2019-11-11 12:00:00	QQQ	ETF	200.69	200.88	200.58	200.85	801762.0
2019-11-11 13:00:00	QQQ	ETF	200.855	201.0363	200.81	201.0	627607.0
2019-11-11 14:00:00	QQQ	ETF	201.0	201.0046	200.84	200.94	497065.0
2019-11-11 15:00:00	QQQ	ETF	200.94	201.03	200.73	200.96	1511181.0
2019-11-11 16:00:00	QQQ	ETF	200.95	201.08	200.89	201.06	922643.0
2019-11-11 17:00:00	QQQ	ETF	201.07	201.08	201.01	201.02	9310.0
2019-11-11 18:00:00	QQQ	ETF	201.09	201.14	200.85	200.85	23951.0
2019-11-11 19:00:00	QQQ	ETF	200.85	200.95	200.73	200.94	18378.0
2019-11-11 04:00:00	IWM	ETF	158.5	158.5	158.41	158.41	2100.0
2019-11-11 05:00:00	IWM	ETF	158.33	158.33	158.21	158.25	7000.0
2019-11-11 06:00:00	IWM	ETF	158.34	158.34	158.1	158.25	5339.0
2019-11-11 07:00:00	IWM	ETF	158.25	158.3	158.23	158.3	14400.0
2019-11-11 08:00:00	IWM	ETF	158.22	158.3	158.13	158.16	37321.0
2019-11-11 09:00:00	IWM	ETF	158.13	158.48	157.88	158.37	1186912.0
2019-11-11 10:00:00	IWM	ETF	158.38	158.9	158.32	158.56	1003916.0
2019-11-11 11:00:00	IWM	ETF	158.56	158.59	158.11	158.37	974597.0
2019-11-11 12:00:00	IWM	ETF	158.37	158.5	158.3	158.42	488979.0
2019-11-11 13:00:00	IWM	ETF	158.415	158.71	158.39	158.705	472509.0
2019-11-11 14:00:00	IWM	ETF	158.72	158.785	158.595	158.6505	365766.0
2019-11-11 15:00:00	IWM	ETF	158.66	158.76	158.48	158.73	1686779.0
2019-11-11 16:00:00	IWM	ETF	158.74	158.9427	158.74	158.93	1166906.0
2019-11-11 17:00:00	IWM	ETF	158.88	158.88	158.81	158.81	1000.0
2019-11-11 18:00:00	IWM	ETF	158.83	158.83	158.76	158.76	13200.0
2019-11-11 19:00:00	IWM	ETF	158.72	158.87	158.72	158.85	3677.0
2019-11-11 04:00:00	DIA	ETF	276.1	276.1	276.1	276.1	100.0
2019-11-11 05:00:00	DIA	ETF	275.72	275.76	275.66	275.76	1000.0

> showing 50 of 10,795 rows — these rows as CSV

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