PREVIEW / etf_1min / 2019-01-02

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-01-02.parquet
  size:    3.7 MB
  rows:    197,990

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
2019-01-02 04:00:00	SPY	ETF	248.0	248.0	245.03	245.03	10616.0
2019-01-02 04:01:00	SPY	ETF	245.01	245.14	245.0	245.14	8122.0
2019-01-02 04:02:00	SPY	ETF	245.13	245.21	244.96	245.11	2405.0
2019-01-02 04:03:00	SPY	ETF	245.24	245.24	245.23	245.23	277.0
2019-01-02 04:04:00	SPY	ETF	245.3	245.42	245.26	245.41	7650.0
2019-01-02 04:05:00	SPY	ETF	245.41	245.41	245.3	245.35	14651.0
2019-01-02 04:06:00	SPY	ETF	245.24	245.27	245.24	245.25	1489.0
2019-01-02 04:07:00	SPY	ETF	245.34	245.34	245.34	245.34	500.0
2019-01-02 04:08:00	SPY	ETF	245.29	245.34	245.25	245.27	3121.0
2019-01-02 04:09:00	SPY	ETF	245.29	245.46	245.29	245.46	315.0
2019-01-02 04:10:00	SPY	ETF	245.46	245.5	245.46	245.5	2123.0
2019-01-02 04:11:00	SPY	ETF	245.5	245.56	245.5	245.5	5645.0
2019-01-02 04:12:00	SPY	ETF	245.54	245.57	245.44	245.44	6550.0
2019-01-02 04:13:00	SPY	ETF	245.52	245.54	245.52	245.54	7500.0
2019-01-02 04:14:00	SPY	ETF	245.55	245.57	245.52	245.52	5025.0
2019-01-02 04:15:00	SPY	ETF	245.54	245.59	245.53	245.59	1088.0
2019-01-02 04:16:00	SPY	ETF	245.59	245.59	245.51	245.51	1215.0
2019-01-02 04:17:00	SPY	ETF	245.52	245.65	245.52	245.65	634.0
2019-01-02 04:19:00	SPY	ETF	245.64	245.64	245.64	245.64	169.0
2019-01-02 04:20:00	SPY	ETF	245.61	245.68	245.61	245.68	1007.0
2019-01-02 04:22:00	SPY	ETF	245.66	245.68	245.64	245.64	2300.0
2019-01-02 04:23:00	SPY	ETF	245.69	245.69	245.69	245.69	169.0
2019-01-02 04:24:00	SPY	ETF	245.74	245.89	245.74	245.75	1108.0
2019-01-02 04:25:00	SPY	ETF	245.8	245.88	245.77	245.88	2210.0
2019-01-02 04:26:00	SPY	ETF	245.85	245.89	245.74	245.89	5338.0
2019-01-02 04:27:00	SPY	ETF	245.88	245.9	245.87	245.9	1100.0
2019-01-02 04:29:00	SPY	ETF	245.93	245.99	245.93	245.99	1209.0
2019-01-02 04:30:00	SPY	ETF	245.91	245.91	245.88	245.88	979.0
2019-01-02 04:31:00	SPY	ETF	245.87	245.87	245.87	245.87	173.0
2019-01-02 04:33:00	SPY	ETF	245.97	246.03	245.97	246.03	469.0
2019-01-02 04:34:00	SPY	ETF	246.05	246.05	246.05	246.05	300.0
2019-01-02 04:35:00	SPY	ETF	246.05	246.05	246.0	246.0	468.0
2019-01-02 04:37:00	SPY	ETF	246.04	246.04	246.0	246.0	969.0
2019-01-02 04:39:00	SPY	ETF	245.95	245.95	245.88	245.88	269.0
2019-01-02 04:40:00	SPY	ETF	245.87	245.87	245.63	245.63	1922.0
2019-01-02 04:41:00	SPY	ETF	245.68	245.68	245.6	245.62	1169.0
2019-01-02 04:42:00	SPY	ETF	245.7	245.89	245.7	245.8	2273.0
2019-01-02 04:43:00	SPY	ETF	245.88	245.88	245.88	245.88	150.0
2019-01-02 04:44:00	SPY	ETF	245.76	245.76	245.65	245.69	6911.0
2019-01-02 04:45:00	SPY	ETF	245.66	245.66	245.66	245.66	257.0
2019-01-02 04:46:00	SPY	ETF	245.74	245.74	245.74	245.74	100.0
2019-01-02 04:47:00	SPY	ETF	245.84	245.84	245.84	245.84	400.0
2019-01-02 04:48:00	SPY	ETF	245.84	245.84	245.84	245.84	101.0
2019-01-02 04:49:00	SPY	ETF	245.84	245.84	245.84	245.84	183.0
2019-01-02 04:50:00	SPY	ETF	245.92	245.93	245.92	245.93	500.0
2019-01-02 04:51:00	SPY	ETF	245.88	245.94	245.88	245.94	1079.0
2019-01-02 04:52:00	SPY	ETF	245.99	246.11	245.99	246.11	1951.0
2019-01-02 04:53:00	SPY	ETF	245.92	245.92	245.9	245.9	773.0
2019-01-02 04:54:00	SPY	ETF	245.91	245.93	245.89	245.93	2369.0
2019-01-02 04:55:00	SPY	ETF	246.0	246.0	246.0	246.0	500.0

> showing 50 of 197,990 rows — these rows as CSV

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