PREVIEW / etf_1min / 2020-04-27

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-04-27.parquet
  size:    4.1 MB
  rows:    213,659

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-27 04:00:00	SPY	ETF	285.69	285.8	285.58	285.7	5990.0
2020-04-27 04:01:00	SPY	ETF	285.6	285.6	285.34	285.35	8313.0
2020-04-27 04:02:00	SPY	ETF	285.38	285.38	285.35	285.35	1350.0
2020-04-27 04:03:00	SPY	ETF	285.3	285.36	285.3	285.36	7520.0
2020-04-27 04:05:00	SPY	ETF	285.37	285.45	285.37	285.45	2102.0
2020-04-27 04:07:00	SPY	ETF	285.45	285.5	285.45	285.45	9965.0
2020-04-27 04:09:00	SPY	ETF	285.33	285.33	285.2	285.23	993.0
2020-04-27 04:10:00	SPY	ETF	285.23	285.23	285.23	285.23	2609.0
2020-04-27 04:11:00	SPY	ETF	285.3	285.3	285.3	285.3	1005.0
2020-04-27 04:12:00	SPY	ETF	285.35	285.35	285.35	285.35	2511.0
2020-04-27 04:13:00	SPY	ETF	285.35	285.41	285.35	285.36	1030.0
2020-04-27 04:14:00	SPY	ETF	285.41	285.41	285.35	285.35	3220.0
2020-04-27 04:15:00	SPY	ETF	285.06	285.06	285.0	285.0	3175.0
2020-04-27 04:16:00	SPY	ETF	284.89	284.89	284.89	284.89	257.0
2020-04-27 04:17:00	SPY	ETF	284.98	284.99	284.98	284.99	1435.0
2020-04-27 04:18:00	SPY	ETF	284.98	285.04	284.98	285.04	614.0
2020-04-27 04:20:00	SPY	ETF	284.97	285.04	284.93	285.04	2242.0
2020-04-27 04:21:00	SPY	ETF	285.08	285.08	285.08	285.08	300.0
2020-04-27 04:23:00	SPY	ETF	285.24	285.24	285.24	285.24	1458.0
2020-04-27 04:24:00	SPY	ETF	285.32	285.32	285.32	285.32	100.0
2020-04-27 04:25:00	SPY	ETF	285.33	285.38	285.33	285.38	1382.0
2020-04-27 04:26:00	SPY	ETF	285.44	285.44	285.38	285.38	789.0
2020-04-27 04:27:00	SPY	ETF	285.38	285.38	285.31	285.31	365.0
2020-04-27 04:28:00	SPY	ETF	285.35	285.35	285.3	285.3	371.0
2020-04-27 04:29:00	SPY	ETF	285.3	285.3	285.23	285.23	1622.0
2020-04-27 04:30:00	SPY	ETF	285.18	285.18	285.18	285.18	121.0
2020-04-27 04:31:00	SPY	ETF	284.98	285.02	284.98	285.0	1301.0
2020-04-27 04:33:00	SPY	ETF	285.08	285.13	285.03	285.09	1210.0
2020-04-27 04:34:00	SPY	ETF	285.14	285.25	285.14	285.25	938.0
2020-04-27 04:35:00	SPY	ETF	285.3	285.41	285.3	285.38	486.0
2020-04-27 04:36:00	SPY	ETF	285.41	285.41	285.37	285.41	5036.0
2020-04-27 04:37:00	SPY	ETF	285.36	285.44	285.36	285.44	1130.0
2020-04-27 04:38:00	SPY	ETF	285.53	285.53	285.53	285.53	1267.0
2020-04-27 04:39:00	SPY	ETF	285.55	285.65	285.55	285.65	1535.0
2020-04-27 04:41:00	SPY	ETF	285.75	285.9	285.75	285.9	7867.0
2020-04-27 04:44:00	SPY	ETF	285.61	285.61	285.55	285.55	10931.0
2020-04-27 04:45:00	SPY	ETF	285.59	285.62	285.59	285.62	10520.0
2020-04-27 04:46:00	SPY	ETF	285.62	285.62	285.62	285.62	9500.0
2020-04-27 04:47:00	SPY	ETF	285.6	285.61	285.6	285.61	426.0
2020-04-27 04:48:00	SPY	ETF	285.6	285.6	285.6	285.6	6992.0
2020-04-27 04:49:00	SPY	ETF	285.56	285.56	285.56	285.56	1149.0
2020-04-27 04:50:00	SPY	ETF	285.66	285.67	285.66	285.67	7000.0
2020-04-27 04:53:00	SPY	ETF	285.51	285.51	285.51	285.51	100.0
2020-04-27 04:54:00	SPY	ETF	285.57	285.59	285.57	285.59	9300.0
2020-04-27 04:55:00	SPY	ETF	285.7	285.7	285.7	285.7	2000.0
2020-04-27 04:56:00	SPY	ETF	285.65	285.65	285.65	285.65	107.0
2020-04-27 04:57:00	SPY	ETF	285.61	285.61	285.59	285.59	1642.0
2020-04-27 05:01:00	SPY	ETF	285.61	285.63	285.61	285.63	3054.0
2020-04-27 05:04:00	SPY	ETF	285.25	285.25	285.25	285.25	301.0
2020-04-27 05:06:00	SPY	ETF	285.37	285.44	285.36	285.44	2500.0

> showing 50 of 213,659 rows — these rows as CSV

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