PREVIEW / etf_5min / 2017-07-13

all etf 5-min files

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

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-13 04:05:00	SPY	ETF	244.18	244.18	244.18	244.18	100.0
2017-07-13 04:45:00	SPY	ETF	244.36	244.36	244.36	244.36	103.0
2017-07-13 04:50:00	SPY	ETF	244.32	244.34	244.32	244.34	298.0
2017-07-13 04:55:00	SPY	ETF	244.33	244.33	244.33	244.33	100.0
2017-07-13 05:00:00	SPY	ETF	244.37	244.48	244.37	244.48	1214.0
2017-07-13 05:10:00	SPY	ETF	244.42	244.42	244.42	244.42	320.0
2017-07-13 05:15:00	SPY	ETF	244.42	244.42	244.4	244.42	1400.0
2017-07-13 05:20:00	SPY	ETF	244.4	244.41	244.4	244.41	1103.0
2017-07-13 05:25:00	SPY	ETF	244.36	244.36	244.32	244.34	603.0
2017-07-13 05:35:00	SPY	ETF	244.33	244.33	244.28	244.31	804.0
2017-07-13 05:40:00	SPY	ETF	244.33	244.33	244.28	244.28	4401.0
2017-07-13 05:45:00	SPY	ETF	244.3	244.3	244.27	244.3	3800.0
2017-07-13 05:50:00	SPY	ETF	244.33	244.33	244.33	244.33	100.0
2017-07-13 05:55:00	SPY	ETF	244.33	244.33	244.33	244.33	100.0
2017-07-13 06:00:00	SPY	ETF	244.3	244.3	244.3	244.3	110.0
2017-07-13 06:05:00	SPY	ETF	244.33	244.33	244.3	244.3	500.0
2017-07-13 06:10:00	SPY	ETF	244.3	244.3	244.24	244.25	16702.0
2017-07-13 06:25:00	SPY	ETF	244.28	244.28	244.28	244.28	100.0
2017-07-13 06:30:00	SPY	ETF	244.25	244.25	244.25	244.25	100.0
2017-07-13 06:35:00	SPY	ETF	244.24	244.24	244.24	244.24	100.0
2017-07-13 06:40:00	SPY	ETF	244.27	244.27	244.27	244.27	1000.0
2017-07-13 06:50:00	SPY	ETF	244.23	244.26	244.2	244.26	42301.0
2017-07-13 06:55:00	SPY	ETF	244.21	244.21	244.2	244.2	396.0
2017-07-13 07:00:00	SPY	ETF	244.2	244.2	244.18	244.19	14300.0
2017-07-13 07:05:00	SPY	ETF	244.18	244.21	244.18	244.19	1700.0
2017-07-13 07:10:00	SPY	ETF	244.19	244.19	244.15	244.16	2702.0
2017-07-13 07:15:00	SPY	ETF	244.16	244.16	244.09	244.09	7903.0
2017-07-13 07:20:00	SPY	ETF	244.09	244.09	244.06	244.06	1609.0
2017-07-13 07:25:00	SPY	ETF	244.05	244.09	244.04	244.04	3079.0
2017-07-13 07:30:00	SPY	ETF	244.03	244.07	244.03	244.07	3814.0
2017-07-13 07:35:00	SPY	ETF	244.05	244.05	243.98	244.01	13434.0
2017-07-13 07:40:00	SPY	ETF	244.01	244.01	243.99	243.99	19000.0
2017-07-13 07:45:00	SPY	ETF	244.01	244.02	243.98	243.98	14101.0
2017-07-13 07:50:00	SPY	ETF	244.0	244.0	243.97	243.97	17500.0
2017-07-13 07:55:00	SPY	ETF	244.0	244.0	243.95	244.0	8401.0
2017-07-13 08:00:00	SPY	ETF	244.02	244.13	244.0	244.13	66269.0
2017-07-13 08:05:00	SPY	ETF	244.12	244.15	244.12	244.13	22830.0
2017-07-13 08:10:00	SPY	ETF	244.14	244.16	244.12	244.12	7500.0
2017-07-13 08:15:00	SPY	ETF	244.11	244.13	244.1	244.1	3800.0
2017-07-13 08:20:00	SPY	ETF	244.11	244.13	244.11	244.13	2100.0
2017-07-13 08:25:00	SPY	ETF	244.11	244.14	244.11	244.13	10957.0
2017-07-13 08:30:00	SPY	ETF	244.14	244.16	244.11	244.15	24610.0
2017-07-13 08:35:00	SPY	ETF	244.15	244.18	244.15	244.18	33200.0
2017-07-13 08:40:00	SPY	ETF	244.16	244.16	244.09	244.09	25014.0
2017-07-13 08:45:00	SPY	ETF	244.09	244.1	244.06	244.07	38992.0
2017-07-13 08:50:00	SPY	ETF	244.07	244.08	244.03	244.04	15741.0
2017-07-13 08:55:00	SPY	ETF	244.03	244.1	244.01	244.1	17873.0
2017-07-13 09:00:00	SPY	ETF	244.1	244.11	244.08	244.1	20506.0
2017-07-13 09:05:00	SPY	ETF	244.11	244.14	244.11	244.11	60229.0
2017-07-13 09:10:00	SPY	ETF	244.11	244.11	244.01	244.03	44138.0

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

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