PREVIEW / etf_1min / 2020-05-08

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-05-08.parquet
  size:    3.8 MB
  rows:    206,840

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-05-08 04:00:00	SPY	ETF	291.0	291.0	290.8	290.9	9207.0
2020-05-08 04:01:00	SPY	ETF	290.86	290.9	290.85	290.9	5634.0
2020-05-08 04:02:00	SPY	ETF	290.76	290.8	290.74	290.8	4125.0
2020-05-08 04:05:00	SPY	ETF	290.87	290.87	290.84	290.85	2466.0
2020-05-08 04:06:00	SPY	ETF	290.93	290.93	290.93	290.93	165.0
2020-05-08 04:07:00	SPY	ETF	290.97	290.97	290.93	290.93	488.0
2020-05-08 04:10:00	SPY	ETF	290.77	290.77	290.77	290.77	155.0
2020-05-08 04:11:00	SPY	ETF	290.7	290.7	290.7	290.7	140.0
2020-05-08 04:12:00	SPY	ETF	290.85	290.85	290.85	290.85	2530.0
2020-05-08 04:13:00	SPY	ETF	290.85	290.85	290.85	290.85	6200.0
2020-05-08 04:14:00	SPY	ETF	290.7	290.7	290.7	290.7	10080.0
2020-05-08 04:15:00	SPY	ETF	290.62	290.62	290.62	290.62	100.0
2020-05-08 04:18:00	SPY	ETF	290.64	290.64	290.64	290.64	1018.0
2020-05-08 04:21:00	SPY	ETF	290.53	290.53	290.43	290.43	834.0
2020-05-08 04:22:00	SPY	ETF	290.6	290.6	290.6	290.6	403.0
2020-05-08 04:24:00	SPY	ETF	290.63	290.63	290.63	290.63	584.0
2020-05-08 04:25:00	SPY	ETF	290.53	290.53	290.53	290.53	536.0
2020-05-08 04:26:00	SPY	ETF	290.56	290.56	290.56	290.56	557.0
2020-05-08 04:27:00	SPY	ETF	290.6	290.65	290.6	290.65	9490.0
2020-05-08 04:29:00	SPY	ETF	290.65	290.65	290.65	290.65	111.0
2020-05-08 04:31:00	SPY	ETF	290.66	290.66	290.66	290.66	240.0
2020-05-08 04:32:00	SPY	ETF	290.67	290.67	290.67	290.67	140.0
2020-05-08 04:33:00	SPY	ETF	290.76	290.76	290.76	290.76	319.0
2020-05-08 04:35:00	SPY	ETF	290.66	290.66	290.66	290.66	511.0
2020-05-08 04:39:00	SPY	ETF	290.74	290.78	290.74	290.78	304.0
2020-05-08 04:40:00	SPY	ETF	290.76	290.76	290.76	290.76	470.0
2020-05-08 04:41:00	SPY	ETF	290.8	290.8	290.8	290.8	150.0
2020-05-08 04:42:00	SPY	ETF	290.76	290.76	290.76	290.76	100.0
2020-05-08 04:43:00	SPY	ETF	290.8	290.8	290.8	290.8	200.0
2020-05-08 04:44:00	SPY	ETF	290.8	290.8	290.8	290.8	300.0
2020-05-08 04:46:00	SPY	ETF	290.8	290.8	290.76	290.76	623.0
2020-05-08 04:47:00	SPY	ETF	290.83	290.83	290.78	290.78	1000.0
2020-05-08 04:48:00	SPY	ETF	290.78	290.78	290.78	290.78	400.0
2020-05-08 04:50:00	SPY	ETF	290.77	290.77	290.77	290.77	1010.0
2020-05-08 04:54:00	SPY	ETF	290.78	290.78	290.78	290.78	100.0
2020-05-08 04:55:00	SPY	ETF	290.87	290.89	290.87	290.89	1100.0
2020-05-08 04:56:00	SPY	ETF	290.9	290.98	290.9	290.98	4425.0
2020-05-08 04:57:00	SPY	ETF	290.99	290.99	290.99	290.99	282.0
2020-05-08 04:59:00	SPY	ETF	291.0	291.0	290.98	290.98	1914.0
2020-05-08 05:03:00	SPY	ETF	290.85	290.85	290.85	290.85	120.0
2020-05-08 05:07:00	SPY	ETF	290.88	290.88	290.86	290.87	2500.0
2020-05-08 05:09:00	SPY	ETF	290.9	290.9	290.9	290.9	100.0
2020-05-08 05:10:00	SPY	ETF	290.9	290.9	290.9	290.9	1400.0
2020-05-08 05:12:00	SPY	ETF	290.92	290.94	290.89	290.89	600.0
2020-05-08 05:13:00	SPY	ETF	290.97	290.97	290.97	290.97	383.0
2020-05-08 05:15:00	SPY	ETF	291.08	291.15	291.08	291.15	5512.0
2020-05-08 05:16:00	SPY	ETF	291.21	291.21	291.21	291.21	125.0
2020-05-08 05:17:00	SPY	ETF	291.23	291.23	291.23	291.23	551.0
2020-05-08 05:18:00	SPY	ETF	291.13	291.13	291.12	291.12	1500.0
2020-05-08 05:19:00	SPY	ETF	291.09	291.17	291.09	291.17	325.0

> showing 50 of 206,840 rows — these rows as CSV

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