PREVIEW / etf_5min / 2017-02-13

all etf 5-min files

  file:    by_date/etf_5min/2017/2017-02-13.parquet
  size:    1.3 MB
  rows:    56,828

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-02-13 04:00:00	SPY	ETF	231.68	231.68	231.68	231.68	400.0
2017-02-13 04:10:00	SPY	ETF	231.67	231.73	231.67	231.73	300.0
2017-02-13 04:45:00	SPY	ETF	231.72	231.74	231.72	231.74	360.0
2017-02-13 05:00:00	SPY	ETF	231.7	231.7	231.7	231.7	310.0
2017-02-13 05:15:00	SPY	ETF	231.68	231.68	231.68	231.68	100.0
2017-02-13 05:25:00	SPY	ETF	231.68	231.68	231.67	231.67	450.0
2017-02-13 05:30:00	SPY	ETF	231.74	231.77	231.74	231.75	1000.0
2017-02-13 05:35:00	SPY	ETF	231.74	231.76	231.74	231.76	583.0
2017-02-13 05:40:00	SPY	ETF	231.73	231.73	231.72	231.72	500.0
2017-02-13 05:45:00	SPY	ETF	231.68	231.68	231.68	231.68	200.0
2017-02-13 06:10:00	SPY	ETF	231.72	231.74	231.72	231.72	1050.0
2017-02-13 06:15:00	SPY	ETF	231.72	231.72	231.72	231.72	190.0
2017-02-13 06:20:00	SPY	ETF	231.75	231.75	231.74	231.74	505.0
2017-02-13 06:25:00	SPY	ETF	231.75	231.75	231.75	231.75	1000.0
2017-02-13 06:30:00	SPY	ETF	231.76	231.79	231.76	231.79	1750.0
2017-02-13 06:35:00	SPY	ETF	231.74	231.74	231.74	231.74	499.0
2017-02-13 06:55:00	SPY	ETF	231.77	231.78	231.77	231.78	1310.0
2017-02-13 07:00:00	SPY	ETF	231.78	231.82	231.78	231.79	9533.0
2017-02-13 07:05:00	SPY	ETF	231.83	231.87	231.83	231.86	5904.0
2017-02-13 07:10:00	SPY	ETF	231.82	231.82	231.82	231.82	100.0
2017-02-13 07:15:00	SPY	ETF	231.85	231.89	231.85	231.89	2444.0
2017-02-13 07:20:00	SPY	ETF	231.87	231.87	231.87	231.87	4200.0
2017-02-13 07:25:00	SPY	ETF	231.89	231.89	231.89	231.89	1003.0
2017-02-13 07:30:00	SPY	ETF	231.9	231.92	231.9	231.91	1210.0
2017-02-13 07:35:00	SPY	ETF	231.87	231.87	231.84	231.85	1904.0
2017-02-13 07:40:00	SPY	ETF	231.83	231.83	231.8	231.82	15758.0
2017-02-13 07:45:00	SPY	ETF	231.82	231.82	231.81	231.82	6974.0
2017-02-13 07:50:00	SPY	ETF	231.82	231.93	231.82	231.93	24271.0
2017-02-13 07:55:00	SPY	ETF	231.92	231.95	231.84	231.89	11236.0
2017-02-13 08:00:00	SPY	ETF	231.85	231.93	231.79	231.9	58805.0
2017-02-13 08:05:00	SPY	ETF	231.92	231.96	231.78	231.93	39829.0
2017-02-13 08:10:00	SPY	ETF	231.94	231.95	231.89	231.95	8326.0
2017-02-13 08:15:00	SPY	ETF	231.95	231.98	231.89	231.9	31224.0
2017-02-13 08:20:00	SPY	ETF	231.92	232.03	231.92	232.02	30311.0
2017-02-13 08:25:00	SPY	ETF	232.01	232.06	232.01	232.01	62677.0
2017-02-13 08:30:00	SPY	ETF	232.04	232.04	231.95	231.95	18335.0
2017-02-13 08:35:00	SPY	ETF	231.95	231.96	231.92	231.95	26390.0
2017-02-13 08:40:00	SPY	ETF	231.95	231.96	231.91	231.91	55612.0
2017-02-13 08:45:00	SPY	ETF	231.91	231.97	231.9	231.9	20179.0
2017-02-13 08:50:00	SPY	ETF	231.92	232.0	231.9	231.99	17115.0
2017-02-13 08:55:00	SPY	ETF	231.99	232.02	231.99	232.01	17447.0
2017-02-13 09:00:00	SPY	ETF	232.0	232.0	231.94	231.99	12828.0
2017-02-13 09:05:00	SPY	ETF	231.99	232.09	231.99	232.05	109311.0
2017-02-13 09:10:00	SPY	ETF	232.07	232.08	232.05	232.05	12772.0
2017-02-13 09:15:00	SPY	ETF	232.06	232.1	232.04	232.08	99191.0
2017-02-13 09:20:00	SPY	ETF	232.08	232.16	232.08	232.16	71876.0
2017-02-13 09:25:00	SPY	ETF	232.15	232.15	232.04	232.08	207871.0
2017-02-13 09:30:00	SPY	ETF	232.08	232.23	232.05	232.18	2103360.0
2017-02-13 09:35:00	SPY	ETF	232.18	232.28	232.12	232.27	1152330.0
2017-02-13 09:40:00	SPY	ETF	232.28	232.44	232.23	232.402	1617426.0

> showing 50 of 56,828 rows — these rows as CSV

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