PREVIEW / etf_1hour / 2020-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-07.parquet
  size:    364 KB
  rows:    12,457

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
2020-05-07 04:00:00	SPY	ETF	286.7	287.4	286.7	287.28	119087.0
2020-05-07 05:00:00	SPY	ETF	287.31	288.11	287.19	287.84	100025.0
2020-05-07 06:00:00	SPY	ETF	287.87	288.19	287.36	287.5	167956.0
2020-05-07 07:00:00	SPY	ETF	287.49	288.4	287.16	288.27	649257.0
2020-05-07 08:00:00	SPY	ETF	287.8999	288.3599	285.18	287.96	1066501.0
2020-05-07 09:00:00	SPY	ETF	287.97	288.96	287.58	288.63	9010951.0
2020-05-07 10:00:00	SPY	ETF	288.63	288.73	287.2221	287.62	9454164.0
2020-05-07 11:00:00	SPY	ETF	287.61	289.72	287.58	289.44	11963789.0
2020-05-07 12:00:00	SPY	ETF	289.435	289.78	288.7799	289.2498	7669863.0
2020-05-07 13:00:00	SPY	ETF	289.2462	289.57	288.51	288.82	7374550.0
2020-05-07 14:00:00	SPY	ETF	288.815	289.52	287.62	288.06	6634052.0
2020-05-07 15:00:00	SPY	ETF	288.06	288.45	287.13	287.7	17002181.0
2020-05-07 16:00:00	SPY	ETF	287.7	288.75	287.57	288.58	2843120.0
2020-05-07 17:00:00	SPY	ETF	288.58	288.62	287.68	288.48	165302.0
2020-05-07 18:00:00	SPY	ETF	288.48	289.14	288.34	289.07	207905.0
2020-05-07 19:00:00	SPY	ETF	289.19	289.56	288.65	289.51	251466.0
2020-05-07 04:00:00	QQQ	ETF	220.95	221.75	220.95	221.56	48400.0
2020-05-07 05:00:00	QQQ	ETF	221.55	222.06	221.5	221.97	39650.0
2020-05-07 06:00:00	QQQ	ETF	221.93	222.1	221.52	221.57	80062.0
2020-05-07 07:00:00	QQQ	ETF	221.59	222.07	221.16	221.9	289108.0
2020-05-07 08:00:00	QQQ	ETF	219.725	222.02	219.725	221.8	400685.0
2020-05-07 09:00:00	QQQ	ETF	221.85	222.28	221.08	221.73	5766560.0
2020-05-07 10:00:00	QQQ	ETF	221.71	221.86	220.42	220.7979	5644456.0
2020-05-07 11:00:00	QQQ	ETF	220.8	222.35	220.8	222.01	5163696.0
2020-05-07 12:00:00	QQQ	ETF	222.0	222.47	221.91	222.42	2574823.0
2020-05-07 13:00:00	QQQ	ETF	222.415	222.73	222.01	222.32	2528658.0
2020-05-07 14:00:00	QQQ	ETF	222.3	222.35	221.54	222.0079	2671680.0
2020-05-07 15:00:00	QQQ	ETF	222.01	222.35	221.26	221.89	7584304.0
2020-05-07 16:00:00	QQQ	ETF	221.88	222.61	221.78	222.55	1268315.0
2020-05-07 17:00:00	QQQ	ETF	222.5	222.6	222.22	222.4	74767.0
2020-05-07 18:00:00	QQQ	ETF	222.36	222.86	222.25	222.86	134038.0
2020-05-07 19:00:00	QQQ	ETF	222.86	223.1	222.46	223.09	157855.0
2020-05-07 04:00:00	IWM	ETF	126.88	127.0	126.7	127.0	13863.0
2020-05-07 05:00:00	IWM	ETF	126.91	127.6	126.91	127.52	24941.0
2020-05-07 06:00:00	IWM	ETF	127.5	127.79	127.34	127.55	44800.0
2020-05-07 07:00:00	IWM	ETF	127.42	128.015	127.29	127.95	139354.0
2020-05-07 08:00:00	IWM	ETF	127.7099	127.88	125.98	127.63	148314.0
2020-05-07 09:00:00	IWM	ETF	127.61	128.43	127.03	127.79	3211234.0
2020-05-07 10:00:00	IWM	ETF	127.78	128.12	126.55	127.63	4030699.0
2020-05-07 11:00:00	IWM	ETF	127.6	128.5	127.335	128.31	2951868.0
2020-05-07 12:00:00	IWM	ETF	128.32	128.47	127.4799	127.9835	1944157.0
2020-05-07 13:00:00	IWM	ETF	127.98	128.4	127.585	127.84	2397544.0
2020-05-07 14:00:00	IWM	ETF	127.84	128.1	127.17	127.685	2278139.0
2020-05-07 15:00:00	IWM	ETF	127.685	128.04	127.16	127.5	5214968.0
2020-05-07 16:00:00	IWM	ETF	127.5	128.34	127.37	128.0	1581770.0
2020-05-07 17:00:00	IWM	ETF	127.94	127.97	127.44	127.94	102117.0
2020-05-07 18:00:00	IWM	ETF	127.98	128.39	127.44	128.28	85713.0
2020-05-07 19:00:00	IWM	ETF	128.33	128.8	128.03	128.71	33515.0
2020-05-07 04:00:00	DIA	ETF	237.2	238.95	237.2	238.95	1023.0
2020-05-07 05:00:00	DIA	ETF	238.94	239.52	238.94	239.45	4369.0

> showing 50 of 12,457 rows — these rows as CSV

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