PREVIEW / etf_1min / 2020-04-08

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-08.parquet
  size:    4.3 MB
  rows:    227,068

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-04-08 04:00:00	SPY	ETF	265.8	265.88	265.52	265.6	1844.0
2020-04-08 04:01:00	SPY	ETF	265.47	265.47	265.34	265.4	6068.0
2020-04-08 04:02:00	SPY	ETF	265.51	265.53	265.2	265.22	7033.0
2020-04-08 04:03:00	SPY	ETF	265.44	265.44	265.02	265.15	7419.0
2020-04-08 04:04:00	SPY	ETF	265.15	265.32	265.1	265.32	2501.0
2020-04-08 04:05:00	SPY	ETF	265.37	265.51	265.35	265.38	1700.0
2020-04-08 04:06:00	SPY	ETF	265.44	265.44	265.44	265.44	460.0
2020-04-08 04:07:00	SPY	ETF	265.44	265.46	265.34	265.44	6490.0
2020-04-08 04:08:00	SPY	ETF	265.27	265.27	265.24	265.25	3061.0
2020-04-08 04:09:00	SPY	ETF	265.21	265.24	265.17	265.18	9405.0
2020-04-08 04:10:00	SPY	ETF	265.17	265.18	265.1	265.15	12546.0
2020-04-08 04:11:00	SPY	ETF	265.12	265.17	264.8	264.8	7520.0
2020-04-08 04:12:00	SPY	ETF	264.9	264.95	264.8	264.84	1105.0
2020-04-08 04:13:00	SPY	ETF	264.81	264.89	264.8	264.84	4300.0
2020-04-08 04:14:00	SPY	ETF	264.9	265.09	264.9	265.02	1570.0
2020-04-08 04:16:00	SPY	ETF	264.84	264.84	264.61	264.66	3570.0
2020-04-08 04:17:00	SPY	ETF	264.62	264.62	264.33	264.44	2466.0
2020-04-08 04:18:00	SPY	ETF	264.54	264.59	264.45	264.45	2050.0
2020-04-08 04:19:00	SPY	ETF	264.45	264.52	264.37	264.52	2600.0
2020-04-08 04:20:00	SPY	ETF	264.5	264.5	264.5	264.5	1100.0
2020-04-08 04:21:00	SPY	ETF	264.44	264.44	264.24	264.24	751.0
2020-04-08 04:22:00	SPY	ETF	264.28	264.38	264.25	264.38	1710.0
2020-04-08 04:23:00	SPY	ETF	264.38	264.38	264.38	264.38	250.0
2020-04-08 04:24:00	SPY	ETF	264.51	264.51	264.45	264.45	610.0
2020-04-08 04:25:00	SPY	ETF	264.46	264.51	264.46	264.51	618.0
2020-04-08 04:26:00	SPY	ETF	264.36	264.36	264.3	264.3	200.0
2020-04-08 04:27:00	SPY	ETF	264.24	264.32	264.24	264.28	851.0
2020-04-08 04:28:00	SPY	ETF	264.22	264.22	264.04	264.04	1791.0
2020-04-08 04:29:00	SPY	ETF	264.0	264.0	263.85	263.85	2272.0
2020-04-08 04:30:00	SPY	ETF	263.71	263.71	263.42	263.42	2622.0
2020-04-08 04:31:00	SPY	ETF	263.66	263.69	263.66	263.69	1615.0
2020-04-08 04:32:00	SPY	ETF	263.41	263.53	263.28	263.53	4579.0
2020-04-08 04:33:00	SPY	ETF	263.47	263.59	263.47	263.57	1131.0
2020-04-08 04:34:00	SPY	ETF	263.65	263.65	263.5	263.5	510.0
2020-04-08 04:35:00	SPY	ETF	263.5	263.5	263.22	263.27	2665.0
2020-04-08 04:36:00	SPY	ETF	263.28	263.28	263.03	263.2	5652.0
2020-04-08 04:37:00	SPY	ETF	263.3	263.44	263.3	263.38	1407.0
2020-04-08 04:38:00	SPY	ETF	263.26	263.32	263.23	263.23	1009.0
2020-04-08 04:39:00	SPY	ETF	263.22	263.38	263.22	263.38	1206.0
2020-04-08 04:40:00	SPY	ETF	263.51	263.78	263.51	263.78	6951.0
2020-04-08 04:41:00	SPY	ETF	263.59	263.76	263.59	263.76	435.0
2020-04-08 04:42:00	SPY	ETF	263.44	263.44	263.44	263.44	416.0
2020-04-08 04:43:00	SPY	ETF	263.63	263.63	263.63	263.63	111.0
2020-04-08 04:44:00	SPY	ETF	263.66	263.74	263.66	263.74	900.0
2020-04-08 04:45:00	SPY	ETF	263.67	263.81	263.67	263.81	720.0
2020-04-08 04:46:00	SPY	ETF	263.81	264.02	263.81	264.02	1822.0
2020-04-08 04:47:00	SPY	ETF	264.03	264.09	264.03	264.08	2448.0
2020-04-08 04:49:00	SPY	ETF	264.05	264.05	263.94	263.94	520.0
2020-04-08 04:50:00	SPY	ETF	263.87	263.87	263.87	263.87	198.0
2020-04-08 04:52:00	SPY	ETF	263.68	263.78	263.68	263.78	3110.0

> showing 50 of 227,068 rows — these rows as CSV

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