PREVIEW / etf_1hour / 2019-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-02.parquet
  size:    317 KB
  rows:    10,575

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-04-02 04:00:00	SPY	ETF	285.45	285.68	285.45	285.55	34069.0
2019-04-02 05:00:00	SPY	ETF	285.55	285.86	285.5	285.86	6810.0
2019-04-02 06:00:00	SPY	ETF	285.77	285.98	285.77	285.95	13803.0
2019-04-02 07:00:00	SPY	ETF	285.96	286.11	285.92	286.09	80870.0
2019-04-02 08:00:00	SPY	ETF	285.9799	286.23	285.35	286.06	367931.0
2019-04-02 09:00:00	SPY	ETF	286.07	286.07	285.55	285.949	5522875.0
2019-04-02 10:00:00	SPY	ETF	285.945	286.02	285.42	285.64	5783365.0
2019-04-02 11:00:00	SPY	ETF	285.64	285.91	285.09	285.8	6540881.0
2019-04-02 12:00:00	SPY	ETF	285.8	285.94	285.45	285.68	4932400.0
2019-04-02 13:00:00	SPY	ETF	285.67	285.95	285.54	285.77	3369655.0
2019-04-02 14:00:00	SPY	ETF	285.775	286.01	285.71	286.01	2881772.0
2019-04-02 15:00:00	SPY	ETF	286.0	286.23	285.93	285.98	7867894.0
2019-04-02 16:00:00	SPY	ETF	285.98	285.99	285.47	285.49	2029122.0
2019-04-02 17:00:00	SPY	ETF	285.48	285.97	285.41	285.5	129526.0
2019-04-02 18:00:00	SPY	ETF	285.51	285.67	285.51	285.62	68590.0
2019-04-02 19:00:00	SPY	ETF	285.61	285.64	285.5	285.53	47075.0
2019-04-02 04:00:00	QQQ	ETF	181.92	181.95	181.87	181.91	5600.0
2019-04-02 05:00:00	QQQ	ETF	181.96	182.03	181.89	182.03	40150.0
2019-04-02 06:00:00	QQQ	ETF	182.03	182.14	181.97	182.09	23278.0
2019-04-02 07:00:00	QQQ	ETF	182.08	182.26	182.05	182.22	28616.0
2019-04-02 08:00:00	QQQ	ETF	182.14	182.4	181.81	182.27	139583.0
2019-04-02 09:00:00	QQQ	ETF	182.27	182.32	181.83	181.96	2865265.0
2019-04-02 10:00:00	QQQ	ETF	181.96	182.54	181.78	182.44	3738386.0
2019-04-02 11:00:00	QQQ	ETF	182.435	182.5	181.91	182.38	3068088.0
2019-04-02 12:00:00	QQQ	ETF	182.39	182.51	182.19	182.39	1974273.0
2019-04-02 13:00:00	QQQ	ETF	182.3864	182.6	182.2714	182.56	1314957.0
2019-04-02 14:00:00	QQQ	ETF	182.56	182.71	182.46	182.7	1283997.0
2019-04-02 15:00:00	QQQ	ETF	182.7067	182.905	182.695	182.73	4107729.0
2019-04-02 16:00:00	QQQ	ETF	182.73	182.77	182.1899	182.52	1119247.0
2019-04-02 17:00:00	QQQ	ETF	182.52	182.56	182.51	182.54	12563.0
2019-04-02 18:00:00	QQQ	ETF	182.53	182.64	182.53	182.63	34974.0
2019-04-02 19:00:00	QQQ	ETF	182.58	182.63	182.5	182.54	24980.0
2019-04-02 04:00:00	IWM	ETF	154.55	154.55	154.55	154.55	1000.0
2019-04-02 05:00:00	IWM	ETF	154.65	154.68	154.65	154.68	7000.0
2019-04-02 06:00:00	IWM	ETF	154.69	154.8	154.69	154.8	13000.0
2019-04-02 07:00:00	IWM	ETF	154.81	154.85	154.72	154.72	12000.0
2019-04-02 08:00:00	IWM	ETF	154.79	154.95	154.44	154.88	19745.0
2019-04-02 09:00:00	IWM	ETF	154.9	154.9	153.78	154.18	2059073.0
2019-04-02 10:00:00	IWM	ETF	154.17	154.63	153.96	154.19	2629367.0
2019-04-02 11:00:00	IWM	ETF	154.18	154.57	153.5072	154.43	2234678.0
2019-04-02 12:00:00	IWM	ETF	154.42	154.55	153.79	153.9985	1697201.0
2019-04-02 13:00:00	IWM	ETF	154.005	154.35	153.82	154.14	989998.0
2019-04-02 14:00:00	IWM	ETF	154.14	154.33	154.07	154.305	866169.0
2019-04-02 15:00:00	IWM	ETF	154.3	154.565	154.28	154.36	3484933.0
2019-04-02 16:00:00	IWM	ETF	154.35	154.4646	154.0	154.01	767566.0
2019-04-02 17:00:00	IWM	ETF	154.03	154.36	154.01	154.06	75714.0
2019-04-02 18:00:00	IWM	ETF	154.06	154.17	154.06	154.14	9308.0
2019-04-02 19:00:00	IWM	ETF	154.13	154.14	154.08	154.11	7098.0
2019-04-02 05:00:00	DIA	ETF	262.24	262.24	262.24	262.24	100.0
2019-04-02 06:00:00	DIA	ETF	262.4	262.4	262.4	262.4	600.0

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

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