PREVIEW / etf_5min / 2017-08-03

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-08-03.parquet
  size:    1.2 MB
  rows:    51,672

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
2017-08-03 04:00:00	SPY	ETF	246.91	246.94	246.91	246.91	3830.0
2017-08-03 04:05:00	SPY	ETF	246.94	246.94	246.91	246.91	5470.0
2017-08-03 04:15:00	SPY	ETF	247.03	247.03	247.03	247.03	400.0
2017-08-03 04:25:00	SPY	ETF	247.05	247.05	247.05	247.05	4000.0
2017-08-03 04:45:00	SPY	ETF	247.11	247.11	247.11	247.11	2020.0
2017-08-03 05:25:00	SPY	ETF	247.29	247.29	247.29	247.29	1250.0
2017-08-03 05:50:00	SPY	ETF	247.14	247.14	247.14	247.14	100.0
2017-08-03 06:05:00	SPY	ETF	247.19	247.2	247.16	247.16	24000.0
2017-08-03 06:10:00	SPY	ETF	247.18	247.18	247.18	247.18	1100.0
2017-08-03 06:15:00	SPY	ETF	247.18	247.18	247.17	247.17	700.0
2017-08-03 06:35:00	SPY	ETF	247.25	247.26	247.25	247.26	4000.0
2017-08-03 06:40:00	SPY	ETF	247.3	247.35	247.3	247.35	7000.0
2017-08-03 06:45:00	SPY	ETF	247.39	247.39	247.39	247.39	7500.0
2017-08-03 06:55:00	SPY	ETF	247.31	247.31	247.31	247.31	3800.0
2017-08-03 07:00:00	SPY	ETF	247.31	247.31	247.25	247.25	9700.0
2017-08-03 07:05:00	SPY	ETF	247.25	247.25	247.25	247.25	3500.0
2017-08-03 07:15:00	SPY	ETF	247.28	247.29	247.28	247.29	1000.0
2017-08-03 07:25:00	SPY	ETF	247.21	247.21	247.2	247.21	16000.0
2017-08-03 07:30:00	SPY	ETF	247.18	247.19	247.17	247.17	14725.0
2017-08-03 07:35:00	SPY	ETF	247.21	247.21	247.17	247.17	2800.0
2017-08-03 07:40:00	SPY	ETF	247.16	247.19	247.11	247.11	1800.0
2017-08-03 07:45:00	SPY	ETF	247.17	247.19	247.17	247.19	9100.0
2017-08-03 07:50:00	SPY	ETF	247.18	247.21	247.18	247.21	15104.0
2017-08-03 07:55:00	SPY	ETF	247.21	247.3	247.21	247.29	8319.0
2017-08-03 08:00:00	SPY	ETF	247.24	247.28	247.16	247.26	9459.0
2017-08-03 08:05:00	SPY	ETF	247.26	247.31	247.26	247.31	6410.0
2017-08-03 08:10:00	SPY	ETF	247.32	247.32	247.29	247.31	120700.0
2017-08-03 08:15:00	SPY	ETF	247.3	247.3	247.3	247.3	1006.0
2017-08-03 08:20:00	SPY	ETF	247.34	247.34	247.34	247.34	1800.0
2017-08-03 08:25:00	SPY	ETF	247.34	247.34	247.31	247.31	4240.0
2017-08-03 08:30:00	SPY	ETF	247.34	247.34	247.27	247.27	5001.0
2017-08-03 08:35:00	SPY	ETF	247.28	247.28	247.28	247.28	100.0
2017-08-03 08:40:00	SPY	ETF	247.29	247.32	247.29	247.32	7167.0
2017-08-03 08:45:00	SPY	ETF	247.3	247.36	247.3	247.36	10627.0
2017-08-03 08:50:00	SPY	ETF	247.35	247.39	247.35	247.36	16228.0
2017-08-03 08:55:00	SPY	ETF	247.36	247.48	247.36	247.46	66612.0
2017-08-03 09:00:00	SPY	ETF	247.46	247.46	247.39	247.4	26946.0
2017-08-03 09:05:00	SPY	ETF	247.4	247.43	247.39	247.43	5633.0
2017-08-03 09:10:00	SPY	ETF	247.42	247.42	247.38	247.39	13106.0
2017-08-03 09:15:00	SPY	ETF	247.4	247.4	247.35	247.37	17041.0
2017-08-03 09:20:00	SPY	ETF	247.36	247.37	247.35	247.35	21074.0
2017-08-03 09:25:00	SPY	ETF	247.34	247.35	247.31	247.32	19902.0
2017-08-03 09:30:00	SPY	ETF	247.31	247.34	247.21	247.26	1086907.0
2017-08-03 09:35:00	SPY	ETF	247.27	247.28	247.15	247.24	684886.0
2017-08-03 09:40:00	SPY	ETF	247.24	247.31	247.18	247.28	431136.0
2017-08-03 09:45:00	SPY	ETF	247.28	247.28	247.15	247.17	328943.0
2017-08-03 09:50:00	SPY	ETF	247.17	247.18	246.975	247.0	705624.0
2017-08-03 09:55:00	SPY	ETF	247.01	247.01	246.91	246.99	523770.0
2017-08-03 10:00:00	SPY	ETF	246.99	247.13	246.84	246.97	886320.0
2017-08-03 10:05:00	SPY	ETF	246.98	247.06	246.89	247.03	502058.0

> showing 50 of 51,672 rows — these rows as CSV

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