PREVIEW / etf_1min / 2020-09-18

all etf 1-min files

  file:    by_date/etf_1min/2020/2020-09-18.parquet
  size:    3.6 MB
  rows:    194,848

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-18 04:00:00	SPY	ETF	334.51	334.51	334.51	334.51	1298.0
2020-09-18 04:01:00	SPY	ETF	334.44	334.44	334.33	334.33	332.0
2020-09-18 04:02:00	SPY	ETF	334.39	334.45	334.39	334.45	860.0
2020-09-18 04:05:00	SPY	ETF	334.55	334.55	334.5	334.5	2059.0
2020-09-18 04:06:00	SPY	ETF	334.47	334.47	334.47	334.47	443.0
2020-09-18 04:07:00	SPY	ETF	334.49	334.52	334.49	334.52	400.0
2020-09-18 04:08:00	SPY	ETF	334.57	334.57	334.55	334.55	1901.0
2020-09-18 04:09:00	SPY	ETF	334.59	334.62	334.59	334.6	34409.0
2020-09-18 04:10:00	SPY	ETF	334.6	334.61	334.45	334.61	9900.0
2020-09-18 04:11:00	SPY	ETF	334.72	334.72	334.72	334.72	208.0
2020-09-18 04:13:00	SPY	ETF	334.86	334.86	334.86	334.86	611.0
2020-09-18 04:15:00	SPY	ETF	334.93	334.95	334.92	334.95	800.0
2020-09-18 04:17:00	SPY	ETF	335.04	335.05	335.04	335.05	450.0
2020-09-18 04:18:00	SPY	ETF	335.12	335.12	335.09	335.09	1779.0
2020-09-18 04:19:00	SPY	ETF	335.16	335.16	335.16	335.16	105.0
2020-09-18 04:20:00	SPY	ETF	335.04	335.1	335.04	335.05	10201.0
2020-09-18 04:21:00	SPY	ETF	335.07	335.1	335.05	335.1	56100.0
2020-09-18 04:27:00	SPY	ETF	335.0	335.0	335.0	335.0	200.0
2020-09-18 04:32:00	SPY	ETF	334.86	334.86	334.86	334.86	219.0
2020-09-18 04:34:00	SPY	ETF	334.71	334.71	334.71	334.71	1645.0
2020-09-18 04:35:00	SPY	ETF	334.63	334.63	334.59	334.59	617.0
2020-09-18 04:37:00	SPY	ETF	334.59	334.59	334.59	334.59	210.0
2020-09-18 04:38:00	SPY	ETF	334.69	334.79	334.69	334.79	1190.0
2020-09-18 04:42:00	SPY	ETF	334.81	334.81	334.81	334.81	310.0
2020-09-18 04:49:00	SPY	ETF	334.67	334.67	334.66	334.66	1620.0
2020-09-18 04:50:00	SPY	ETF	334.76	334.76	334.76	334.76	145.0
2020-09-18 04:58:00	SPY	ETF	334.77	334.79	334.76	334.79	1105.0
2020-09-18 05:02:00	SPY	ETF	334.76	334.76	334.76	334.76	855.0
2020-09-18 05:04:00	SPY	ETF	334.83	334.83	334.83	334.83	445.0
2020-09-18 05:05:00	SPY	ETF	334.91	334.91	334.77	334.82	3485.0
2020-09-18 05:07:00	SPY	ETF	334.68	334.68	334.64	334.64	1946.0
2020-09-18 05:08:00	SPY	ETF	334.77	334.78	334.77	334.78	840.0
2020-09-18 05:09:00	SPY	ETF	334.85	334.85	334.85	334.85	520.0
2020-09-18 05:10:00	SPY	ETF	334.79	334.79	334.79	334.79	335.0
2020-09-18 05:11:00	SPY	ETF	334.91	334.91	334.91	334.91	245.0
2020-09-18 05:13:00	SPY	ETF	335.02	335.11	335.02	335.11	686.0
2020-09-18 05:14:00	SPY	ETF	335.15	335.21	335.15	335.16	1393.0
2020-09-18 05:15:00	SPY	ETF	335.16	335.17	335.16	335.17	2000.0
2020-09-18 05:19:00	SPY	ETF	335.23	335.23	335.23	335.23	236.0
2020-09-18 05:20:00	SPY	ETF	335.23	335.23	335.17	335.17	705.0
2020-09-18 05:27:00	SPY	ETF	335.22	335.22	335.22	335.22	105.0
2020-09-18 05:31:00	SPY	ETF	335.27	335.27	335.27	335.27	479.0
2020-09-18 05:32:00	SPY	ETF	335.37	335.37	335.37	335.37	299.0
2020-09-18 05:34:00	SPY	ETF	335.51	335.51	335.47	335.47	275.0
2020-09-18 05:35:00	SPY	ETF	335.36	335.36	335.29	335.29	2575.0
2020-09-18 05:38:00	SPY	ETF	335.5	335.5	335.5	335.5	555.0
2020-09-18 05:40:00	SPY	ETF	335.5	335.5	335.5	335.5	1025.0
2020-09-18 05:45:00	SPY	ETF	335.39	335.42	335.39	335.42	1027.0
2020-09-18 05:48:00	SPY	ETF	335.35	335.35	335.3	335.3	615.0
2020-09-18 05:50:00	SPY	ETF	335.0	335.03	335.0	335.03	612.0

> showing 50 of 194,848 rows — these rows as CSV

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