PREVIEW / etf_5min / 2019-09-06

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-06.parquet
  size:    1.4 MB
  rows:    61,202

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-09-06 04:00:00	SPY	ETF	298.12	298.12	298.05	298.08	485.0
2019-09-06 04:05:00	SPY	ETF	298.08	298.08	298.07	298.07	570.0
2019-09-06 04:10:00	SPY	ETF	298.06	298.06	298.05	298.05	251.0
2019-09-06 04:15:00	SPY	ETF	298.04	298.06	298.04	298.06	750.0
2019-09-06 04:20:00	SPY	ETF	298.08	298.08	298.08	298.08	100.0
2019-09-06 04:25:00	SPY	ETF	298.0	298.07	298.0	298.07	600.0
2019-09-06 04:30:00	SPY	ETF	298.12	298.12	298.03	298.03	200.0
2019-09-06 04:35:00	SPY	ETF	298.05	298.14	298.05	298.14	4500.0
2019-09-06 04:40:00	SPY	ETF	298.08	298.08	298.08	298.08	500.0
2019-09-06 04:50:00	SPY	ETF	298.03	298.03	298.03	298.03	300.0
2019-09-06 05:10:00	SPY	ETF	298.25	298.27	298.25	298.25	16201.0
2019-09-06 05:15:00	SPY	ETF	298.32	298.32	298.27	298.27	1860.0
2019-09-06 05:20:00	SPY	ETF	298.33	298.66	298.33	298.47	1200.0
2019-09-06 05:25:00	SPY	ETF	298.55	298.55	298.55	298.55	174.0
2019-09-06 05:30:00	SPY	ETF	298.3	298.4	298.3	298.4	2530.0
2019-09-06 05:35:00	SPY	ETF	298.47	298.47	298.47	298.47	225.0
2019-09-06 05:40:00	SPY	ETF	298.55	298.55	298.32	298.32	698.0
2019-09-06 05:45:00	SPY	ETF	298.25	298.25	298.2	298.2	1050.0
2019-09-06 05:50:00	SPY	ETF	298.1	298.2	298.1	298.15	1815.0
2019-09-06 05:55:00	SPY	ETF	298.15	298.15	298.01	298.01	2800.0
2019-09-06 06:00:00	SPY	ETF	298.0	298.05	297.89	297.9	7601.0
2019-09-06 06:05:00	SPY	ETF	297.9	297.92	297.9	297.92	1816.0
2019-09-06 06:10:00	SPY	ETF	297.93	297.93	297.9	297.91	810.0
2019-09-06 06:15:00	SPY	ETF	297.92	298.13	297.92	298.12	2524.0
2019-09-06 06:20:00	SPY	ETF	298.12	298.12	298.1	298.12	1258.0
2019-09-06 06:25:00	SPY	ETF	298.07	298.12	298.07	298.1	500.0
2019-09-06 06:30:00	SPY	ETF	298.17	298.17	298.17	298.17	499.0
2019-09-06 06:35:00	SPY	ETF	298.2	298.2	298.05	298.07	2139.0
2019-09-06 06:45:00	SPY	ETF	298.2	298.25	298.15	298.15	12700.0
2019-09-06 06:50:00	SPY	ETF	298.15	298.33	298.15	298.33	10475.0
2019-09-06 06:55:00	SPY	ETF	298.24	298.24	298.21	298.22	6095.0
2019-09-06 07:00:00	SPY	ETF	298.24	298.36	298.18	298.27	7750.0
2019-09-06 07:05:00	SPY	ETF	298.33	298.36	298.28	298.34	6754.0
2019-09-06 07:10:00	SPY	ETF	298.35	298.4	298.25	298.25	10680.0
2019-09-06 07:15:00	SPY	ETF	298.25	298.35	298.25	298.35	10100.0
2019-09-06 07:20:00	SPY	ETF	298.31	298.35	298.3	298.33	16593.0
2019-09-06 07:25:00	SPY	ETF	298.33	298.4	298.3	298.3	41231.0
2019-09-06 07:30:00	SPY	ETF	298.3	298.55	298.3	298.55	228984.0
2019-09-06 07:35:00	SPY	ETF	298.47	298.62	298.39	298.61	25366.0
2019-09-06 07:40:00	SPY	ETF	298.58	298.61	298.52	298.57	18613.0
2019-09-06 07:45:00	SPY	ETF	298.53	298.55	298.5	298.55	26129.0
2019-09-06 07:50:00	SPY	ETF	298.55	298.64	298.52	298.55	21209.0
2019-09-06 07:55:00	SPY	ETF	298.55	298.6	298.52	298.6	19462.0
2019-09-06 08:00:00	SPY	ETF	298.2699	298.67	297.88	298.57	58206.0
2019-09-06 08:05:00	SPY	ETF	298.53	298.67	298.02	298.67	24056.0
2019-09-06 08:10:00	SPY	ETF	298.68	298.89	298.62	298.82	64231.0
2019-09-06 08:15:00	SPY	ETF	298.85	298.85	298.66	298.66	62163.0
2019-09-06 08:20:00	SPY	ETF	298.61	298.71	298.61	298.69	43193.0
2019-09-06 08:25:00	SPY	ETF	298.7	298.8	298.5	298.73	73353.0
2019-09-06 08:30:00	SPY	ETF	298.52	298.63	298.0	298.4	411778.0

> showing 50 of 61,202 rows — these rows as CSV

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