PREVIEW / etf_1min / 2020-09-09

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-09-09.parquet
  size:    3.9 MB
  rows:    212,484

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-09-09 04:00:00	SPY	ETF	335.45	335.75	335.36	335.66	6074.0
2020-09-09 04:01:00	SPY	ETF	335.6	335.93	335.6	335.84	6545.0
2020-09-09 04:02:00	SPY	ETF	336.0	336.19	336.0	336.16	14601.0
2020-09-09 04:03:00	SPY	ETF	336.2	336.3	336.19	336.3	4587.0
2020-09-09 04:04:00	SPY	ETF	336.32	336.83	336.29	336.47	34938.0
2020-09-09 04:05:00	SPY	ETF	336.5	336.67	336.5	336.67	5976.0
2020-09-09 04:06:00	SPY	ETF	336.7	336.74	336.6	336.6	20702.0
2020-09-09 04:07:00	SPY	ETF	336.62	336.65	336.6	336.61	6375.0
2020-09-09 04:08:00	SPY	ETF	336.67	336.7	336.67	336.7	3505.0
2020-09-09 04:09:00	SPY	ETF	336.6	336.68	336.6	336.68	1725.0
2020-09-09 04:10:00	SPY	ETF	336.75	336.8	336.6	336.6	9819.0
2020-09-09 04:11:00	SPY	ETF	336.57	336.57	336.42	336.42	2949.0
2020-09-09 04:12:00	SPY	ETF	336.4	336.4	336.4	336.4	251.0
2020-09-09 04:14:00	SPY	ETF	336.39	336.39	336.39	336.39	415.0
2020-09-09 04:15:00	SPY	ETF	336.42	336.45	336.42	336.45	500.0
2020-09-09 04:16:00	SPY	ETF	336.35	336.37	336.35	336.37	320.0
2020-09-09 04:17:00	SPY	ETF	336.65	336.65	336.65	336.65	220.0
2020-09-09 04:18:00	SPY	ETF	336.54	336.54	336.41	336.41	3400.0
2020-09-09 04:19:00	SPY	ETF	336.3	336.3	336.2	336.25	905.0
2020-09-09 04:20:00	SPY	ETF	336.22	336.25	336.22	336.25	1003.0
2020-09-09 04:21:00	SPY	ETF	336.48	336.48	336.48	336.48	150.0
2020-09-09 04:22:00	SPY	ETF	336.48	336.6	336.48	336.6	906.0
2020-09-09 04:23:00	SPY	ETF	336.68	336.68	336.67	336.67	301.0
2020-09-09 04:24:00	SPY	ETF	336.68	336.68	336.68	336.68	500.0
2020-09-09 04:25:00	SPY	ETF	336.56	336.56	336.37	336.55	6200.0
2020-09-09 04:26:00	SPY	ETF	336.57	336.57	336.37	336.37	918.0
2020-09-09 04:27:00	SPY	ETF	336.38	336.38	336.2	336.2	1811.0
2020-09-09 04:28:00	SPY	ETF	336.18	336.18	336.12	336.12	5520.0
2020-09-09 04:29:00	SPY	ETF	336.17	336.25	336.17	336.22	950.0
2020-09-09 04:30:00	SPY	ETF	336.2	336.2	336.18	336.18	650.0
2020-09-09 04:31:00	SPY	ETF	336.14	336.15	336.12	336.12	4021.0
2020-09-09 04:32:00	SPY	ETF	336.05	336.1	336.05	336.1	832.0
2020-09-09 04:33:00	SPY	ETF	336.0	336.03	336.0	336.03	361.0
2020-09-09 04:37:00	SPY	ETF	336.25	336.25	336.25	336.25	102.0
2020-09-09 04:40:00	SPY	ETF	335.8	335.8	335.62	335.62	2582.0
2020-09-09 04:41:00	SPY	ETF	335.6	335.75	335.57	335.75	2660.0
2020-09-09 04:44:00	SPY	ETF	335.56	335.56	335.55	335.55	2100.0
2020-09-09 04:45:00	SPY	ETF	335.48	335.75	335.48	335.75	1142.0
2020-09-09 04:47:00	SPY	ETF	335.82	335.82	335.82	335.82	305.0
2020-09-09 04:48:00	SPY	ETF	335.73	335.82	335.73	335.82	3700.0
2020-09-09 04:49:00	SPY	ETF	335.85	335.85	335.85	335.85	156.0
2020-09-09 04:50:00	SPY	ETF	336.14	336.14	336.14	336.14	180.0
2020-09-09 04:52:00	SPY	ETF	336.15	336.15	336.05	336.05	210.0
2020-09-09 04:56:00	SPY	ETF	336.1	336.1	336.01	336.01	401.0
2020-09-09 04:58:00	SPY	ETF	335.97	335.97	335.92	335.92	610.0
2020-09-09 04:59:00	SPY	ETF	335.86	335.86	335.86	335.86	190.0
2020-09-09 05:00:00	SPY	ETF	335.7	335.7	335.55	335.7	1492.0
2020-09-09 05:02:00	SPY	ETF	335.51	335.51	335.32	335.32	490.0
2020-09-09 05:04:00	SPY	ETF	335.23	335.33	335.23	335.33	855.0
2020-09-09 05:05:00	SPY	ETF	335.3	335.52	335.3	335.52	1255.0

> showing 50 of 212,484 rows — these rows as CSV

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