PREVIEW / etf_1hour / 2019-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-17.parquet
  size:    314 KB
  rows:    10,523

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-17 04:00:00	SPY	ETF	289.8	289.91	289.73	289.78	3236.0
2019-06-17 05:00:00	SPY	ETF	289.94	289.95	289.75	289.78	13256.0
2019-06-17 06:00:00	SPY	ETF	289.8	289.8	289.49	289.49	24766.0
2019-06-17 07:00:00	SPY	ETF	289.54	289.94	289.47	289.92	112432.0
2019-06-17 08:00:00	SPY	ETF	289.91	290.25	289.34	289.39	373365.0
2019-06-17 09:00:00	SPY	ETF	289.39	289.92	289.19	289.765	4735152.0
2019-06-17 10:00:00	SPY	ETF	289.76	290.2041	289.56	290.03	6945632.0
2019-06-17 11:00:00	SPY	ETF	290.03	290.22	289.64	289.74	4160340.0
2019-06-17 12:00:00	SPY	ETF	289.74	289.82	289.5	289.77	2444735.0
2019-06-17 13:00:00	SPY	ETF	289.77	290.01	289.69	289.98	2785989.0
2019-06-17 14:00:00	SPY	ETF	289.98	290.14	289.7	289.73	4731603.0
2019-06-17 15:00:00	SPY	ETF	289.735	289.9	289.18	289.44	8596159.0
2019-06-17 16:00:00	SPY	ETF	289.45	289.73	289.37	289.73	2911704.0
2019-06-17 17:00:00	SPY	ETF	289.69	289.78	289.65	289.7	93066.0
2019-06-17 18:00:00	SPY	ETF	289.74	289.79	289.67	289.68	99171.0
2019-06-17 19:00:00	SPY	ETF	289.68	289.75	289.55	289.62	50317.0
2019-06-17 04:00:00	QQQ	ETF	182.88	183.03	182.84	182.98	20976.0
2019-06-17 05:00:00	QQQ	ETF	183.07	183.14	182.87	182.91	38725.0
2019-06-17 06:00:00	QQQ	ETF	182.93	182.95	182.65	182.68	38996.0
2019-06-17 07:00:00	QQQ	ETF	182.73	183.14	182.66	183.06	127515.0
2019-06-17 08:00:00	QQQ	ETF	182.71	183.12	182.6799	182.77	206471.0
2019-06-17 09:00:00	QQQ	ETF	182.81	184.18	182.81	183.96	3412246.0
2019-06-17 10:00:00	QQQ	ETF	183.97	184.23	183.68	184.11	3148323.0
2019-06-17 11:00:00	QQQ	ETF	184.11	184.25	183.65	183.72	1578303.0
2019-06-17 12:00:00	QQQ	ETF	183.7	183.92	183.59	183.87	1210372.0
2019-06-17 13:00:00	QQQ	ETF	183.88	184.06	183.83	184.02	1161894.0
2019-06-17 14:00:00	QQQ	ETF	184.017	184.125	183.8	183.8325	1346478.0
2019-06-17 15:00:00	QQQ	ETF	183.83	184.03	183.5	183.72	4132893.0
2019-06-17 16:00:00	QQQ	ETF	183.72	184.01	183.68	183.97	889881.0
2019-06-17 17:00:00	QQQ	ETF	183.97	183.99	183.91	183.94	10967.0
2019-06-17 18:00:00	QQQ	ETF	183.98	184.03	183.74	183.97	49824.0
2019-06-17 19:00:00	QQQ	ETF	183.7235	184.03	183.7235	183.92	54872.0
2019-06-17 04:00:00	IWM	ETF	151.47	151.47	151.47	151.47	200.0
2019-06-17 05:00:00	IWM	ETF	151.6	151.62	151.6	151.62	350.0
2019-06-17 06:00:00	IWM	ETF	151.61	151.61	151.52	151.55	1000.0
2019-06-17 07:00:00	IWM	ETF	151.55	151.68	151.55	151.68	5350.0
2019-06-17 08:00:00	IWM	ETF	151.71	151.76	151.66	151.68	21700.0
2019-06-17 09:00:00	IWM	ETF	151.5	152.398	151.5	152.257	1496525.0
2019-06-17 10:00:00	IWM	ETF	152.27	152.59	152.16	152.27	1327289.0
2019-06-17 11:00:00	IWM	ETF	152.26	152.4	152.02	152.28	1300557.0
2019-06-17 12:00:00	IWM	ETF	152.28	152.66	152.21	152.55	723987.0
2019-06-17 13:00:00	IWM	ETF	152.57	152.76	152.53	152.72	600887.0
2019-06-17 14:00:00	IWM	ETF	152.715	152.895	152.64	152.65	982240.0
2019-06-17 15:00:00	IWM	ETF	152.65	152.65	152.1	152.26	2540348.0
2019-06-17 16:00:00	IWM	ETF	152.28	152.42	152.23	152.42	463522.0
2019-06-17 17:00:00	IWM	ETF	152.4	152.45	152.4	152.45	1240.0
2019-06-17 18:00:00	IWM	ETF	152.44	152.44	152.44	152.44	2000.0
2019-06-17 19:00:00	IWM	ETF	152.48	152.48	152.33	152.33	3700.0
2019-06-17 04:00:00	DIA	ETF	261.85	261.85	261.85	261.85	100.0
2019-06-17 06:00:00	DIA	ETF	261.7	261.7	261.6	261.6	200.0

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

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