PREVIEW / etf_5min / 2019-07-19

all etf 5-min files

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

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-07-19 04:00:00	SPY	ETF	299.79	299.79	299.79	299.79	429.0
2019-07-19 04:05:00	SPY	ETF	299.89	299.89	299.89	299.89	500.0
2019-07-19 04:10:00	SPY	ETF	299.97	299.97	299.97	299.97	550.0
2019-07-19 04:25:00	SPY	ETF	299.92	299.94	299.91	299.94	2500.0
2019-07-19 04:30:00	SPY	ETF	299.92	299.93	299.89	299.89	1250.0
2019-07-19 04:35:00	SPY	ETF	299.84	299.84	299.84	299.84	300.0
2019-07-19 04:40:00	SPY	ETF	299.82	299.82	299.77	299.77	2300.0
2019-07-19 04:45:00	SPY	ETF	299.82	299.82	299.71	299.72	678.0
2019-07-19 04:50:00	SPY	ETF	299.75	299.82	299.75	299.8	847.0
2019-07-19 04:55:00	SPY	ETF	299.77	299.77	299.77	299.77	900.0
2019-07-19 05:00:00	SPY	ETF	299.62	299.69	299.62	299.65	1150.0
2019-07-19 05:10:00	SPY	ETF	299.62	299.62	299.62	299.62	140.0
2019-07-19 05:25:00	SPY	ETF	299.48	299.48	299.48	299.48	120.0
2019-07-19 05:35:00	SPY	ETF	299.52	299.52	299.52	299.52	200.0
2019-07-19 05:40:00	SPY	ETF	299.51	299.51	299.45	299.45	1060.0
2019-07-19 05:50:00	SPY	ETF	299.51	299.51	299.15	299.15	5520.0
2019-07-19 05:55:00	SPY	ETF	299.29	299.31	299.25	299.25	1130.0
2019-07-19 06:05:00	SPY	ETF	299.15	299.15	299.02	299.02	1040.0
2019-07-19 06:10:00	SPY	ETF	299.05	299.14	299.05	299.09	3501.0
2019-07-19 06:20:00	SPY	ETF	299.19	299.2	299.19	299.2	250.0
2019-07-19 06:25:00	SPY	ETF	299.26	299.29	299.26	299.29	2850.0
2019-07-19 06:30:00	SPY	ETF	299.15	299.15	299.15	299.15	100.0
2019-07-19 06:35:00	SPY	ETF	299.23	299.23	299.23	299.23	300.0
2019-07-19 06:40:00	SPY	ETF	299.07	299.07	299.07	299.07	500.0
2019-07-19 06:45:00	SPY	ETF	299.06	299.1	299.05	299.05	2250.0
2019-07-19 06:50:00	SPY	ETF	299.01	299.05	298.97	298.97	4350.0
2019-07-19 06:55:00	SPY	ETF	299.09	299.09	299.09	299.09	150.0
2019-07-19 07:00:00	SPY	ETF	299.07	299.14	298.97	299.1	9401.0
2019-07-19 07:05:00	SPY	ETF	299.03	299.05	298.95	299.01	17038.0
2019-07-19 07:10:00	SPY	ETF	299.05	299.05	299.04	299.04	2700.0
2019-07-19 07:15:00	SPY	ETF	299.02	299.07	299.02	299.07	2400.0
2019-07-19 07:20:00	SPY	ETF	299.12	299.14	299.04	299.14	4670.0
2019-07-19 07:25:00	SPY	ETF	299.14	299.28	299.12	299.22	4504.0
2019-07-19 07:30:00	SPY	ETF	299.22	299.26	299.22	299.26	1245.0
2019-07-19 07:35:00	SPY	ETF	299.26	299.36	299.26	299.36	15600.0
2019-07-19 07:40:00	SPY	ETF	299.35	299.36	299.32	299.32	51830.0
2019-07-19 07:45:00	SPY	ETF	299.4	299.4	299.38	299.4	15600.0
2019-07-19 07:50:00	SPY	ETF	299.4	299.47	299.4	299.44	14890.0
2019-07-19 07:55:00	SPY	ETF	299.42	299.42	299.34	299.34	4629.0
2019-07-19 08:00:00	SPY	ETF	299.07	299.88	298.99	299.39	9248.0
2019-07-19 08:05:00	SPY	ETF	299.3701	299.4	299.36	299.4	3010.0
2019-07-19 08:10:00	SPY	ETF	299.37	299.37	299.37	299.37	1269.0
2019-07-19 08:15:00	SPY	ETF	299.4	299.59	299.4	299.57	57619.0
2019-07-19 08:20:00	SPY	ETF	299.57	299.57	299.53	299.53	9120.0
2019-07-19 08:25:00	SPY	ETF	299.56	299.65	299.54	299.65	4821.0
2019-07-19 08:30:00	SPY	ETF	299.6	299.65	299.45	299.45	10103.0
2019-07-19 08:35:00	SPY	ETF	299.46	299.46	299.4001	299.43	5806.0
2019-07-19 08:40:00	SPY	ETF	299.4	299.42	299.35	299.41	16952.0
2019-07-19 08:45:00	SPY	ETF	299.44	299.52	299.44	299.52	20634.0
2019-07-19 08:50:00	SPY	ETF	299.5301	299.64	299.5301	299.63	7821.0

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

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