PREVIEW / etf_5min / 2019-10-04

all etf 5-min files

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

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-04 04:00:00	SPY	ETF	290.25	290.25	290.03	290.14	2221.0
2019-10-04 04:05:00	SPY	ETF	290.17	290.3	290.13	290.23	5950.0
2019-10-04 04:10:00	SPY	ETF	290.15	290.15	290.15	290.15	300.0
2019-10-04 04:15:00	SPY	ETF	290.03	290.17	290.03	290.17	400.0
2019-10-04 04:20:00	SPY	ETF	290.22	290.33	290.2	290.2	5700.0
2019-10-04 04:25:00	SPY	ETF	290.23	290.23	290.0	290.0	5830.0
2019-10-04 04:30:00	SPY	ETF	290.0	290.03	290.0	290.01	1700.0
2019-10-04 04:35:00	SPY	ETF	290.03	290.05	290.03	290.05	500.0
2019-10-04 04:40:00	SPY	ETF	289.98	289.99	289.89	289.91	4800.0
2019-10-04 04:45:00	SPY	ETF	289.9	289.9	289.83	289.83	350.0
2019-10-04 04:50:00	SPY	ETF	289.88	289.88	289.78	289.78	415.0
2019-10-04 04:55:00	SPY	ETF	289.75	289.84	289.75	289.82	3865.0
2019-10-04 05:00:00	SPY	ETF	289.8	289.8	289.71	289.71	202.0
2019-10-04 05:05:00	SPY	ETF	289.73	289.78	289.73	289.78	1720.0
2019-10-04 05:10:00	SPY	ETF	289.78	289.78	289.77	289.77	700.0
2019-10-04 05:20:00	SPY	ETF	289.88	289.88	289.86	289.86	300.0
2019-10-04 05:25:00	SPY	ETF	289.76	289.76	289.74	289.74	400.0
2019-10-04 05:30:00	SPY	ETF	289.59	289.59	289.59	289.59	102.0
2019-10-04 05:35:00	SPY	ETF	289.48	289.48	289.39	289.39	2077.0
2019-10-04 05:40:00	SPY	ETF	289.39	289.47	289.36	289.47	3566.0
2019-10-04 05:45:00	SPY	ETF	289.54	289.54	289.54	289.54	1000.0
2019-10-04 05:50:00	SPY	ETF	289.55	289.57	289.38	289.38	6635.0
2019-10-04 05:55:00	SPY	ETF	289.45	289.49	289.4	289.4	5200.0
2019-10-04 06:00:00	SPY	ETF	289.4	289.66	289.4	289.6	2400.0
2019-10-04 06:05:00	SPY	ETF	289.62	289.7	289.62	289.7	3155.0
2019-10-04 06:10:00	SPY	ETF	289.67	289.74	289.67	289.7	3840.0
2019-10-04 06:15:00	SPY	ETF	289.65	289.7	289.65	289.7	17590.0
2019-10-04 06:20:00	SPY	ETF	289.7	289.7	289.47	289.52	3506.0
2019-10-04 06:25:00	SPY	ETF	289.52	289.52	289.44	289.45	4131.0
2019-10-04 06:30:00	SPY	ETF	289.53	289.57	289.5	289.5	2580.0
2019-10-04 06:35:00	SPY	ETF	289.55	289.55	289.39	289.39	5113.0
2019-10-04 06:40:00	SPY	ETF	289.35	289.38	289.2	289.2	13134.0
2019-10-04 06:45:00	SPY	ETF	289.22	289.28	289.22	289.28	2200.0
2019-10-04 06:50:00	SPY	ETF	289.4	289.49	289.4	289.44	10511.0
2019-10-04 06:55:00	SPY	ETF	289.49	289.6	289.44	289.44	6770.0
2019-10-04 07:00:00	SPY	ETF	289.36	289.45	289.35	289.38	16898.0
2019-10-04 07:05:00	SPY	ETF	289.47	289.47	289.35	289.37	14946.0
2019-10-04 07:10:00	SPY	ETF	289.33	289.42	289.3	289.38	20829.0
2019-10-04 07:15:00	SPY	ETF	289.38	289.41	289.36	289.38	15183.0
2019-10-04 07:20:00	SPY	ETF	289.4	289.48	289.4	289.41	10736.0
2019-10-04 07:25:00	SPY	ETF	289.43	289.45	289.41	289.43	26141.0
2019-10-04 07:30:00	SPY	ETF	289.44	289.49	289.39	289.42	22708.0
2019-10-04 07:35:00	SPY	ETF	289.4	289.56	289.4	289.56	32580.0
2019-10-04 07:40:00	SPY	ETF	289.53	289.7	289.53	289.7	39358.0
2019-10-04 07:45:00	SPY	ETF	289.71	289.73	289.62	289.7	9443.0
2019-10-04 07:50:00	SPY	ETF	289.7	289.73	289.53	289.53	31230.0
2019-10-04 07:55:00	SPY	ETF	289.52	289.58	289.51	289.53	47605.0
2019-10-04 08:00:00	SPY	ETF	289.4301	291.06	289.38	289.51	231545.0
2019-10-04 08:05:00	SPY	ETF	289.25	289.66	289.25	289.65	86754.0
2019-10-04 08:10:00	SPY	ETF	289.67	289.67	289.46	289.46	49663.0

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

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