PREVIEW / etf_5min / 2019-10-07

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-10-07.parquet
  size:    1.4 MB
  rows:    59,958

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-10-07 04:00:00	SPY	ETF	293.35	293.35	293.0	293.0	27163.0
2019-10-07 04:05:00	SPY	ETF	293.2	293.2	292.95	292.95	8047.0
2019-10-07 04:10:00	SPY	ETF	292.92	293.03	292.92	293.03	1700.0
2019-10-07 04:15:00	SPY	ETF	293.03	293.09	293.03	293.09	450.0
2019-10-07 04:20:00	SPY	ETF	293.09	293.1	292.93	292.93	2660.0
2019-10-07 04:25:00	SPY	ETF	293.1	293.1	293.04	293.04	850.0
2019-10-07 04:30:00	SPY	ETF	293.02	293.02	293.02	293.02	130.0
2019-10-07 04:40:00	SPY	ETF	293.02	293.14	293.02	293.14	2100.0
2019-10-07 04:45:00	SPY	ETF	293.04	293.04	293.04	293.04	250.0
2019-10-07 04:50:00	SPY	ETF	293.0	293.01	293.0	293.01	1065.0
2019-10-07 04:55:00	SPY	ETF	293.01	293.01	292.88	292.93	6585.0
2019-10-07 05:00:00	SPY	ETF	293.0	293.05	293.0	293.05	700.0
2019-10-07 05:05:00	SPY	ETF	293.1	293.12	292.97	292.98	2875.0
2019-10-07 05:15:00	SPY	ETF	293.02	293.02	292.93	293.0	1200.0
2019-10-07 05:20:00	SPY	ETF	292.91	292.95	292.9	292.9	1100.0
2019-10-07 05:25:00	SPY	ETF	292.98	292.98	292.97	292.97	1000.0
2019-10-07 05:30:00	SPY	ETF	292.97	293.0	292.92	293.0	5200.0
2019-10-07 05:35:00	SPY	ETF	293.05	293.05	293.01	293.01	300.0
2019-10-07 05:40:00	SPY	ETF	293.03	293.06	293.0	293.0	3600.0
2019-10-07 05:45:00	SPY	ETF	293.0	293.12	292.98	293.0	3525.0
2019-10-07 05:50:00	SPY	ETF	293.09	293.09	293.05	293.05	830.0
2019-10-07 05:55:00	SPY	ETF	293.12	293.12	293.0	293.0	550.0
2019-10-07 06:00:00	SPY	ETF	293.03	293.05	292.96	293.0	1831.0
2019-10-07 06:05:00	SPY	ETF	293.07	293.07	293.03	293.03	350.0
2019-10-07 06:10:00	SPY	ETF	293.2	293.32	293.2	293.32	555.0
2019-10-07 06:15:00	SPY	ETF	293.28	293.31	293.28	293.31	340.0
2019-10-07 06:20:00	SPY	ETF	293.34	293.37	293.3	293.37	6200.0
2019-10-07 06:25:00	SPY	ETF	293.42	293.45	293.4	293.44	4831.0
2019-10-07 06:30:00	SPY	ETF	293.41	293.46	293.38	293.45	9800.0
2019-10-07 06:35:00	SPY	ETF	293.44	293.54	293.44	293.44	3900.0
2019-10-07 06:40:00	SPY	ETF	293.44	293.5	293.44	293.5	10250.0
2019-10-07 06:45:00	SPY	ETF	293.48	293.55	293.48	293.55	3505.0
2019-10-07 06:50:00	SPY	ETF	293.61	293.73	293.61	293.71	17222.0
2019-10-07 06:55:00	SPY	ETF	293.74	294.01	293.72	293.97	17155.0
2019-10-07 07:00:00	SPY	ETF	293.99	294.0	293.81	293.88	16472.0
2019-10-07 07:05:00	SPY	ETF	293.88	293.98	293.88	293.98	4111.0
2019-10-07 07:10:00	SPY	ETF	293.95	293.99	293.88	293.92	28684.0
2019-10-07 07:15:00	SPY	ETF	293.89	293.89	293.73	293.74	17541.0
2019-10-07 07:20:00	SPY	ETF	293.74	293.75	293.68	293.68	9705.0
2019-10-07 07:25:00	SPY	ETF	293.68	293.76	293.68	293.76	14950.0
2019-10-07 07:30:00	SPY	ETF	293.77	293.86	293.77	293.83	3129.0
2019-10-07 07:35:00	SPY	ETF	293.85	293.98	293.85	293.92	3955.0
2019-10-07 07:40:00	SPY	ETF	293.9	293.97	293.83	293.85	19460.0
2019-10-07 07:45:00	SPY	ETF	293.85	293.9	293.7	293.73	34978.0
2019-10-07 07:50:00	SPY	ETF	293.72	293.8	293.71	293.73	13876.0
2019-10-07 07:55:00	SPY	ETF	293.73	293.73	293.64	293.68	31212.0
2019-10-07 08:00:00	SPY	ETF	293.74	294.0	292.97	293.65	21895.0
2019-10-07 08:05:00	SPY	ETF	293.65	293.77	293.63	293.74	28257.0
2019-10-07 08:10:00	SPY	ETF	293.7	293.73	293.64	293.73	22033.0
2019-10-07 08:15:00	SPY	ETF	293.74	293.91	293.69	293.88	56597.0

> showing 50 of 59,958 rows — these rows as CSV

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