PREVIEW / etf_1min / 2020-07-23

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-07-23.parquet
  size:    3.8 MB
  rows:    214,598

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-07-23 04:00:00	SPY	ETF	328.15	328.35	328.12	328.2	3679.0
2020-07-23 04:01:00	SPY	ETF	328.31	328.31	328.16	328.16	2025.0
2020-07-23 04:02:00	SPY	ETF	328.19	328.19	328.18	328.18	490.0
2020-07-23 04:03:00	SPY	ETF	328.09	328.09	328.05	328.05	852.0
2020-07-23 04:04:00	SPY	ETF	328.04	328.04	328.01	328.01	2021.0
2020-07-23 04:05:00	SPY	ETF	328.04	328.06	328.04	328.06	1258.0
2020-07-23 04:06:00	SPY	ETF	328.05	328.05	328.01	328.01	225.0
2020-07-23 04:09:00	SPY	ETF	328.27	328.33	328.27	328.33	2570.0
2020-07-23 04:14:00	SPY	ETF	328.24	328.24	328.24	328.24	200.0
2020-07-23 04:19:00	SPY	ETF	328.44	328.44	328.44	328.44	820.0
2020-07-23 04:20:00	SPY	ETF	328.51	328.51	328.51	328.51	2500.0
2020-07-23 04:22:00	SPY	ETF	328.46	328.46	328.46	328.46	330.0
2020-07-23 04:25:00	SPY	ETF	328.41	328.41	328.41	328.41	100.0
2020-07-23 04:26:00	SPY	ETF	328.41	328.43	328.41	328.43	750.0
2020-07-23 04:30:00	SPY	ETF	328.39	328.46	328.39	328.46	1349.0
2020-07-23 04:33:00	SPY	ETF	328.33	328.33	328.33	328.33	105.0
2020-07-23 04:41:00	SPY	ETF	328.31	328.31	328.31	328.31	100.0
2020-07-23 04:45:00	SPY	ETF	328.24	328.26	328.2	328.2	1885.0
2020-07-23 04:47:00	SPY	ETF	328.16	328.16	328.16	328.16	1000.0
2020-07-23 04:49:00	SPY	ETF	328.11	328.11	328.0	328.0	873.0
2020-07-23 04:50:00	SPY	ETF	327.87	327.87	327.8	327.8	525.0
2020-07-23 04:52:00	SPY	ETF	327.84	327.84	327.84	327.84	314.0
2020-07-23 04:53:00	SPY	ETF	327.91	327.91	327.91	327.91	1000.0
2020-07-23 04:54:00	SPY	ETF	327.89	327.89	327.89	327.89	213.0
2020-07-23 04:55:00	SPY	ETF	327.93	327.93	327.93	327.93	407.0
2020-07-23 04:57:00	SPY	ETF	327.84	327.84	327.84	327.84	500.0
2020-07-23 04:58:00	SPY	ETF	327.77	327.77	327.61	327.69	2711.0
2020-07-23 04:59:00	SPY	ETF	327.69	327.69	327.57	327.57	700.0
2020-07-23 05:01:00	SPY	ETF	327.56	327.56	327.56	327.56	100.0
2020-07-23 05:02:00	SPY	ETF	327.72	327.73	327.72	327.73	1310.0
2020-07-23 05:04:00	SPY	ETF	327.64	327.64	327.64	327.64	400.0
2020-07-23 05:06:00	SPY	ETF	327.76	327.76	327.76	327.76	406.0
2020-07-23 05:10:00	SPY	ETF	327.83	327.83	327.83	327.83	100.0
2020-07-23 05:11:00	SPY	ETF	327.84	327.84	327.84	327.84	1260.0
2020-07-23 05:13:00	SPY	ETF	327.89	327.89	327.89	327.89	625.0
2020-07-23 05:16:00	SPY	ETF	327.9	327.9	327.9	327.9	140.0
2020-07-23 05:21:00	SPY	ETF	327.84	327.84	327.84	327.84	400.0
2020-07-23 05:25:00	SPY	ETF	327.87	327.87	327.87	327.87	500.0
2020-07-23 05:27:00	SPY	ETF	327.86	327.86	327.86	327.86	125.0
2020-07-23 05:28:00	SPY	ETF	327.91	327.91	327.91	327.91	202.0
2020-07-23 05:29:00	SPY	ETF	327.94	327.94	327.94	327.94	125.0
2020-07-23 05:34:00	SPY	ETF	327.98	327.98	327.98	327.98	125.0
2020-07-23 05:43:00	SPY	ETF	327.75	327.79	327.75	327.79	2630.0
2020-07-23 05:44:00	SPY	ETF	327.76	327.76	327.75	327.76	2000.0
2020-07-23 05:47:00	SPY	ETF	327.76	327.76	327.75	327.75	1511.0
2020-07-23 05:48:00	SPY	ETF	327.79	327.79	327.79	327.79	237.0
2020-07-23 05:49:00	SPY	ETF	327.74	327.74	327.74	327.74	3300.0
2020-07-23 05:54:00	SPY	ETF	327.7	327.81	327.7	327.81	210.0
2020-07-23 05:55:00	SPY	ETF	327.8	327.8	327.8	327.8	100.0
2020-07-23 05:59:00	SPY	ETF	327.84	327.85	327.84	327.85	3256.0

> showing 50 of 214,598 rows — these rows as CSV

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