PREVIEW / etf_5min / 2018-08-13

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-08-13.parquet
  size:    1.4 MB
  rows:    58,904

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
2018-08-13 04:00:00	SPY	ETF	282.24	283.15	282.15	282.2	19841.0
2018-08-13 04:05:00	SPY	ETF	282.23	282.23	282.14	282.15	7111.0
2018-08-13 04:10:00	SPY	ETF	282.2	282.2	282.17	282.17	200.0
2018-08-13 04:15:00	SPY	ETF	282.36	282.36	282.36	282.36	200.0
2018-08-13 04:20:00	SPY	ETF	282.49	282.49	282.45	282.45	5500.0
2018-08-13 04:25:00	SPY	ETF	282.62	282.62	282.62	282.62	600.0
2018-08-13 04:30:00	SPY	ETF	282.51	282.51	282.5	282.5	470.0
2018-08-13 04:35:00	SPY	ETF	282.49	282.51	282.49	282.51	1288.0
2018-08-13 04:40:00	SPY	ETF	282.65	282.65	282.65	282.65	200.0
2018-08-13 04:45:00	SPY	ETF	282.6	282.66	282.6	282.66	1302.0
2018-08-13 04:50:00	SPY	ETF	282.61	282.61	282.61	282.61	250.0
2018-08-13 05:00:00	SPY	ETF	282.75	282.75	282.75	282.75	285.0
2018-08-13 05:05:00	SPY	ETF	282.66	282.66	282.58	282.58	400.0
2018-08-13 05:10:00	SPY	ETF	282.57	282.69	282.56	282.69	3300.0
2018-08-13 05:15:00	SPY	ETF	282.75	282.75	282.61	282.61	600.0
2018-08-13 05:20:00	SPY	ETF	282.65	282.65	282.65	282.65	300.0
2018-08-13 05:30:00	SPY	ETF	282.73	282.84	282.73	282.84	702.0
2018-08-13 05:40:00	SPY	ETF	282.8	282.8	282.71	282.71	3200.0
2018-08-13 05:45:00	SPY	ETF	282.67	282.67	282.61	282.61	2802.0
2018-08-13 05:50:00	SPY	ETF	282.57	282.57	282.48	282.56	2602.0
2018-08-13 05:55:00	SPY	ETF	282.52	282.52	282.48	282.48	2145.0
2018-08-13 06:00:00	SPY	ETF	282.51	282.54	282.49	282.49	2400.0
2018-08-13 06:05:00	SPY	ETF	282.46	282.51	282.39	282.43	3300.0
2018-08-13 06:10:00	SPY	ETF	282.51	282.51	282.51	282.51	300.0
2018-08-13 06:15:00	SPY	ETF	282.61	282.61	282.61	282.61	190.0
2018-08-13 06:20:00	SPY	ETF	282.6	282.66	282.6	282.66	310.0
2018-08-13 06:25:00	SPY	ETF	282.66	282.66	282.65	282.65	3000.0
2018-08-13 06:30:00	SPY	ETF	282.64	282.66	282.64	282.66	10300.0
2018-08-13 06:35:00	SPY	ETF	282.7	282.77	282.69	282.75	7688.0
2018-08-13 06:40:00	SPY	ETF	282.73	282.79	282.73	282.79	2100.0
2018-08-13 06:45:00	SPY	ETF	282.79	282.79	282.74	282.74	2100.0
2018-08-13 06:50:00	SPY	ETF	282.73	282.73	282.73	282.73	400.0
2018-08-13 06:55:00	SPY	ETF	282.64	282.64	282.58	282.58	2100.0
2018-08-13 07:00:00	SPY	ETF	282.58	282.71	282.58	282.71	11321.0
2018-08-13 07:05:00	SPY	ETF	282.7	282.7	282.66	282.7	11570.0
2018-08-13 07:10:00	SPY	ETF	282.77	282.79	282.73	282.79	889.0
2018-08-13 07:15:00	SPY	ETF	282.79	282.79	282.67	282.67	8055.0
2018-08-13 07:20:00	SPY	ETF	282.74	282.74	282.72	282.72	13500.0
2018-08-13 07:25:00	SPY	ETF	282.72	282.72	282.65	282.68	8700.0
2018-08-13 07:30:00	SPY	ETF	282.65	282.7	282.64	282.7	3750.0
2018-08-13 07:35:00	SPY	ETF	282.7	282.77	282.69	282.74	18910.0
2018-08-13 07:40:00	SPY	ETF	282.68	282.78	282.68	282.78	18050.0
2018-08-13 07:45:00	SPY	ETF	282.82	282.82	282.73	282.73	30550.0
2018-08-13 07:50:00	SPY	ETF	282.78	283.13	282.78	283.13	30978.0
2018-08-13 07:55:00	SPY	ETF	283.2	283.4	283.15	283.3	63143.0
2018-08-13 08:00:00	SPY	ETF	282.7201	283.36	282.03	283.25	62223.0
2018-08-13 08:05:00	SPY	ETF	283.21	283.29	283.03	283.05	37574.0
2018-08-13 08:10:00	SPY	ETF	283.07	283.17	283.01	283.1	92859.0
2018-08-13 08:15:00	SPY	ETF	283.08	283.1	283.02	283.06	10721.0
2018-08-13 08:20:00	SPY	ETF	283.1	283.25	283.1	283.25	17172.0

> showing 50 of 58,904 rows — these rows as CSV

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