PREVIEW / etf_1hour / 2019-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-13.parquet
  size:    320 KB
  rows:    10,573

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-06-13 04:00:00	SPY	ETF	288.99	289.61	288.85	289.44	43762.0
2019-06-13 05:00:00	SPY	ETF	289.4	289.55	289.23	289.24	31257.0
2019-06-13 06:00:00	SPY	ETF	289.17	289.73	289.08	289.73	30763.0
2019-06-13 07:00:00	SPY	ETF	289.73	289.77	289.27	289.4	217346.0
2019-06-13 08:00:00	SPY	ETF	289.2901	289.73	287.71	289.42	598774.0
2019-06-13 09:00:00	SPY	ETF	289.42	289.98	289.15	289.7	5392732.0
2019-06-13 10:00:00	SPY	ETF	289.71	289.82	288.87	288.92	7345671.0
2019-06-13 11:00:00	SPY	ETF	288.92	289.36	288.62	289.27	4783474.0
2019-06-13 12:00:00	SPY	ETF	289.27	289.71	289.01	289.705	4257258.0
2019-06-13 13:00:00	SPY	ETF	289.705	289.89	289.37	289.555	4141334.0
2019-06-13 14:00:00	SPY	ETF	289.55	289.6	288.92	289.19	4123223.0
2019-06-13 15:00:00	SPY	ETF	289.19	289.74	288.62	289.65	12862862.0
2019-06-13 16:00:00	SPY	ETF	289.66	289.85	288.4052	289.78	3682388.0
2019-06-13 17:00:00	SPY	ETF	289.79	289.81	289.58	289.63	247813.0
2019-06-13 18:00:00	SPY	ETF	289.64	289.65	289.37	289.52	222088.0
2019-06-13 19:00:00	SPY	ETF	289.58	289.7	289.44	289.46	46067.0
2019-06-13 04:00:00	QQQ	ETF	182.84	183.38	182.78	183.3	33580.0
2019-06-13 05:00:00	QQQ	ETF	183.22	183.35	183.14	183.2	16198.0
2019-06-13 06:00:00	QQQ	ETF	183.09	183.5	183.0	183.5	48622.0
2019-06-13 07:00:00	QQQ	ETF	183.54	183.57	183.11	183.22	107164.0
2019-06-13 08:00:00	QQQ	ETF	183.38	183.5401	181.74	183.18	380272.0
2019-06-13 09:00:00	QQQ	ETF	183.18	183.85	182.9308	183.715	2905229.0
2019-06-13 10:00:00	QQQ	ETF	183.77	183.87	183.0899	183.12	3216486.0
2019-06-13 11:00:00	QQQ	ETF	183.11	183.41	182.8	183.32	1932149.0
2019-06-13 12:00:00	QQQ	ETF	183.33	183.5	182.99	183.42	1828650.0
2019-06-13 13:00:00	QQQ	ETF	183.43	183.53	183.2169	183.43	1201358.0
2019-06-13 14:00:00	QQQ	ETF	183.42	183.44	182.855	183.1134	1692036.0
2019-06-13 15:00:00	QQQ	ETF	183.08	183.49	182.74	183.45	4894866.0
2019-06-13 16:00:00	QQQ	ETF	183.45	183.63	183.17	183.27	1776190.0
2019-06-13 17:00:00	QQQ	ETF	183.28	183.3	182.85	182.85	110253.0
2019-06-13 18:00:00	QQQ	ETF	183.0	183.02	182.8	182.98	81270.0
2019-06-13 19:00:00	QQQ	ETF	182.98	183.09	182.86	182.86	75052.0
2019-06-13 04:00:00	IWM	ETF	152.0	152.11	152.0	152.08	4300.0
2019-06-13 05:00:00	IWM	ETF	152.08	152.18	152.08	152.1	4700.0
2019-06-13 06:00:00	IWM	ETF	152.03	152.23	152.01	152.23	19200.0
2019-06-13 07:00:00	IWM	ETF	152.28	152.33	152.14	152.23	24716.0
2019-06-13 08:00:00	IWM	ETF	152.29	152.33	152.0	152.3	25655.0
2019-06-13 09:00:00	IWM	ETF	152.28	152.98	152.145	152.62	2379390.0
2019-06-13 10:00:00	IWM	ETF	152.67	152.72	151.87	152.25	1454034.0
2019-06-13 11:00:00	IWM	ETF	152.24	152.9	152.13	152.8166	1134985.0
2019-06-13 12:00:00	IWM	ETF	152.81	153.18	152.7	153.12	1345424.0
2019-06-13 13:00:00	IWM	ETF	153.13	153.16	152.9	153.0584	879526.0
2019-06-13 14:00:00	IWM	ETF	153.05	153.14	152.77	152.9901	972421.0
2019-06-13 15:00:00	IWM	ETF	153.0	153.11	152.53	153.04	3465489.0
2019-06-13 16:00:00	IWM	ETF	153.02	153.16	152.99	153.07	1298036.0
2019-06-13 17:00:00	IWM	ETF	153.09	153.09	153.05	153.07	40815.0
2019-06-13 18:00:00	IWM	ETF	153.01	153.01	152.91	152.91	2569.0
2019-06-13 19:00:00	IWM	ETF	153.04	153.06	152.92	152.92	4468.0
2019-06-13 04:00:00	DIA	ETF	261.1	261.42	261.1	261.42	1100.0
2019-06-13 06:00:00	DIA	ETF	261.06	261.6	261.06	261.6	1890.0

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

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