PREVIEW / etf_1min / 2020-03-06

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-06.parquet
  size:    4.6 MB
  rows:    236,311

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-03-06 04:00:00	SPY	ETF	298.71	298.8	298.71	298.8	2532.0
2020-03-06 04:01:00	SPY	ETF	299.04	299.05	299.04	299.05	5570.0
2020-03-06 04:02:00	SPY	ETF	299.04	299.08	299.04	299.08	10690.0
2020-03-06 04:03:00	SPY	ETF	299.36	299.4	299.35	299.4	1214.0
2020-03-06 04:04:00	SPY	ETF	299.51	299.51	299.43	299.43	2569.0
2020-03-06 04:05:00	SPY	ETF	299.51	299.51	299.5	299.5	346.0
2020-03-06 04:06:00	SPY	ETF	299.55	299.55	299.55	299.55	511.0
2020-03-06 04:07:00	SPY	ETF	299.6	299.6	299.6	299.6	215.0
2020-03-06 04:08:00	SPY	ETF	299.39	299.39	299.26	299.32	520.0
2020-03-06 04:09:00	SPY	ETF	299.16	299.17	299.0	299.0	1672.0
2020-03-06 04:10:00	SPY	ETF	299.2	299.2	299.16	299.17	1900.0
2020-03-06 04:11:00	SPY	ETF	299.17	299.21	299.17	299.19	8675.0
2020-03-06 04:12:00	SPY	ETF	299.16	299.16	299.0	299.0	901.0
2020-03-06 04:13:00	SPY	ETF	298.88	298.88	298.4	298.49	2540.0
2020-03-06 04:14:00	SPY	ETF	298.63	298.85	298.63	298.85	690.0
2020-03-06 04:16:00	SPY	ETF	298.58	298.58	298.29	298.29	512.0
2020-03-06 04:17:00	SPY	ETF	298.28	298.28	298.18	298.18	559.0
2020-03-06 04:18:00	SPY	ETF	298.2	298.25	298.19	298.23	4050.0
2020-03-06 04:19:00	SPY	ETF	298.25	298.25	298.25	298.25	150.0
2020-03-06 04:20:00	SPY	ETF	298.39	298.4	298.36	298.36	1289.0
2020-03-06 04:21:00	SPY	ETF	298.37	298.59	298.37	298.59	225.0
2020-03-06 04:22:00	SPY	ETF	298.38	298.38	298.33	298.33	735.0
2020-03-06 04:23:00	SPY	ETF	298.1	298.1	298.09	298.09	512.0
2020-03-06 04:24:00	SPY	ETF	298.0	298.0	297.9	297.9	1721.0
2020-03-06 04:25:00	SPY	ETF	297.92	298.05	297.92	298.0	1715.0
2020-03-06 04:26:00	SPY	ETF	298.03	298.03	297.9	297.9	1140.0
2020-03-06 04:28:00	SPY	ETF	297.94	297.95	297.84	297.88	6230.0
2020-03-06 04:29:00	SPY	ETF	297.82	298.05	297.82	298.05	1453.0
2020-03-06 04:30:00	SPY	ETF	298.06	298.12	298.06	298.12	620.0
2020-03-06 04:31:00	SPY	ETF	297.82	297.88	297.82	297.84	875.0
2020-03-06 04:33:00	SPY	ETF	298.03	298.03	298.03	298.03	100.0
2020-03-06 04:34:00	SPY	ETF	297.84	297.84	297.69	297.69	1889.0
2020-03-06 04:35:00	SPY	ETF	297.69	297.69	297.69	297.69	492.0
2020-03-06 04:36:00	SPY	ETF	297.63	297.69	297.55	297.69	5958.0
2020-03-06 04:37:00	SPY	ETF	297.52	297.52	297.44	297.44	7375.0
2020-03-06 04:38:00	SPY	ETF	297.35	297.35	297.0	297.09	20130.0
2020-03-06 04:39:00	SPY	ETF	297.09	297.09	296.9	297.08	7177.0
2020-03-06 04:40:00	SPY	ETF	297.04	297.05	297.0	297.05	2355.0
2020-03-06 04:42:00	SPY	ETF	297.24	297.24	297.24	297.24	121.0
2020-03-06 04:43:00	SPY	ETF	296.93	296.94	296.83	296.83	6569.0
2020-03-06 04:44:00	SPY	ETF	296.91	296.97	296.87	296.87	1906.0
2020-03-06 04:45:00	SPY	ETF	296.75	296.75	296.66	296.66	1366.0
2020-03-06 04:46:00	SPY	ETF	296.91	296.91	296.84	296.84	4575.0
2020-03-06 04:47:00	SPY	ETF	296.65	296.65	296.55	296.55	681.0
2020-03-06 04:48:00	SPY	ETF	296.75	296.75	296.75	296.75	231.0
2020-03-06 04:49:00	SPY	ETF	296.71	296.71	296.59	296.65	1629.0
2020-03-06 04:50:00	SPY	ETF	296.69	297.03	296.69	297.03	7277.0
2020-03-06 04:51:00	SPY	ETF	297.0	297.12	297.0	297.11	5854.0
2020-03-06 04:52:00	SPY	ETF	297.19	297.4	297.19	297.4	7501.0
2020-03-06 04:53:00	SPY	ETF	297.34	297.53	297.05	297.05	3292.0

> showing 50 of 236,311 rows — these rows as CSV

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