PREVIEW / etf_5min / 2017-09-13

all etf 5-min files

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

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-09-13 04:00:00	SPY	ETF	249.8	249.8	249.7	249.7	905.0
2017-09-13 04:05:00	SPY	ETF	249.8	249.8	249.78	249.78	350.0
2017-09-13 04:10:00	SPY	ETF	249.77	249.77	249.77	249.77	100.0
2017-09-13 04:15:00	SPY	ETF	249.77	249.79	249.77	249.79	700.0
2017-09-13 04:50:00	SPY	ETF	249.73	249.73	249.73	249.73	300.0
2017-09-13 05:00:00	SPY	ETF	249.78	249.78	249.75	249.75	500.0
2017-09-13 05:05:00	SPY	ETF	249.73	249.73	249.73	249.73	400.0
2017-09-13 05:15:00	SPY	ETF	249.8	249.8	249.8	249.8	400.0
2017-09-13 05:20:00	SPY	ETF	249.75	249.78	249.75	249.77	2500.0
2017-09-13 05:25:00	SPY	ETF	249.77	249.77	249.77	249.77	3700.0
2017-09-13 05:30:00	SPY	ETF	249.78	249.78	249.78	249.78	1100.0
2017-09-13 05:40:00	SPY	ETF	249.7	249.7	249.7	249.7	700.0
2017-09-13 05:45:00	SPY	ETF	249.71	249.71	249.71	249.71	200.0
2017-09-13 05:50:00	SPY	ETF	249.71	249.73	249.71	249.71	6600.0
2017-09-13 06:15:00	SPY	ETF	249.72	249.72	249.72	249.72	200.0
2017-09-13 06:20:00	SPY	ETF	249.71	249.71	249.71	249.71	300.0
2017-09-13 06:30:00	SPY	ETF	249.76	249.76	249.76	249.76	3000.0
2017-09-13 06:35:00	SPY	ETF	249.73	249.73	249.73	249.73	250.0
2017-09-13 06:40:00	SPY	ETF	249.75	249.75	249.75	249.75	1000.0
2017-09-13 06:50:00	SPY	ETF	249.7	249.7	249.69	249.69	1750.0
2017-09-13 06:55:00	SPY	ETF	249.67	249.67	249.67	249.67	300.0
2017-09-13 07:00:00	SPY	ETF	249.67	249.69	249.67	249.69	21450.0
2017-09-13 07:05:00	SPY	ETF	249.69	249.69	249.65	249.67	3169.0
2017-09-13 07:10:00	SPY	ETF	249.67	249.68	249.67	249.68	600.0
2017-09-13 07:20:00	SPY	ETF	249.72	249.72	249.71	249.72	13410.0
2017-09-13 07:25:00	SPY	ETF	249.7	249.75	249.69	249.75	1438.0
2017-09-13 07:30:00	SPY	ETF	249.75	249.75	249.73	249.73	2769.0
2017-09-13 07:35:00	SPY	ETF	249.73	249.82	249.73	249.82	8570.0
2017-09-13 07:40:00	SPY	ETF	249.8	249.82	249.79	249.82	11038.0
2017-09-13 07:45:00	SPY	ETF	249.82	249.82	249.82	249.82	1100.0
2017-09-13 07:50:00	SPY	ETF	249.81	249.84	249.81	249.84	4645.0
2017-09-13 07:55:00	SPY	ETF	249.81	249.82	249.81	249.82	8069.0
2017-09-13 08:00:00	SPY	ETF	249.69	249.83	249.69	249.76	47703.0
2017-09-13 08:05:00	SPY	ETF	249.76	249.78	249.75	249.75	8169.0
2017-09-13 08:10:00	SPY	ETF	249.76	249.79	249.76	249.77	6300.0
2017-09-13 08:15:00	SPY	ETF	249.75	249.76	249.73	249.73	18794.0
2017-09-13 08:20:00	SPY	ETF	249.74	249.75	249.72	249.74	6517.0
2017-09-13 08:25:00	SPY	ETF	249.75	249.75	249.72	249.74	24628.0
2017-09-13 08:30:00	SPY	ETF	249.74	249.75	249.71	249.72	41999.0
2017-09-13 08:35:00	SPY	ETF	249.71	249.71	249.63	249.68	111068.0
2017-09-13 08:40:00	SPY	ETF	249.68	249.72	249.68	249.69	38614.0
2017-09-13 08:45:00	SPY	ETF	249.68	249.75	249.68	249.75	36553.0
2017-09-13 08:50:00	SPY	ETF	249.74	249.77	249.74	249.74	47296.0
2017-09-13 08:55:00	SPY	ETF	249.76	249.8	249.76	249.77	30416.0
2017-09-13 09:00:00	SPY	ETF	249.78	249.81	249.75	249.75	30849.0
2017-09-13 09:05:00	SPY	ETF	249.75	249.75	249.71	249.73	25652.0
2017-09-13 09:10:00	SPY	ETF	249.73	249.73	249.68	249.72	33593.0
2017-09-13 09:15:00	SPY	ETF	249.71	249.71	249.66	249.67	29158.0
2017-09-13 09:20:00	SPY	ETF	249.67	249.71	249.67	249.67	35368.0
2017-09-13 09:25:00	SPY	ETF	249.67	249.72	249.63	249.71	172603.0

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

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