PREVIEW / etf_5min / 2018-04-26

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-26.parquet
  size:    1.3 MB
  rows:    55,554

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-26 04:00:00	SPY	ETF	263.94	264.08	263.93	264.05	7043.0
2018-04-26 04:05:00	SPY	ETF	264.13	264.13	264.09	264.12	1500.0
2018-04-26 04:10:00	SPY	ETF	264.16	264.22	264.09	264.22	2215.0
2018-04-26 04:20:00	SPY	ETF	264.18	264.18	264.05	264.08	2320.0
2018-04-26 04:25:00	SPY	ETF	264.1	264.11	264.1	264.11	729.0
2018-04-26 04:30:00	SPY	ETF	264.0	264.01	263.99	264.01	1400.0
2018-04-26 04:35:00	SPY	ETF	264.0	264.02	264.0	264.02	514.0
2018-04-26 04:40:00	SPY	ETF	264.04	264.14	264.04	264.14	1150.0
2018-04-26 04:45:00	SPY	ETF	264.13	264.13	264.13	264.13	100.0
2018-04-26 04:55:00	SPY	ETF	264.11	264.12	264.1	264.12	1600.0
2018-04-26 05:00:00	SPY	ETF	264.1	264.1	264.1	264.1	300.0
2018-04-26 05:05:00	SPY	ETF	264.07	264.07	264.02	264.02	2608.0
2018-04-26 05:10:00	SPY	ETF	264.04	264.04	264.04	264.04	200.0
2018-04-26 05:20:00	SPY	ETF	264.05	264.25	264.05	264.25	600.0
2018-04-26 05:25:00	SPY	ETF	264.32	264.37	264.32	264.36	1750.0
2018-04-26 05:30:00	SPY	ETF	264.35	264.41	264.34	264.41	2000.0
2018-04-26 05:40:00	SPY	ETF	264.45	264.57	264.45	264.57	1260.0
2018-04-26 05:45:00	SPY	ETF	264.6	264.6	264.6	264.6	300.0
2018-04-26 05:50:00	SPY	ETF	264.59	264.59	264.59	264.59	800.0
2018-04-26 05:55:00	SPY	ETF	264.61	264.61	264.57	264.57	1900.0
2018-04-26 06:00:00	SPY	ETF	264.59	264.59	264.53	264.54	49100.0
2018-04-26 06:05:00	SPY	ETF	264.57	264.57	264.52	264.52	2040.0
2018-04-26 06:10:00	SPY	ETF	264.5	264.54	264.5	264.53	13406.0
2018-04-26 06:15:00	SPY	ETF	264.46	264.75	264.45	264.75	6670.0
2018-04-26 06:20:00	SPY	ETF	264.71	264.72	264.7	264.7	3200.0
2018-04-26 06:25:00	SPY	ETF	264.63	264.63	264.63	264.63	350.0
2018-04-26 06:30:00	SPY	ETF	264.61	264.61	264.6	264.6	800.0
2018-04-26 06:35:00	SPY	ETF	264.7	264.74	264.7	264.7	2040.0
2018-04-26 06:40:00	SPY	ETF	264.74	264.74	264.7	264.71	3900.0
2018-04-26 06:45:00	SPY	ETF	264.63	264.63	264.6	264.62	12011.0
2018-04-26 06:50:00	SPY	ETF	264.71	264.85	264.71	264.85	3040.0
2018-04-26 06:55:00	SPY	ETF	264.88	264.89	264.84	264.84	13565.0
2018-04-26 07:00:00	SPY	ETF	264.84	264.84	264.8	264.82	3618.0
2018-04-26 07:05:00	SPY	ETF	264.82	264.88	264.82	264.83	13550.0
2018-04-26 07:10:00	SPY	ETF	264.79	264.8	264.76	264.79	12900.0
2018-04-26 07:15:00	SPY	ETF	264.8	264.84	264.76	264.77	28155.0
2018-04-26 07:20:00	SPY	ETF	264.71	264.8	264.7	264.77	17314.0
2018-04-26 07:25:00	SPY	ETF	264.8	264.8	264.72	264.77	37373.0
2018-04-26 07:30:00	SPY	ETF	264.75	264.85	264.68	264.78	34111.0
2018-04-26 07:35:00	SPY	ETF	264.78	264.8	264.63	264.8	4150.0
2018-04-26 07:40:00	SPY	ETF	264.8	264.93	264.8	264.93	12360.0
2018-04-26 07:45:00	SPY	ETF	264.94	265.11	264.94	265.06	28567.0
2018-04-26 07:50:00	SPY	ETF	265.06	265.14	265.02	265.02	6225.0
2018-04-26 07:55:00	SPY	ETF	265.0	265.0	264.91	264.95	19889.0
2018-04-26 08:00:00	SPY	ETF	264.6899	265.09	263.75	264.9499	29044.0
2018-04-26 08:05:00	SPY	ETF	264.94	265.02	264.9	264.9	19390.0
2018-04-26 08:10:00	SPY	ETF	264.97	265.07	264.97	265.07	6570.0
2018-04-26 08:15:00	SPY	ETF	265.07	265.08	265.0	265.01	27373.0
2018-04-26 08:20:00	SPY	ETF	264.99	264.99	264.94	264.96	30075.0
2018-04-26 08:25:00	SPY	ETF	265.04	265.04	264.93	264.96	30644.0

> showing 50 of 55,554 rows — these rows as CSV

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