PREVIEW / etf_1hour / 2019-09-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-17.parquet
  size:    330 KB
  rows:    10,749

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-09-17 04:00:00	SPY	ETF	300.12	300.36	299.97	300.0	11460.0
2019-09-17 05:00:00	SPY	ETF	300.1	300.27	299.95	299.95	8083.0
2019-09-17 06:00:00	SPY	ETF	299.86	299.97	299.72	299.72	17220.0
2019-09-17 07:00:00	SPY	ETF	299.77	300.3	299.73	300.21	292296.0
2019-09-17 08:00:00	SPY	ETF	300.1999	300.1999	299.48	299.83	353763.0
2019-09-17 09:00:00	SPY	ETF	299.81	300.39	299.51	300.155	7726376.0
2019-09-17 10:00:00	SPY	ETF	300.155	300.36	299.83	299.98	4800242.0
2019-09-17 11:00:00	SPY	ETF	299.98	300.57	299.97	300.29	4340236.0
2019-09-17 12:00:00	SPY	ETF	300.295	300.445	299.93	300.0	3805573.0
2019-09-17 13:00:00	SPY	ETF	300.0	300.6	299.94	300.28	3057502.0
2019-09-17 14:00:00	SPY	ETF	300.29	300.56	300.11	300.285	4804610.0
2019-09-17 15:00:00	SPY	ETF	300.29	301.02	300.16	300.94	8864812.0
2019-09-17 16:00:00	SPY	ETF	300.95	301.0	300.8	300.94	3347749.0
2019-09-17 17:00:00	SPY	ETF	300.91	300.95	300.9	300.92	567621.0
2019-09-17 18:00:00	SPY	ETF	300.93	300.96	300.74	300.85	99246.0
2019-09-17 19:00:00	SPY	ETF	300.86	300.88	300.76	300.82	34227.0
2019-09-17 04:00:00	QQQ	ETF	191.5	191.68	191.35	191.42	13192.0
2019-09-17 05:00:00	QQQ	ETF	191.5	191.6	191.3	191.33	8400.0
2019-09-17 06:00:00	QQQ	ETF	191.34	191.44	191.16	191.21	23090.0
2019-09-17 07:00:00	QQQ	ETF	191.2	191.83	191.17	191.73	59345.0
2019-09-17 08:00:00	QQQ	ETF	191.22	191.73	191.08	191.54	102952.0
2019-09-17 09:00:00	QQQ	ETF	191.54	192.03	191.29	191.69	2215040.0
2019-09-17 10:00:00	QQQ	ETF	191.705	191.81	191.42	191.52	1375566.0
2019-09-17 11:00:00	QQQ	ETF	191.52	192.01	191.52	191.82	1045945.0
2019-09-17 12:00:00	QQQ	ETF	191.83	191.96	191.55	191.6867	1068018.0
2019-09-17 13:00:00	QQQ	ETF	191.67	192.1	191.655	191.865	788131.0
2019-09-17 14:00:00	QQQ	ETF	191.88	192.04	191.7	191.94	890147.0
2019-09-17 15:00:00	QQQ	ETF	191.93	192.6	191.88	192.52	3794093.0
2019-09-17 16:00:00	QQQ	ETF	192.52	192.69	191.6396	192.59	1448982.0
2019-09-17 17:00:00	QQQ	ETF	192.64	192.65	192.4	192.5	57910.0
2019-09-17 18:00:00	QQQ	ETF	192.5	192.56	192.35	192.55	26692.0
2019-09-17 19:00:00	QQQ	ETF	192.46	192.55	192.42	192.4301	9036.0
2019-09-17 04:00:00	IWM	ETF	157.87	157.9	157.78	157.81	3005.0
2019-09-17 05:00:00	IWM	ETF	157.83	157.83	157.83	157.83	500.0
2019-09-17 06:00:00	IWM	ETF	157.69	157.69	157.69	157.69	4000.0
2019-09-17 07:00:00	IWM	ETF	157.64	157.85	157.55	157.78	15425.0
2019-09-17 08:00:00	IWM	ETF	157.75	157.75	157.24	157.32	44890.0
2019-09-17 09:00:00	IWM	ETF	157.3	157.45	156.66	157.13	2546526.0
2019-09-17 10:00:00	IWM	ETF	157.13	157.155	156.45	156.96	2165360.0
2019-09-17 11:00:00	IWM	ETF	156.97	157.575	156.7937	157.34	2209754.0
2019-09-17 12:00:00	IWM	ETF	157.365	157.51	156.9772	157.19	1630675.0
2019-09-17 13:00:00	IWM	ETF	157.2	157.46	157.1	157.31	864392.0
2019-09-17 14:00:00	IWM	ETF	157.32	157.515	157.08	157.22	1502117.0
2019-09-17 15:00:00	IWM	ETF	157.21	157.49	157.11	157.44	3355481.0
2019-09-17 16:00:00	IWM	ETF	157.46	157.61	157.2834	157.61	905897.0
2019-09-17 17:00:00	IWM	ETF	157.56	157.58	157.56	157.57	4591.0
2019-09-17 18:00:00	IWM	ETF	157.57	157.6	157.5	157.55	18620.0
2019-09-17 19:00:00	IWM	ETF	157.58	157.58	157.54	157.54	1800.0
2019-09-17 04:00:00	DIA	ETF	271.09	271.15	271.09	271.15	2200.0
2019-09-17 06:00:00	DIA	ETF	270.87	270.87	270.87	270.87	200.0

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

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