PREVIEW / etf_1min / 2019-08-23

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-08-23.parquet
  size:    3.6 MB
  rows:    180,021

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-23 04:00:00	SPY	ETF	293.14	293.14	293.1	293.1	646.0
2019-08-23 04:01:00	SPY	ETF	293.12	293.12	293.12	293.12	110.0
2019-08-23 04:02:00	SPY	ETF	293.1	293.1	293.1	293.1	279.0
2019-08-23 04:05:00	SPY	ETF	293.2	293.27	293.2	293.27	2711.0
2019-08-23 04:11:00	SPY	ETF	293.17	293.17	293.17	293.17	500.0
2019-08-23 04:12:00	SPY	ETF	293.22	293.22	293.22	293.22	500.0
2019-08-23 04:19:00	SPY	ETF	293.25	293.25	293.25	293.25	500.0
2019-08-23 04:20:00	SPY	ETF	293.32	293.32	293.32	293.32	500.0
2019-08-23 04:28:00	SPY	ETF	293.42	293.42	293.42	293.42	529.0
2019-08-23 04:30:00	SPY	ETF	293.42	293.42	293.42	293.42	250.0
2019-08-23 04:31:00	SPY	ETF	293.47	293.47	293.47	293.47	125.0
2019-08-23 04:32:00	SPY	ETF	293.5	293.5	293.5	293.5	600.0
2019-08-23 04:34:00	SPY	ETF	293.5	293.5	293.5	293.5	500.0
2019-08-23 04:45:00	SPY	ETF	293.46	293.46	293.46	293.46	400.0
2019-08-23 04:49:00	SPY	ETF	293.44	293.44	293.44	293.44	1000.0
2019-08-23 04:52:00	SPY	ETF	293.34	293.34	293.34	293.34	1000.0
2019-08-23 04:55:00	SPY	ETF	293.39	293.39	293.39	293.39	300.0
2019-08-23 05:00:00	SPY	ETF	293.35	293.35	293.35	293.35	500.0
2019-08-23 05:01:00	SPY	ETF	293.38	293.38	293.38	293.38	500.0
2019-08-23 05:10:00	SPY	ETF	293.48	293.48	293.48	293.48	600.0
2019-08-23 05:41:00	SPY	ETF	293.28	293.28	293.28	293.28	500.0
2019-08-23 05:51:00	SPY	ETF	293.14	293.19	293.14	293.19	1300.0
2019-08-23 05:52:00	SPY	ETF	293.19	293.19	293.19	293.19	300.0
2019-08-23 05:53:00	SPY	ETF	293.19	293.19	293.19	293.19	1200.0
2019-08-23 05:54:00	SPY	ETF	293.18	293.18	293.18	293.18	400.0
2019-08-23 05:55:00	SPY	ETF	293.3	293.3	293.3	293.3	504.0
2019-08-23 05:56:00	SPY	ETF	293.31	293.31	293.31	293.31	1000.0
2019-08-23 05:57:00	SPY	ETF	293.29	293.29	293.29	293.29	600.0
2019-08-23 06:04:00	SPY	ETF	293.28	293.28	293.28	293.28	100.0
2019-08-23 06:06:00	SPY	ETF	293.29	293.29	293.29	293.29	352.0
2019-08-23 06:16:00	SPY	ETF	293.14	293.14	293.14	293.14	5000.0
2019-08-23 06:21:00	SPY	ETF	293.18	293.18	293.18	293.18	700.0
2019-08-23 06:24:00	SPY	ETF	293.13	293.13	293.13	293.13	500.0
2019-08-23 06:26:00	SPY	ETF	293.1	293.1	293.1	293.1	300.0
2019-08-23 06:28:00	SPY	ETF	293.1	293.1	293.1	293.1	144.0
2019-08-23 06:36:00	SPY	ETF	292.9	292.9	292.83	292.83	604.0
2019-08-23 06:37:00	SPY	ETF	292.82	292.82	292.8	292.8	1354.0
2019-08-23 06:38:00	SPY	ETF	292.74	292.74	292.74	292.74	310.0
2019-08-23 06:39:00	SPY	ETF	292.7	292.7	292.7	292.7	500.0
2019-08-23 06:40:00	SPY	ETF	292.8	292.8	292.8	292.8	410.0
2019-08-23 06:47:00	SPY	ETF	292.83	292.83	292.83	292.83	400.0
2019-08-23 06:49:00	SPY	ETF	292.85	292.85	292.85	292.85	1100.0
2019-08-23 06:51:00	SPY	ETF	292.75	292.75	292.75	292.75	2500.0
2019-08-23 06:52:00	SPY	ETF	292.75	292.75	292.75	292.75	220.0
2019-08-23 06:53:00	SPY	ETF	292.75	292.8	292.75	292.8	400.0
2019-08-23 06:54:00	SPY	ETF	292.8	292.8	292.8	292.8	300.0
2019-08-23 06:57:00	SPY	ETF	292.7	292.7	292.7	292.7	1005.0
2019-08-23 06:59:00	SPY	ETF	292.81	292.85	292.81	292.85	386.0
2019-08-23 07:00:00	SPY	ETF	292.89	292.89	292.86	292.86	430.0
2019-08-23 07:01:00	SPY	ETF	292.86	293.0	292.86	293.0	1303.0

> showing 50 of 180,021 rows — these rows as CSV

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