PREVIEW / etf_5min / 2018-04-02

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-02.parquet
  size:    1.5 MB
  rows:    63,609

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
2018-04-02 04:00:00	SPY	ETF	262.68	262.91	262.68	262.78	2126.0
2018-04-02 04:05:00	SPY	ETF	262.8	262.83	262.8	262.8	1820.0
2018-04-02 04:10:00	SPY	ETF	262.82	262.82	262.82	262.82	100.0
2018-04-02 04:15:00	SPY	ETF	262.86	262.86	262.74	262.74	920.0
2018-04-02 04:20:00	SPY	ETF	262.79	262.94	262.79	262.93	2880.0
2018-04-02 04:25:00	SPY	ETF	262.91	263.0	262.91	263.0	1340.0
2018-04-02 04:30:00	SPY	ETF	262.91	262.91	262.91	262.91	100.0
2018-04-02 04:55:00	SPY	ETF	262.77	262.77	262.77	262.77	118.0
2018-04-02 05:00:00	SPY	ETF	262.74	262.79	262.73	262.79	670.0
2018-04-02 05:10:00	SPY	ETF	262.85	262.85	262.85	262.85	100.0
2018-04-02 05:15:00	SPY	ETF	262.86	262.86	262.85	262.85	2500.0
2018-04-02 05:20:00	SPY	ETF	262.85	262.91	262.85	262.91	1037.0
2018-04-02 05:25:00	SPY	ETF	262.86	262.86	262.86	262.86	620.0
2018-04-02 05:35:00	SPY	ETF	262.83	262.83	262.83	262.83	180.0
2018-04-02 05:50:00	SPY	ETF	262.92	262.92	262.92	262.92	1000.0
2018-04-02 06:00:00	SPY	ETF	262.94	263.1	262.94	263.1	660.0
2018-04-02 06:05:00	SPY	ETF	263.03	263.03	263.02	263.02	3485.0
2018-04-02 06:15:00	SPY	ETF	263.02	263.04	263.02	263.04	1000.0
2018-04-02 06:20:00	SPY	ETF	263.03	263.03	263.03	263.03	1000.0
2018-04-02 06:30:00	SPY	ETF	263.0	263.04	263.0	263.04	1020.0
2018-04-02 06:35:00	SPY	ETF	263.05	263.1	263.05	263.1	3500.0
2018-04-02 06:45:00	SPY	ETF	262.92	262.95	262.92	262.95	1770.0
2018-04-02 06:50:00	SPY	ETF	263.0	263.0	263.0	263.0	270.0
2018-04-02 07:00:00	SPY	ETF	262.8	262.83	262.6	262.67	19123.0
2018-04-02 07:05:00	SPY	ETF	262.68	262.68	262.63	262.63	7055.0
2018-04-02 07:10:00	SPY	ETF	262.63	262.73	262.62	262.62	10513.0
2018-04-02 07:15:00	SPY	ETF	262.6	262.6	262.49	262.5	15634.0
2018-04-02 07:20:00	SPY	ETF	262.53	262.53	262.4	262.4	14590.0
2018-04-02 07:25:00	SPY	ETF	262.4	262.45	262.4	262.44	9880.0
2018-04-02 07:30:00	SPY	ETF	262.4	262.4	262.23	262.3	9909.0
2018-04-02 07:35:00	SPY	ETF	262.3	262.43	262.19	262.32	58406.0
2018-04-02 07:40:00	SPY	ETF	262.3	262.45	262.26	262.36	22450.0
2018-04-02 07:45:00	SPY	ETF	262.4	262.43	262.38	262.43	2360.0
2018-04-02 07:50:00	SPY	ETF	262.39	262.43	262.38	262.38	1905.0
2018-04-02 07:55:00	SPY	ETF	262.31	262.43	262.31	262.4	13510.0
2018-04-02 08:00:00	SPY	ETF	262.46	263.23	262.31	262.48	24235.0
2018-04-02 08:05:00	SPY	ETF	262.53	262.55	262.46	262.52	24860.0
2018-04-02 08:10:00	SPY	ETF	262.5	262.64	262.45	262.63	62483.0
2018-04-02 08:15:00	SPY	ETF	262.64	262.65	262.6	262.62	34860.0
2018-04-02 08:20:00	SPY	ETF	262.61	262.61	262.37	262.38	53988.0
2018-04-02 08:25:00	SPY	ETF	262.48	262.5	262.44	262.48	12633.0
2018-04-02 08:30:00	SPY	ETF	262.48	262.5	262.43	262.48	17649.0
2018-04-02 08:35:00	SPY	ETF	262.48	262.65	262.45	262.65	92036.0
2018-04-02 08:40:00	SPY	ETF	262.65	262.65	262.43	262.43	46174.0
2018-04-02 08:45:00	SPY	ETF	262.45	262.71	262.42	262.58	27737.0
2018-04-02 08:50:00	SPY	ETF	262.63	262.85	262.6	262.79	11184.0
2018-04-02 08:55:00	SPY	ETF	262.8	263.15	262.71	262.8	116664.0
2018-04-02 09:00:00	SPY	ETF	262.78	262.81	262.71	262.72	31401.0
2018-04-02 09:05:00	SPY	ETF	262.7	262.76	262.62	262.72	22046.0
2018-04-02 09:10:00	SPY	ETF	262.71	262.73	262.61	262.62	17703.0

> showing 50 of 63,609 rows — these rows as CSV

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