PREVIEW / etf_1hour / 2019-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-18.parquet
  size:    322 KB
  rows:    10,652

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-18 04:00:00	SPY	ETF	288.68	288.71	288.1	288.71	7838.0
2019-04-18 05:00:00	SPY	ETF	288.63	289.33	288.63	289.1	4512.0
2019-04-18 06:00:00	SPY	ETF	288.98	289.15	288.93	289.03	15458.0
2019-04-18 07:00:00	SPY	ETF	288.99	289.3	288.95	289.26	321616.0
2019-04-18 08:00:00	SPY	ETF	288.98	289.98	288.49	289.77	647377.0
2019-04-18 09:00:00	SPY	ETF	289.78	290.34	289.39	289.4	9490071.0
2019-04-18 10:00:00	SPY	ETF	289.405	289.45	288.66	289.33	12248484.0
2019-04-18 11:00:00	SPY	ETF	289.325	289.79	289.01	289.77	6112714.0
2019-04-18 12:00:00	SPY	ETF	289.775	290.13	289.72	289.86	4737278.0
2019-04-18 13:00:00	SPY	ETF	289.86	290.12	289.79	290.07	5442194.0
2019-04-18 14:00:00	SPY	ETF	290.06	290.26	289.91	290.215	4357840.0
2019-04-18 15:00:00	SPY	ETF	290.22	290.32	289.74	290.02	14323015.0
2019-04-18 16:00:00	SPY	ETF	290.01	290.21	289.5131	290.19	10302377.0
2019-04-18 17:00:00	SPY	ETF	290.17	290.19	290.04	290.13	88701.0
2019-04-18 18:00:00	SPY	ETF	290.14	290.14	290.12	290.13	7337.0
2019-04-18 19:00:00	SPY	ETF	290.14	290.14	290.07	290.1	18165.0
2019-04-18 04:00:00	QQQ	ETF	186.52	186.53	186.24	186.51	17092.0
2019-04-18 05:00:00	QQQ	ETF	186.48	186.85	186.47	186.82	21500.0
2019-04-18 06:00:00	QQQ	ETF	186.76	186.87	186.72	186.72	11000.0
2019-04-18 07:00:00	QQQ	ETF	186.75	186.87	186.68	186.87	131473.0
2019-04-18 08:00:00	QQQ	ETF	186.78	187.37	186.27	187.08	486548.0
2019-04-18 09:00:00	QQQ	ETF	187.11	187.67	186.73	186.75	4271341.0
2019-04-18 10:00:00	QQQ	ETF	186.755	186.93	186.29	186.88	4735990.0
2019-04-18 11:00:00	QQQ	ETF	186.89	187.1	186.71	187.0769	2554123.0
2019-04-18 12:00:00	QQQ	ETF	187.08	187.36	187.04	187.13	1252481.0
2019-04-18 13:00:00	QQQ	ETF	187.12	187.295	187.04	187.27	1383595.0
2019-04-18 14:00:00	QQQ	ETF	187.26	187.478	187.22	187.42	1406883.0
2019-04-18 15:00:00	QQQ	ETF	187.41	187.44	187.17	187.38	3744443.0
2019-04-18 16:00:00	QQQ	ETF	187.37	187.49	187.3	187.49	1653838.0
2019-04-18 17:00:00	QQQ	ETF	187.49	187.5	187.41	187.47	5506.0
2019-04-18 18:00:00	QQQ	ETF	187.45	187.47	187.45	187.47	1600.0
2019-04-18 19:00:00	QQQ	ETF	187.44	187.47	187.38	187.38	4617.0
2019-04-18 04:00:00	IWM	ETF	155.36	155.36	155.36	155.36	200.0
2019-04-18 05:00:00	IWM	ETF	155.77	155.89	155.77	155.88	700.0
2019-04-18 06:00:00	IWM	ETF	155.76	155.85	155.76	155.78	3840.0
2019-04-18 07:00:00	IWM	ETF	155.75	156.0	155.75	156.0	20800.0
2019-04-18 08:00:00	IWM	ETF	155.82	156.41	155.82	156.04	151575.0
2019-04-18 09:00:00	IWM	ETF	156.11	156.28	155.2	155.2	2069072.0
2019-04-18 10:00:00	IWM	ETF	155.2	155.38	154.66	155.22	3886899.0
2019-04-18 11:00:00	IWM	ETF	155.24	155.86	155.08	155.84	1874183.0
2019-04-18 12:00:00	IWM	ETF	155.84	156.16	155.84	155.905	1423329.0
2019-04-18 13:00:00	IWM	ETF	155.91	156.03	155.76	155.97	661194.0
2019-04-18 14:00:00	IWM	ETF	155.97	155.995	155.695	155.8975	901474.0
2019-04-18 15:00:00	IWM	ETF	155.9	155.92	155.48	155.67	3463958.0
2019-04-18 16:00:00	IWM	ETF	155.66	155.79	155.59	155.78	2828750.0
2019-04-18 17:00:00	IWM	ETF	155.67	155.76	155.65	155.76	1904745.0
2019-04-18 19:00:00	IWM	ETF	155.68	155.77	155.68	155.7	2000.0
2019-04-18 04:00:00	DIA	ETF	263.9	263.9	263.18	263.36	700.0
2019-04-18 05:00:00	DIA	ETF	263.62	263.63	263.62	263.63	300.0
2019-04-18 06:00:00	DIA	ETF	263.78	263.78	263.78	263.78	130.0

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

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