PREVIEW / etf_1hour / 2020-11-18

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-18.parquet
  size:    392 KB
  rows:    13,424

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-11-18 04:00:00	SPY	ETF	360.17	361.04	360.17	361.0	24852.0
2020-11-18 05:00:00	SPY	ETF	361.05	361.7	361.02	361.42	21248.0
2020-11-18 06:00:00	SPY	ETF	361.43	361.89	361.27	361.55	82013.0
2020-11-18 07:00:00	SPY	ETF	361.57	362.21	361.55	361.76	250713.0
2020-11-18 08:00:00	SPY	ETF	361.6999	362.21	358.91	361.3898	248748.0
2020-11-18 09:00:00	SPY	ETF	361.34	361.45	360.31	360.61	5454629.0
2020-11-18 10:00:00	SPY	ETF	360.6	361.32	360.545	361.12	5513611.0
2020-11-18 11:00:00	SPY	ETF	361.12	361.5	360.81	361.21	4055955.0
2020-11-18 12:00:00	SPY	ETF	361.205	361.5	360.67	360.77	3456844.0
2020-11-18 13:00:00	SPY	ETF	360.76	361.04	359.32	359.84	10447876.0
2020-11-18 14:00:00	SPY	ETF	359.83	360.15	358.67	359.46	6760402.0
2020-11-18 15:00:00	SPY	ETF	359.47	360.06	356.24	356.29	21366794.0
2020-11-18 16:00:00	SPY	ETF	356.28	356.87	355.59	355.92	9672333.0
2020-11-18 17:00:00	SPY	ETF	355.87	356.28	355.86	356.01	1890745.0
2020-11-18 18:00:00	SPY	ETF	356.03	356.68	356.03	356.21	181470.0
2020-11-18 19:00:00	SPY	ETF	356.12	356.44	355.32	355.87	160927.0
2020-11-18 04:00:00	QQQ	ETF	292.33	292.73	292.25	292.63	20116.0
2020-11-18 05:00:00	QQQ	ETF	292.63	293.25	292.63	292.97	20656.0
2020-11-18 06:00:00	QQQ	ETF	292.98	293.22	292.35	292.54	87589.0
2020-11-18 07:00:00	QQQ	ETF	292.49	292.85	292.36	292.6	218852.0
2020-11-18 08:00:00	QQQ	ETF	292.5499	292.86	290.88	292.3	213268.0
2020-11-18 09:00:00	QQQ	ETF	292.29	292.41	290.61	290.98	2927149.0
2020-11-18 10:00:00	QQQ	ETF	290.96	292.2	290.53	292.1095	3055158.0
2020-11-18 11:00:00	QQQ	ETF	292.11	292.6415	291.65	292.6415	1938513.0
2020-11-18 12:00:00	QQQ	ETF	292.65	293.37	292.642	292.904	1782825.0
2020-11-18 13:00:00	QQQ	ETF	292.86	293.15	291.47	291.8297	1929088.0
2020-11-18 14:00:00	QQQ	ETF	291.81	292.43	291.27	292.26	2198125.0
2020-11-18 15:00:00	QQQ	ETF	292.28	293.02	290.02	290.07	5270868.0
2020-11-18 16:00:00	QQQ	ETF	290.08	290.47	289.42	289.7	1292073.0
2020-11-18 17:00:00	QQQ	ETF	289.62	289.91	289.38	289.54	94021.0
2020-11-18 18:00:00	QQQ	ETF	289.51	290.15	289.51	289.78	176840.0
2020-11-18 19:00:00	QQQ	ETF	289.8	289.99	289.22	289.49	57748.0
2020-11-18 04:00:00	IWM	ETF	177.66	178.49	177.53	178.48	9380.0
2020-11-18 05:00:00	IWM	ETF	178.73	179.1	178.72	178.99	17132.0
2020-11-18 06:00:00	IWM	ETF	179.11	179.78	178.71	179.0	115064.0
2020-11-18 07:00:00	IWM	ETF	179.0	179.76	178.95	179.4	153192.0
2020-11-18 08:00:00	IWM	ETF	179.2	179.57	178.46	178.84	138135.0
2020-11-18 09:00:00	IWM	ETF	178.86	179.56	178.43	178.69	2163857.0
2020-11-18 10:00:00	IWM	ETF	178.68	179.12	178.45	178.78	2593042.0
2020-11-18 11:00:00	IWM	ETF	178.765	179.715	178.76	179.495	1656820.0
2020-11-18 12:00:00	IWM	ETF	179.5	179.66	179.145	179.44	1176115.0
2020-11-18 13:00:00	IWM	ETF	179.44	179.71	178.23	178.53	1949039.0
2020-11-18 14:00:00	IWM	ETF	178.54	179.06	177.79	178.225	2347495.0
2020-11-18 15:00:00	IWM	ETF	178.23	178.2885	175.86	175.92	6188499.0
2020-11-18 16:00:00	IWM	ETF	175.96	176.14	175.4	175.68	2308822.0
2020-11-18 17:00:00	IWM	ETF	175.75	175.98	175.3	175.75	25635.0
2020-11-18 18:00:00	IWM	ETF	175.95	176.15	175.8	175.8	35409.0
2020-11-18 19:00:00	IWM	ETF	175.73	175.8	175.3	175.45	24690.0
2020-11-18 04:00:00	DIA	ETF	298.05	298.87	298.05	298.82	2615.0
2020-11-18 05:00:00	DIA	ETF	299.09	299.1	299.02	299.02	300.0

> showing 50 of 13,424 rows — these rows as CSV

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