PREVIEW / etf_5min / 2017-07-07

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-07-07.parquet
  size:    1.2 MB
  rows:    52,765

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-07-07 04:10:00	SPY	ETF	240.75	240.75	240.75	240.75	450.0
2017-07-07 04:15:00	SPY	ETF	240.76	240.79	240.71	240.75	4425.0
2017-07-07 04:25:00	SPY	ETF	240.8	240.82	240.8	240.8	900.0
2017-07-07 04:40:00	SPY	ETF	240.75	240.75	240.74	240.74	1050.0
2017-07-07 04:45:00	SPY	ETF	240.7	240.7	240.7	240.7	500.0
2017-07-07 04:50:00	SPY	ETF	240.7	240.7	240.7	240.7	1800.0
2017-07-07 04:55:00	SPY	ETF	240.7	240.7	240.68	240.68	700.0
2017-07-07 05:00:00	SPY	ETF	240.68	240.68	240.68	240.68	2400.0
2017-07-07 05:05:00	SPY	ETF	240.68	240.71	240.68	240.71	1826.0
2017-07-07 05:10:00	SPY	ETF	240.74	240.8	240.74	240.8	1706.0
2017-07-07 05:15:00	SPY	ETF	240.81	240.81	240.8	240.8	701.0
2017-07-07 05:20:00	SPY	ETF	240.79	240.8	240.79	240.79	1803.0
2017-07-07 05:25:00	SPY	ETF	240.74	240.74	240.74	240.74	902.0
2017-07-07 05:30:00	SPY	ETF	240.7	240.7	240.7	240.7	1252.0
2017-07-07 05:35:00	SPY	ETF	240.7	240.7	240.7	240.7	302.0
2017-07-07 05:50:00	SPY	ETF	240.66	240.66	240.66	240.66	200.0
2017-07-07 05:55:00	SPY	ETF	240.63	240.63	240.63	240.63	1630.0
2017-07-07 06:00:00	SPY	ETF	240.75	240.76	240.75	240.76	425.0
2017-07-07 06:05:00	SPY	ETF	240.72	240.75	240.72	240.75	4467.0
2017-07-07 06:10:00	SPY	ETF	240.75	240.75	240.75	240.75	500.0
2017-07-07 06:15:00	SPY	ETF	240.75	240.75	240.75	240.75	2900.0
2017-07-07 06:20:00	SPY	ETF	240.78	240.78	240.78	240.78	5290.0
2017-07-07 06:35:00	SPY	ETF	240.83	240.85	240.8	240.8	65006.0
2017-07-07 06:40:00	SPY	ETF	240.8	240.84	240.77	240.77	10202.0
2017-07-07 06:50:00	SPY	ETF	240.77	240.77	240.77	240.77	300.0
2017-07-07 07:00:00	SPY	ETF	240.76	240.76	240.74	240.74	1499.0
2017-07-07 07:05:00	SPY	ETF	240.74	240.74	240.74	240.74	2800.0
2017-07-07 07:15:00	SPY	ETF	240.74	240.74	240.74	240.74	500.0
2017-07-07 07:20:00	SPY	ETF	240.75	240.76	240.75	240.76	651.0
2017-07-07 07:25:00	SPY	ETF	240.72	240.72	240.67	240.67	6005.0
2017-07-07 07:30:00	SPY	ETF	240.65	240.71	240.65	240.68	2807.0
2017-07-07 07:35:00	SPY	ETF	240.66	240.66	240.65	240.65	2501.0
2017-07-07 07:40:00	SPY	ETF	240.68	240.68	240.67	240.67	2400.0
2017-07-07 07:45:00	SPY	ETF	240.7	240.7	240.69	240.69	2001.0
2017-07-07 07:50:00	SPY	ETF	240.69	240.69	240.69	240.69	3200.0
2017-07-07 07:55:00	SPY	ETF	240.74	240.74	240.69	240.69	18700.0
2017-07-07 08:00:00	SPY	ETF	240.69	240.7	240.66	240.7	47171.0
2017-07-07 08:05:00	SPY	ETF	240.7	240.8	240.7	240.78	12564.0
2017-07-07 08:10:00	SPY	ETF	240.78	240.82	240.77	240.82	21166.0
2017-07-07 08:15:00	SPY	ETF	240.84	240.85	240.84	240.85	17471.0
2017-07-07 08:20:00	SPY	ETF	240.85	240.95	240.79	240.94	51848.0
2017-07-07 08:25:00	SPY	ETF	240.9	240.91	240.79	240.87	60733.0
2017-07-07 08:30:00	SPY	ETF	240.87	241.32	240.79	241.3	315781.0
2017-07-07 08:35:00	SPY	ETF	241.29	241.54	241.26	241.27	201301.0
2017-07-07 08:40:00	SPY	ETF	241.26	241.26	241.12	241.23	197753.0
2017-07-07 08:45:00	SPY	ETF	241.24	241.24	241.15	241.17	89265.0
2017-07-07 08:50:00	SPY	ETF	241.17	241.4	241.17	241.35	114065.0
2017-07-07 08:55:00	SPY	ETF	241.32	241.32	241.11	241.14	33962.0
2017-07-07 09:00:00	SPY	ETF	241.15	241.25	241.15	241.25	52719.0
2017-07-07 09:05:00	SPY	ETF	241.25	241.28	241.2	241.2	33460.0

> showing 50 of 52,765 rows — these rows as CSV

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