PREVIEW / etf_5min / 2017-03-28

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-03-28.parquet
  size:    1.3 MB
  rows:    54,335

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-03-28 04:00:00	SPY	ETF	233.78	233.78	233.78	233.78	386.0
2017-03-28 04:05:00	SPY	ETF	233.79	233.8	233.79	233.8	1000.0
2017-03-28 04:20:00	SPY	ETF	233.8	233.85	233.8	233.85	400.0
2017-03-28 04:25:00	SPY	ETF	233.84	233.84	233.84	233.84	1500.0
2017-03-28 04:30:00	SPY	ETF	233.89	233.89	233.89	233.89	200.0
2017-03-28 04:40:00	SPY	ETF	233.91	233.91	233.91	233.91	100.0
2017-03-28 04:45:00	SPY	ETF	233.89	233.89	233.89	233.89	300.0
2017-03-28 04:50:00	SPY	ETF	233.9	233.9	233.9	233.9	400.0
2017-03-28 05:00:00	SPY	ETF	233.9	233.9	233.9	233.9	100.0
2017-03-28 05:25:00	SPY	ETF	233.87	233.87	233.87	233.87	100.0
2017-03-28 05:50:00	SPY	ETF	233.92	233.92	233.92	233.92	300.0
2017-03-28 06:15:00	SPY	ETF	233.88	233.88	233.87	233.87	400.0
2017-03-28 06:35:00	SPY	ETF	233.8	233.8	233.8	233.8	100.0
2017-03-28 06:40:00	SPY	ETF	233.79	233.79	233.78	233.78	333.0
2017-03-28 06:45:00	SPY	ETF	233.79	233.79	233.79	233.79	100.0
2017-03-28 06:50:00	SPY	ETF	233.79	233.79	233.79	233.79	500.0
2017-03-28 07:00:00	SPY	ETF	233.76	233.76	233.69	233.7	7135.0
2017-03-28 07:05:00	SPY	ETF	233.75	233.75	233.7	233.7	12901.0
2017-03-28 07:10:00	SPY	ETF	233.71	233.71	233.69	233.69	1400.0
2017-03-28 07:15:00	SPY	ETF	233.72	233.72	233.69	233.7	1500.0
2017-03-28 07:20:00	SPY	ETF	233.7	233.7	233.67	233.67	1302.0
2017-03-28 07:25:00	SPY	ETF	233.6	233.62	233.54	233.54	1731.0
2017-03-28 07:30:00	SPY	ETF	233.58	233.58	233.46	233.46	53221.0
2017-03-28 07:35:00	SPY	ETF	233.47	233.47	233.3	233.36	44823.0
2017-03-28 07:40:00	SPY	ETF	233.37	233.48	233.35	233.45	6877.0
2017-03-28 07:45:00	SPY	ETF	233.42	233.42	233.37	233.37	3354.0
2017-03-28 07:50:00	SPY	ETF	233.41	233.43	233.39	233.43	16101.0
2017-03-28 07:55:00	SPY	ETF	233.38	233.44	233.38	233.42	8977.0
2017-03-28 08:00:00	SPY	ETF	233.42	233.76	233.35	233.37	43537.0
2017-03-28 08:05:00	SPY	ETF	233.36	233.36	233.33	233.34	16356.0
2017-03-28 08:10:00	SPY	ETF	233.34	233.37	233.33	233.37	6274.0
2017-03-28 08:15:00	SPY	ETF	233.37	233.37	233.3	233.35	38759.0
2017-03-28 08:20:00	SPY	ETF	233.34	233.38	233.26	233.28	89017.0
2017-03-28 08:25:00	SPY	ETF	233.29	233.31	233.26	233.31	35006.0
2017-03-28 08:30:00	SPY	ETF	233.3	233.34	233.27	233.3	39852.0
2017-03-28 08:35:00	SPY	ETF	233.3	233.35	233.3	233.31	14117.0
2017-03-28 08:40:00	SPY	ETF	233.3	233.35	233.3	233.34	13641.0
2017-03-28 08:45:00	SPY	ETF	233.33	233.35	233.28	233.31	27796.0
2017-03-28 08:50:00	SPY	ETF	233.31	233.32	233.25	233.27	31025.0
2017-03-28 08:55:00	SPY	ETF	233.26	233.34	233.24	233.32	25849.0
2017-03-28 09:00:00	SPY	ETF	233.32	233.39	233.32	233.38	25898.0
2017-03-28 09:05:00	SPY	ETF	233.38	233.4	233.34	233.34	39427.0
2017-03-28 09:10:00	SPY	ETF	233.34	233.41	233.34	233.41	11338.0
2017-03-28 09:15:00	SPY	ETF	233.4	233.45	233.38	233.39	46268.0
2017-03-28 09:20:00	SPY	ETF	233.39	233.41	233.33	233.37	22118.0
2017-03-28 09:25:00	SPY	ETF	233.36	233.39	233.25	233.25	67428.0
2017-03-28 09:30:00	SPY	ETF	233.27	233.58	233.25	233.57	1647905.0
2017-03-28 09:35:00	SPY	ETF	233.57	233.76	233.55	233.63	973449.0
2017-03-28 09:40:00	SPY	ETF	233.64	233.76	233.57	233.5801	1046450.0
2017-03-28 09:45:00	SPY	ETF	233.58	233.595	233.305	233.415	1032811.0

> showing 50 of 54,335 rows — these rows as CSV

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