PREVIEW / etf_1min / 2019-08-13

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-13.parquet
  size:    3.3 MB
  rows:    175,362

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
2019-08-13 04:00:00	SPY	ETF	287.2	287.49	287.2	287.42	3932.0
2019-08-13 04:03:00	SPY	ETF	287.35	287.35	287.32	287.32	1101.0
2019-08-13 04:05:00	SPY	ETF	287.3	287.37	287.3	287.37	401.0
2019-08-13 04:06:00	SPY	ETF	287.3	287.3	287.3	287.3	200.0
2019-08-13 04:07:00	SPY	ETF	287.22	287.22	287.22	287.22	200.0
2019-08-13 04:10:00	SPY	ETF	287.15	287.17	287.12	287.17	1600.0
2019-08-13 04:13:00	SPY	ETF	287.4	287.43	287.4	287.43	1050.0
2019-08-13 04:17:00	SPY	ETF	287.6	287.6	287.6	287.6	100.0
2019-08-13 04:20:00	SPY	ETF	287.48	287.48	287.48	287.48	830.0
2019-08-13 04:21:00	SPY	ETF	287.6	287.6	287.6	287.6	1000.0
2019-08-13 04:27:00	SPY	ETF	287.55	287.55	287.55	287.55	490.0
2019-08-13 04:29:00	SPY	ETF	287.5	287.5	287.5	287.5	500.0
2019-08-13 04:31:00	SPY	ETF	287.47	287.47	287.4	287.4	1100.0
2019-08-13 04:34:00	SPY	ETF	287.7	287.7	287.7	287.7	104.0
2019-08-13 04:38:00	SPY	ETF	287.69	287.77	287.69	287.77	350.0
2019-08-13 04:41:00	SPY	ETF	288.0	288.0	287.79	287.79	227.0
2019-08-13 04:42:00	SPY	ETF	287.92	287.92	287.92	287.92	100.0
2019-08-13 04:44:00	SPY	ETF	287.93	287.93	287.93	287.93	150.0
2019-08-13 04:52:00	SPY	ETF	287.98	287.98	287.88	287.88	240.0
2019-08-13 04:53:00	SPY	ETF	288.02	288.02	288.02	288.02	110.0
2019-08-13 05:00:00	SPY	ETF	287.88	287.88	287.88	287.88	110.0
2019-08-13 05:01:00	SPY	ETF	287.83	287.83	287.83	287.83	155.0
2019-08-13 05:02:00	SPY	ETF	287.63	287.63	287.63	287.63	304.0
2019-08-13 05:03:00	SPY	ETF	287.62	287.62	287.62	287.62	300.0
2019-08-13 05:04:00	SPY	ETF	287.62	287.62	287.62	287.62	100.0
2019-08-13 05:10:00	SPY	ETF	287.7	287.7	287.7	287.7	500.0
2019-08-13 05:12:00	SPY	ETF	287.3	287.3	287.1	287.13	1708.0
2019-08-13 05:14:00	SPY	ETF	287.16	287.19	287.16	287.19	600.0
2019-08-13 05:15:00	SPY	ETF	287.16	287.16	287.08	287.08	560.0
2019-08-13 05:16:00	SPY	ETF	287.02	287.02	286.96	286.96	1761.0
2019-08-13 05:18:00	SPY	ETF	287.05	287.05	287.05	287.05	800.0
2019-08-13 05:19:00	SPY	ETF	287.14	287.14	287.08	287.08	1416.0
2019-08-13 05:21:00	SPY	ETF	286.93	286.93	286.93	286.93	203.0
2019-08-13 05:23:00	SPY	ETF	286.92	286.92	286.88	286.88	1409.0
2019-08-13 05:28:00	SPY	ETF	286.88	286.88	286.78	286.78	855.0
2019-08-13 05:29:00	SPY	ETF	286.88	286.88	286.88	286.88	365.0
2019-08-13 05:30:00	SPY	ETF	286.72	286.72	286.63	286.63	1590.0
2019-08-13 05:31:00	SPY	ETF	286.71	286.71	286.66	286.66	525.0
2019-08-13 05:32:00	SPY	ETF	286.63	286.63	286.55	286.55	465.0
2019-08-13 05:33:00	SPY	ETF	286.53	286.53	286.5	286.5	750.0
2019-08-13 05:34:00	SPY	ETF	286.5	286.53	286.5	286.53	370.0
2019-08-13 05:35:00	SPY	ETF	286.5	286.66	286.5	286.66	1532.0
2019-08-13 05:36:00	SPY	ETF	286.7	286.71	286.6	286.6	6250.0
2019-08-13 05:37:00	SPY	ETF	286.7	286.71	286.63	286.63	1100.0
2019-08-13 05:38:00	SPY	ETF	286.68	286.76	286.68	286.76	600.0
2019-08-13 05:39:00	SPY	ETF	286.8	286.8	286.8	286.8	292.0
2019-08-13 05:40:00	SPY	ETF	286.68	286.78	286.68	286.74	2210.0
2019-08-13 05:41:00	SPY	ETF	286.66	286.66	286.66	286.66	1075.0
2019-08-13 05:42:00	SPY	ETF	286.83	286.9	286.83	286.9	2000.0
2019-08-13 05:43:00	SPY	ETF	286.88	286.88	286.83	286.83	714.0

> showing 50 of 175,362 rows — these rows as CSV

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