PREVIEW / etf_5min / 2019-09-19

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-09-19.parquet
  size:    1.4 MB
  rows:    60,267

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-19 04:00:00	SPY	ETF	300.53	300.57	300.45	300.45	27662.0
2019-09-19 04:05:00	SPY	ETF	300.47	300.47	300.4	300.42	4210.0
2019-09-19 04:10:00	SPY	ETF	300.43	300.47	300.37	300.45	14730.0
2019-09-19 04:15:00	SPY	ETF	300.47	300.47	300.35	300.38	3410.0
2019-09-19 04:20:00	SPY	ETF	300.4	300.49	300.37	300.49	3200.0
2019-09-19 04:25:00	SPY	ETF	300.52	300.52	300.52	300.52	300.0
2019-09-19 04:30:00	SPY	ETF	300.53	300.54	300.53	300.54	1500.0
2019-09-19 04:35:00	SPY	ETF	300.56	300.69	300.56	300.63	2903.0
2019-09-19 04:40:00	SPY	ETF	300.59	300.7	300.59	300.7	4800.0
2019-09-19 04:45:00	SPY	ETF	300.67	300.67	300.5	300.59	1458.0
2019-09-19 04:50:00	SPY	ETF	300.5	300.51	300.46	300.51	2400.0
2019-09-19 04:55:00	SPY	ETF	300.6	300.7	300.6	300.7	2700.0
2019-09-19 05:00:00	SPY	ETF	300.7	300.74	300.7	300.74	800.0
2019-09-19 05:15:00	SPY	ETF	300.56	300.56	300.56	300.56	500.0
2019-09-19 05:20:00	SPY	ETF	300.57	300.57	300.57	300.57	100.0
2019-09-19 05:25:00	SPY	ETF	300.5	300.5	300.42	300.42	4800.0
2019-09-19 05:30:00	SPY	ETF	300.52	300.52	300.52	300.52	100.0
2019-09-19 05:35:00	SPY	ETF	300.56	300.56	300.42	300.44	1005.0
2019-09-19 05:40:00	SPY	ETF	300.38	300.43	300.38	300.43	600.0
2019-09-19 05:45:00	SPY	ETF	300.43	300.43	300.41	300.42	1150.0
2019-09-19 05:50:00	SPY	ETF	300.31	300.36	300.31	300.35	721.0
2019-09-19 05:55:00	SPY	ETF	300.35	300.35	300.28	300.31	2000.0
2019-09-19 06:00:00	SPY	ETF	300.33	300.44	300.33	300.44	900.0
2019-09-19 06:05:00	SPY	ETF	300.46	300.46	300.46	300.46	1100.0
2019-09-19 06:10:00	SPY	ETF	300.48	300.52	300.48	300.52	3100.0
2019-09-19 06:20:00	SPY	ETF	300.44	300.44	300.4	300.4	17501.0
2019-09-19 06:25:00	SPY	ETF	300.47	300.47	300.47	300.47	100.0
2019-09-19 06:30:00	SPY	ETF	300.42	300.42	300.38	300.38	1636.0
2019-09-19 06:35:00	SPY	ETF	300.33	300.34	300.28	300.34	8014.0
2019-09-19 06:40:00	SPY	ETF	300.3	300.3	300.27	300.27	350.0
2019-09-19 06:50:00	SPY	ETF	300.39	300.41	300.37	300.41	2900.0
2019-09-19 06:55:00	SPY	ETF	300.36	300.36	300.26	300.26	2570.0
2019-09-19 07:00:00	SPY	ETF	300.28	300.33	300.24	300.29	19476.0
2019-09-19 07:05:00	SPY	ETF	300.33	300.4	300.29	300.4	2557.0
2019-09-19 07:10:00	SPY	ETF	300.4	300.45	300.38	300.45	12222.0
2019-09-19 07:15:00	SPY	ETF	300.45	300.57	300.45	300.57	8625.0
2019-09-19 07:20:00	SPY	ETF	300.57	300.59	300.54	300.59	3910.0
2019-09-19 07:25:00	SPY	ETF	300.62	300.7	300.59	300.7	37881.0
2019-09-19 07:30:00	SPY	ETF	300.7	300.7	300.68	300.7	5075.0
2019-09-19 07:35:00	SPY	ETF	300.7	300.7	300.66	300.66	5003.0
2019-09-19 07:40:00	SPY	ETF	300.7	300.7	300.64	300.64	23306.0
2019-09-19 07:45:00	SPY	ETF	300.64	300.65	300.64	300.64	24044.0
2019-09-19 07:50:00	SPY	ETF	300.68	300.75	300.68	300.75	20370.0
2019-09-19 07:55:00	SPY	ETF	300.81	300.81	300.7	300.7	29739.0
2019-09-19 08:00:00	SPY	ETF	300.41	300.72	299.55	300.72	17562.0
2019-09-19 08:05:00	SPY	ETF	300.7	300.74	300.64	300.74	13825.0
2019-09-19 08:10:00	SPY	ETF	300.75	300.89	300.71	300.87	156592.0
2019-09-19 08:15:00	SPY	ETF	300.87	300.88	300.8	300.86	19377.0
2019-09-19 08:20:00	SPY	ETF	300.88	301.08	300.88	301.04	33275.0
2019-09-19 08:25:00	SPY	ETF	301.04	301.06	300.94	301.0	43085.0

> showing 50 of 60,267 rows — these rows as CSV

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