PREVIEW / etf_1min / 2020-03-02

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-03-02.parquet
  size:    5.0 MB
  rows:    255,518

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-02 04:00:00	SPY	ETF	300.2	300.2	299.1	299.97	11703.0
2020-03-02 04:01:00	SPY	ETF	299.9	299.95	299.89	299.89	2034.0
2020-03-02 04:02:00	SPY	ETF	299.72	300.0	299.72	300.0	2292.0
2020-03-02 04:03:00	SPY	ETF	300.0	300.05	300.0	300.01	4975.0
2020-03-02 04:04:00	SPY	ETF	300.07	300.07	299.97	300.0	5472.0
2020-03-02 04:05:00	SPY	ETF	300.04	300.25	300.0	300.25	8669.0
2020-03-02 04:06:00	SPY	ETF	300.33	300.48	300.33	300.4	4131.0
2020-03-02 04:07:00	SPY	ETF	300.39	300.39	300.34	300.34	1445.0
2020-03-02 04:08:00	SPY	ETF	300.27	300.35	300.11	300.11	1160.0
2020-03-02 04:09:00	SPY	ETF	300.11	300.11	299.99	300.0	3311.0
2020-03-02 04:10:00	SPY	ETF	300.11	300.38	300.11	300.38	745.0
2020-03-02 04:11:00	SPY	ETF	300.33	300.33	300.28	300.28	325.0
2020-03-02 04:12:00	SPY	ETF	300.18	300.21	299.82	299.82	4584.0
2020-03-02 04:13:00	SPY	ETF	299.53	299.76	299.44	299.44	7930.0
2020-03-02 04:14:00	SPY	ETF	299.73	299.75	299.69	299.69	3123.0
2020-03-02 04:15:00	SPY	ETF	299.4	299.4	299.33	299.33	982.0
2020-03-02 04:16:00	SPY	ETF	298.88	299.04	298.68	298.77	10594.0
2020-03-02 04:17:00	SPY	ETF	298.65	298.98	298.62	298.98	4951.0
2020-03-02 04:18:00	SPY	ETF	298.98	299.45	298.98	299.44	3991.0
2020-03-02 04:19:00	SPY	ETF	299.35	299.36	299.24	299.36	3875.0
2020-03-02 04:20:00	SPY	ETF	299.5	300.0	299.5	299.93	5726.0
2020-03-02 04:21:00	SPY	ETF	299.9	299.9	299.9	299.9	156.0
2020-03-02 04:22:00	SPY	ETF	299.8	300.2	299.8	300.2	925.0
2020-03-02 04:23:00	SPY	ETF	300.25	300.57	300.2	300.41	9404.0
2020-03-02 04:24:00	SPY	ETF	300.44	300.48	300.37	300.48	1525.0
2020-03-02 04:25:00	SPY	ETF	300.37	300.37	300.12	300.12	3539.0
2020-03-02 04:27:00	SPY	ETF	300.33	300.33	300.0	300.0	3607.0
2020-03-02 04:28:00	SPY	ETF	299.81	299.88	299.81	299.88	600.0
2020-03-02 04:29:00	SPY	ETF	299.65	299.77	299.65	299.77	3110.0
2020-03-02 04:30:00	SPY	ETF	300.04	300.12	299.98	300.12	3317.0
2020-03-02 04:31:00	SPY	ETF	299.82	299.82	299.5	299.5	2440.0
2020-03-02 04:32:00	SPY	ETF	299.44	299.49	299.17	299.49	2794.0
2020-03-02 04:33:00	SPY	ETF	299.59	300.0	299.07	299.07	5416.0
2020-03-02 04:34:00	SPY	ETF	299.04	299.04	298.95	298.95	3653.0
2020-03-02 04:35:00	SPY	ETF	298.75	298.86	298.75	298.8	2868.0
2020-03-02 04:36:00	SPY	ETF	298.55	298.55	298.5	298.5	661.0
2020-03-02 04:37:00	SPY	ETF	298.62	298.82	298.4	298.4	1073.0
2020-03-02 04:38:00	SPY	ETF	298.33	298.37	298.23	298.23	828.0
2020-03-02 04:39:00	SPY	ETF	298.22	298.32	298.03	298.03	4391.0
2020-03-02 04:40:00	SPY	ETF	298.25	298.25	297.62	297.91	7836.0
2020-03-02 04:41:00	SPY	ETF	297.5	297.95	297.38	297.82	5475.0
2020-03-02 04:42:00	SPY	ETF	297.84	297.9	297.44	297.44	11240.0
2020-03-02 04:43:00	SPY	ETF	297.07	297.31	296.74	296.91	9039.0
2020-03-02 04:44:00	SPY	ETF	296.5	296.76	296.5	296.5	1331.0
2020-03-02 04:45:00	SPY	ETF	296.45	296.45	296.22	296.33	3149.0
2020-03-02 04:46:00	SPY	ETF	296.28	296.99	296.28	296.93	9343.0
2020-03-02 04:47:00	SPY	ETF	297.06	297.37	297.01	297.34	2153.0
2020-03-02 04:48:00	SPY	ETF	297.4	297.62	297.4	297.55	4306.0
2020-03-02 04:49:00	SPY	ETF	297.42	297.55	297.28	297.38	3640.0
2020-03-02 04:50:00	SPY	ETF	297.38	297.38	297.18	297.24	3342.0

> showing 50 of 255,518 rows — these rows as CSV

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