PREVIEW / etf_1hour / 2020-11-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-13.parquet
  size:    383 KB
  rows:    12,994

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-13 04:00:00	SPY	ETF	355.1	356.37	354.99	356.32	67023.0
2020-11-13 05:00:00	SPY	ETF	356.28	356.8	356.06	356.32	173649.0
2020-11-13 06:00:00	SPY	ETF	356.44	356.45	355.38	355.8	210544.0
2020-11-13 07:00:00	SPY	ETF	355.87	355.95	355.36	355.39	330056.0
2020-11-13 08:00:00	SPY	ETF	355.46	355.92	353.39	355.71	515958.0
2020-11-13 09:00:00	SPY	ETF	355.71	356.2399	355.2002	356.03	5180923.0
2020-11-13 10:00:00	SPY	ETF	356.03	356.12	354.71	355.19	7577669.0
2020-11-13 11:00:00	SPY	ETF	355.2	356.39	355.2	356.27	6293166.0
2020-11-13 12:00:00	SPY	ETF	356.29	356.74	356.075	356.7399	3122346.0
2020-11-13 13:00:00	SPY	ETF	356.74	357.13	356.5	356.6	4060957.0
2020-11-13 14:00:00	SPY	ETF	356.6	357.81	356.42	357.66	6667439.0
2020-11-13 15:00:00	SPY	ETF	357.66	358.9	356.96	358.05	17126388.0
2020-11-13 16:00:00	SPY	ETF	358.05	358.33	357.83	358.13	9838158.0
2020-11-13 17:00:00	SPY	ETF	358.1	358.35	358.09	358.33	180695.0
2020-11-13 18:00:00	SPY	ETF	358.3	358.32	358.1	358.26	29618.0
2020-11-13 19:00:00	SPY	ETF	358.29	358.4	358.25	358.4	45383.0
2020-11-13 04:00:00	QQQ	ETF	290.16	291.08	290.01	291.04	41225.0
2020-11-13 05:00:00	QQQ	ETF	290.96	291.04	290.49	290.63	32631.0
2020-11-13 06:00:00	QQQ	ETF	290.61	290.66	290.08	290.33	70594.0
2020-11-13 07:00:00	QQQ	ETF	290.29	290.69	289.95	290.0	157867.0
2020-11-13 08:00:00	QQQ	ETF	290.6399	290.6499	289.48	290.24	169404.0
2020-11-13 09:00:00	QQQ	ETF	290.24	290.84	289.56	289.8664	3117067.0
2020-11-13 10:00:00	QQQ	ETF	289.82	289.96	287.8701	288.31	4005901.0
2020-11-13 11:00:00	QQQ	ETF	288.31	289.89	288.285	289.64	2873101.0
2020-11-13 12:00:00	QQQ	ETF	289.665	290.265	289.445	290.2433	1559732.0
2020-11-13 13:00:00	QQQ	ETF	290.2565	290.34	289.28	289.39	1931761.0
2020-11-13 14:00:00	QQQ	ETF	289.38	290.4499	289.0	290.33	1965334.0
2020-11-13 15:00:00	QQQ	ETF	290.31	291.57	289.91	291.07	4532337.0
2020-11-13 16:00:00	QQQ	ETF	291.08	291.44	290.6032	291.38	1088876.0
2020-11-13 17:00:00	QQQ	ETF	291.31	291.42	291.28	291.29	23251.0
2020-11-13 18:00:00	QQQ	ETF	291.33	291.35	291.12	291.35	9377.0
2020-11-13 19:00:00	QQQ	ETF	291.29	291.36	291.0	291.0	47854.0
2020-11-13 04:00:00	IWM	ETF	170.89	171.62	170.89	171.6	30156.0
2020-11-13 05:00:00	IWM	ETF	171.62	171.9	171.48	171.82	24900.0
2020-11-13 06:00:00	IWM	ETF	171.88	171.88	171.45	171.72	20428.0
2020-11-13 07:00:00	IWM	ETF	171.73	171.73	170.97	170.98	74823.0
2020-11-13 08:00:00	IWM	ETF	171.33	171.66	170.25	171.35	95342.0
2020-11-13 09:00:00	IWM	ETF	171.3	173.015	171.13	172.81	2560235.0
2020-11-13 10:00:00	IWM	ETF	172.78	173.25	171.82	171.94	2871738.0
2020-11-13 11:00:00	IWM	ETF	171.95	172.81	171.94	172.18	1785887.0
2020-11-13 12:00:00	IWM	ETF	172.18	172.61	171.85	172.45	1812558.0
2020-11-13 13:00:00	IWM	ETF	172.46	172.54	171.87	172.34	1921154.0
2020-11-13 14:00:00	IWM	ETF	172.34	173.85	172.31	173.75	3012689.0
2020-11-13 15:00:00	IWM	ETF	173.74	174.1264	173.27	173.51	5027388.0
2020-11-13 16:00:00	IWM	ETF	173.5	173.78	169.8505	173.65	2641572.0
2020-11-13 17:00:00	IWM	ETF	173.65	173.7	173.4	173.69	46348.0
2020-11-13 18:00:00	IWM	ETF	173.7	174.08	173.65	173.9	24830.0
2020-11-13 19:00:00	IWM	ETF	173.88	173.96	173.76	173.88	8509.0
2020-11-13 04:00:00	DIA	ETF	292.5	293.25	292.5	293.13	4140.0
2020-11-13 05:00:00	DIA	ETF	293.41	293.85	293.41	293.61	600.0

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

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