PREVIEW / etf_1min / 2020-08-04

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-08-04.parquet
  size:    3.7 MB
  rows:    207,500

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-08-04 04:00:00	SPY	ETF	328.11	328.11	328.07	328.07	1318.0
2020-08-04 04:01:00	SPY	ETF	328.07	328.07	328.07	328.07	132.0
2020-08-04 04:02:00	SPY	ETF	328.09	328.09	328.09	328.09	581.0
2020-08-04 04:03:00	SPY	ETF	328.12	328.12	328.05	328.05	665.0
2020-08-04 04:04:00	SPY	ETF	328.0	328.0	327.83	327.95	3649.0
2020-08-04 04:05:00	SPY	ETF	327.97	327.97	327.79	327.8	5951.0
2020-08-04 04:06:00	SPY	ETF	327.85	327.85	327.85	327.85	140.0
2020-08-04 04:07:00	SPY	ETF	327.92	327.92	327.52	327.52	814.0
2020-08-04 04:09:00	SPY	ETF	327.66	327.67	327.66	327.67	5600.0
2020-08-04 04:10:00	SPY	ETF	327.72	327.82	327.72	327.75	830.0
2020-08-04 04:11:00	SPY	ETF	327.72	327.82	327.69	327.82	2065.0
2020-08-04 04:12:00	SPY	ETF	327.83	327.87	327.77	327.78	1975.0
2020-08-04 04:13:00	SPY	ETF	327.93	327.93	327.93	327.93	224.0
2020-08-04 04:14:00	SPY	ETF	327.83	327.83	327.83	327.83	976.0
2020-08-04 04:15:00	SPY	ETF	327.91	328.0	327.91	328.0	1676.0
2020-08-04 04:18:00	SPY	ETF	328.08	328.08	328.08	328.08	406.0
2020-08-04 04:19:00	SPY	ETF	328.0	328.08	327.97	327.97	2600.0
2020-08-04 04:21:00	SPY	ETF	327.91	327.91	327.88	327.88	1106.0
2020-08-04 04:23:00	SPY	ETF	328.02	328.02	328.02	328.02	925.0
2020-08-04 04:24:00	SPY	ETF	328.0	328.01	328.0	328.0	1800.0
2020-08-04 04:25:00	SPY	ETF	327.94	327.96	327.94	327.94	1181.0
2020-08-04 04:26:00	SPY	ETF	328.12	328.12	328.12	328.12	970.0
2020-08-04 04:27:00	SPY	ETF	328.1	328.19	328.1	328.19	4367.0
2020-08-04 04:28:00	SPY	ETF	328.22	328.22	328.22	328.22	130.0
2020-08-04 04:30:00	SPY	ETF	328.26	328.35	328.26	328.33	2625.0
2020-08-04 04:31:00	SPY	ETF	328.27	328.27	328.27	328.27	310.0
2020-08-04 04:32:00	SPY	ETF	328.16	328.16	328.01	328.01	1650.0
2020-08-04 04:33:00	SPY	ETF	327.9	327.9	327.88	327.88	2575.0
2020-08-04 04:34:00	SPY	ETF	328.08	328.08	328.08	328.08	414.0
2020-08-04 04:35:00	SPY	ETF	327.84	327.84	327.84	327.84	883.0
2020-08-04 04:36:00	SPY	ETF	327.81	327.81	327.81	327.81	100.0
2020-08-04 04:37:00	SPY	ETF	327.77	327.85	327.77	327.85	300.0
2020-08-04 04:39:00	SPY	ETF	327.86	327.86	327.86	327.86	530.0
2020-08-04 04:40:00	SPY	ETF	327.9	327.9	327.9	327.9	154.0
2020-08-04 04:42:00	SPY	ETF	328.08	328.08	327.97	327.98	1340.0
2020-08-04 04:43:00	SPY	ETF	327.96	327.96	327.96	327.96	200.0
2020-08-04 04:45:00	SPY	ETF	327.94	327.94	327.94	327.94	340.0
2020-08-04 04:49:00	SPY	ETF	328.05	328.05	328.05	328.05	330.0
2020-08-04 04:50:00	SPY	ETF	327.79	327.79	327.79	327.79	100.0
2020-08-04 04:57:00	SPY	ETF	328.01	328.01	328.01	328.01	500.0
2020-08-04 04:59:00	SPY	ETF	328.15	328.15	328.15	328.15	100.0
2020-08-04 05:00:00	SPY	ETF	328.04	328.04	328.04	328.04	140.0
2020-08-04 05:01:00	SPY	ETF	327.99	327.99	327.99	327.99	100.0
2020-08-04 05:04:00	SPY	ETF	328.11	328.18	328.11	328.18	3440.0
2020-08-04 05:05:00	SPY	ETF	328.11	328.18	328.11	328.18	255.0
2020-08-04 05:06:00	SPY	ETF	328.22	328.26	328.21	328.26	1125.0
2020-08-04 05:07:00	SPY	ETF	328.3	328.41	328.2	328.3	8975.0
2020-08-04 05:12:00	SPY	ETF	328.28	328.28	328.28	328.28	300.0
2020-08-04 05:13:00	SPY	ETF	328.23	328.23	328.23	328.23	100.0
2020-08-04 05:16:00	SPY	ETF	328.25	328.25	328.25	328.25	140.0

> showing 50 of 207,500 rows — these rows as CSV

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