PREVIEW / etf_1hour / 2019-08-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-12.parquet
  size:    329 KB
  rows:    10,882

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-08-12 04:00:00	SPY	ETF	292.29	292.3	290.26	290.54	49781.0
2019-08-12 05:00:00	SPY	ETF	290.6	290.67	290.13	290.3	30668.0
2019-08-12 06:00:00	SPY	ETF	290.28	290.33	289.35	289.98	54048.0
2019-08-12 07:00:00	SPY	ETF	290.01	290.12	289.05	289.63	288598.0
2019-08-12 08:00:00	SPY	ETF	289.65	292.75	289.13	290.14	718037.0
2019-08-12 09:00:00	SPY	ETF	290.15	290.41	289.13	289.4	6964989.0
2019-08-12 10:00:00	SPY	ETF	289.4	290.57	289.09	289.83	9229344.0
2019-08-12 11:00:00	SPY	ETF	289.82	289.83	288.59	289.51	7685271.0
2019-08-12 12:00:00	SPY	ETF	289.51	290.03	289.01	289.24	4362221.0
2019-08-12 13:00:00	SPY	ETF	289.25	289.38	288.36	288.49	4642453.0
2019-08-12 14:00:00	SPY	ETF	288.49	291.6052	287.02	287.36	11358031.0
2019-08-12 15:00:00	SPY	ETF	287.3784	291.6052	287.2665	288.1	11678646.0
2019-08-12 16:00:00	SPY	ETF	288.11	288.19	287.65	287.99	2105715.0
2019-08-12 17:00:00	SPY	ETF	288.05	288.05	287.9	287.9	12852.0
2019-08-12 18:00:00	SPY	ETF	288.01	288.24	287.85	288.23	22317.0
2019-08-12 19:00:00	SPY	ETF	288.05	288.09	287.68	287.68	2700.0
2019-08-12 20:00:00	SPY	ETF	288.16	288.4	287.64	288.34	3292284.0
2019-08-12 04:00:00	QQQ	ETF	187.5	187.5	185.55	185.81	35893.0
2019-08-12 05:00:00	QQQ	ETF	185.87	186.0	185.5	185.71	29934.0
2019-08-12 06:00:00	QQQ	ETF	185.63	185.66	184.86	185.32	44439.0
2019-08-12 07:00:00	QQQ	ETF	185.38	185.54	184.7	185.09	143611.0
2019-08-12 08:00:00	QQQ	ETF	185.52	187.55	184.7401	185.42	247796.0
2019-08-12 09:00:00	QQQ	ETF	185.41	185.78	184.63	185.01	3075047.0
2019-08-12 10:00:00	QQQ	ETF	185.01	185.85	184.7001	185.47	3140438.0
2019-08-12 11:00:00	QQQ	ETF	185.47	185.71	184.57	185.54	2308448.0
2019-08-12 12:00:00	QQQ	ETF	185.5339	185.9	185.17	185.36	1837609.0
2019-08-12 13:00:00	QQQ	ETF	185.34	185.47	184.74	184.84	1284346.0
2019-08-12 14:00:00	QQQ	ETF	184.82	184.9256	183.5	183.75	3633054.0
2019-08-12 15:00:00	QQQ	ETF	183.74	184.51	183.67	184.36	4982030.0
2019-08-12 16:00:00	QQQ	ETF	184.36	184.42	184.13	184.41	1061383.0
2019-08-12 17:00:00	QQQ	ETF	184.42	184.45	184.25	184.29	411899.0
2019-08-12 18:00:00	QQQ	ETF	184.32	184.53	184.26	184.5	54412.0
2019-08-12 19:00:00	QQQ	ETF	184.48	184.62	184.37	184.62	33940.0
2019-08-12 04:00:00	IWM	ETF	150.99	150.99	150.0	150.0	8000.0
2019-08-12 05:00:00	IWM	ETF	149.99	149.99	149.8	149.8	1100.0
2019-08-12 06:00:00	IWM	ETF	149.9	149.94	149.53	149.59	8100.0
2019-08-12 07:00:00	IWM	ETF	149.64	149.87	149.33	149.62	19277.0
2019-08-12 08:00:00	IWM	ETF	149.4	151.14	149.34	149.99	63944.0
2019-08-12 09:00:00	IWM	ETF	149.99	150.12	148.88	148.98	2910611.0
2019-08-12 10:00:00	IWM	ETF	148.978	149.585	148.79	149.54	2554893.0
2019-08-12 11:00:00	IWM	ETF	149.53	149.56	148.95	149.24	1546902.0
2019-08-12 12:00:00	IWM	ETF	149.23	149.47	149.03	149.225	1000028.0
2019-08-12 13:00:00	IWM	ETF	149.22	149.3	148.67	148.86	1017092.0
2019-08-12 14:00:00	IWM	ETF	148.83	149.02	148.33	148.45	1735326.0
2019-08-12 15:00:00	IWM	ETF	148.46	148.8699	148.42	148.64	2121537.0
2019-08-12 16:00:00	IWM	ETF	148.66	148.68	148.43	148.5	704950.0
2019-08-12 19:00:00	IWM	ETF	148.68	148.68	148.68	148.68	100.0
2019-08-12 04:00:00	DIA	ETF	262.56	262.56	262.18	262.18	500.0
2019-08-12 06:00:00	DIA	ETF	261.8	261.8	261.26	261.26	5200.0
2019-08-12 07:00:00	DIA	ETF	261.71	261.71	260.99	261.4	13821.0

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

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