PREVIEW / etf_5min / 2019-11-07

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-11-07.parquet
  size:    1.5 MB
  rows:    65,525

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-11-07 04:00:00	SPY	ETF	308.61	308.76	308.61	308.72	4164.0
2019-11-07 04:05:00	SPY	ETF	308.65	308.67	308.62	308.67	1425.0
2019-11-07 04:10:00	SPY	ETF	308.55	308.84	308.55	308.77	3820.0
2019-11-07 04:15:00	SPY	ETF	308.72	308.74	308.72	308.74	1700.0
2019-11-07 04:20:00	SPY	ETF	308.77	308.8	308.67	308.67	2838.0
2019-11-07 04:25:00	SPY	ETF	308.73	308.73	308.73	308.73	2099.0
2019-11-07 04:30:00	SPY	ETF	308.71	308.71	308.62	308.62	1120.0
2019-11-07 04:35:00	SPY	ETF	308.63	308.77	308.63	308.7	37226.0
2019-11-07 04:40:00	SPY	ETF	308.78	308.78	308.75	308.78	25908.0
2019-11-07 04:45:00	SPY	ETF	308.85	308.85	308.71	308.71	27872.0
2019-11-07 04:50:00	SPY	ETF	308.79	308.79	308.79	308.79	9310.0
2019-11-07 04:55:00	SPY	ETF	308.79	308.79	308.73	308.73	3831.0
2019-11-07 05:00:00	SPY	ETF	308.74	308.85	308.74	308.85	66014.0
2019-11-07 05:05:00	SPY	ETF	308.7	308.72	308.7	308.72	275.0
2019-11-07 05:10:00	SPY	ETF	308.68	308.7	308.68	308.7	50705.0
2019-11-07 05:15:00	SPY	ETF	308.72	308.72	308.72	308.72	520.0
2019-11-07 05:20:00	SPY	ETF	308.68	308.72	308.68	308.72	2000.0
2019-11-07 05:25:00	SPY	ETF	308.74	308.77	308.69	308.77	9905.0
2019-11-07 05:30:00	SPY	ETF	308.74	308.74	308.66	308.72	1050.0
2019-11-07 05:35:00	SPY	ETF	308.64	308.67	308.6	308.6	2100.0
2019-11-07 05:40:00	SPY	ETF	308.67	308.71	308.67	308.71	3105.0
2019-11-07 05:45:00	SPY	ETF	308.63	308.7	308.59	308.67	1815.0
2019-11-07 05:50:00	SPY	ETF	308.72	308.74	308.72	308.74	7125.0
2019-11-07 05:55:00	SPY	ETF	308.74	308.77	308.71	308.71	14935.0
2019-11-07 06:00:00	SPY	ETF	308.7	308.71	308.68	308.68	1800.0
2019-11-07 06:05:00	SPY	ETF	308.67	308.7	308.67	308.7	600.0
2019-11-07 06:10:00	SPY	ETF	308.7	308.75	308.7	308.7	11350.0
2019-11-07 06:15:00	SPY	ETF	308.66	308.73	308.65	308.65	2832.0
2019-11-07 06:20:00	SPY	ETF	308.63	308.74	308.6	308.74	7565.0
2019-11-07 06:25:00	SPY	ETF	308.69	308.73	308.63	308.63	2551.0
2019-11-07 06:30:00	SPY	ETF	308.64	308.64	308.6	308.6	8944.0
2019-11-07 06:35:00	SPY	ETF	308.63	308.63	308.63	308.63	100.0
2019-11-07 06:40:00	SPY	ETF	308.61	308.63	308.6	308.61	1095.0
2019-11-07 06:45:00	SPY	ETF	308.6	308.6	308.55	308.56	1270.0
2019-11-07 06:50:00	SPY	ETF	308.54	308.54	308.46	308.46	4251.0
2019-11-07 06:55:00	SPY	ETF	308.53	308.53	308.46	308.46	2050.0
2019-11-07 07:00:00	SPY	ETF	308.46	308.49	308.41	308.45	37918.0
2019-11-07 07:05:00	SPY	ETF	308.41	308.47	308.39	308.47	9405.0
2019-11-07 07:10:00	SPY	ETF	308.44	308.49	308.42	308.48	7189.0
2019-11-07 07:15:00	SPY	ETF	308.44	308.44	308.41	308.41	7157.0
2019-11-07 07:20:00	SPY	ETF	308.41	308.41	308.36	308.36	15574.0
2019-11-07 07:25:00	SPY	ETF	308.35	308.41	308.32	308.39	5201.0
2019-11-07 07:30:00	SPY	ETF	308.43	308.49	308.41	308.47	6022.0
2019-11-07 07:35:00	SPY	ETF	308.48	308.51	308.48	308.48	1007.0
2019-11-07 07:40:00	SPY	ETF	308.51	308.51	308.46	308.47	5450.0
2019-11-07 07:45:00	SPY	ETF	308.48	308.48	308.45	308.48	1272.0
2019-11-07 07:50:00	SPY	ETF	308.49	308.49	308.49	308.49	250.0
2019-11-07 07:55:00	SPY	ETF	308.45	308.46	308.45	308.46	2329.0
2019-11-07 08:00:00	SPY	ETF	308.44	308.94	307.02	308.33	59183.0
2019-11-07 08:05:00	SPY	ETF	308.36	308.4	308.35	308.4	19272.0

> showing 50 of 65,525 rows — these rows as CSV

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