PREVIEW / etf_5min / 2018-03-22

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-22.parquet
  size:    1.4 MB
  rows:    62,212

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-03-22 04:00:00	SPY	ETF	268.99	269.11	268.84	268.92	7437.0
2018-03-22 04:05:00	SPY	ETF	269.04	269.28	269.04	269.28	3498.0
2018-03-22 04:10:00	SPY	ETF	269.26	269.44	269.14	269.44	2510.0
2018-03-22 04:15:00	SPY	ETF	269.45	269.46	269.45	269.46	1100.0
2018-03-22 04:30:00	SPY	ETF	269.6	269.6	269.6	269.6	500.0
2018-03-22 04:35:00	SPY	ETF	269.68	269.68	269.68	269.68	500.0
2018-03-22 04:50:00	SPY	ETF	269.62	269.62	269.49	269.56	765.0
2018-03-22 04:55:00	SPY	ETF	269.57	269.63	269.57	269.63	1700.0
2018-03-22 05:00:00	SPY	ETF	269.55	269.56	269.55	269.56	7920.0
2018-03-22 05:05:00	SPY	ETF	269.46	269.46	269.4	269.43	2840.0
2018-03-22 05:10:00	SPY	ETF	269.31	269.31	269.04	269.04	4750.0
2018-03-22 05:15:00	SPY	ETF	268.95	268.97	268.82	268.97	8204.0
2018-03-22 05:20:00	SPY	ETF	268.82	268.95	268.82	268.95	17290.0
2018-03-22 05:25:00	SPY	ETF	268.95	268.95	268.58	268.66	28258.0
2018-03-22 05:30:00	SPY	ETF	268.73	268.92	268.73	268.81	7988.0
2018-03-22 05:35:00	SPY	ETF	268.58	268.81	268.58	268.81	1106.0
2018-03-22 05:40:00	SPY	ETF	268.88	268.94	268.81	268.94	13727.0
2018-03-22 05:45:00	SPY	ETF	268.93	268.94	268.82	268.94	7645.0
2018-03-22 05:50:00	SPY	ETF	268.91	268.91	268.64	268.73	14306.0
2018-03-22 05:55:00	SPY	ETF	268.68	268.84	268.65	268.83	1168.0
2018-03-22 06:00:00	SPY	ETF	268.91	269.15	268.88	269.15	16409.0
2018-03-22 06:05:00	SPY	ETF	269.09	269.12	269.03	269.03	2106.0
2018-03-22 06:10:00	SPY	ETF	269.12	269.2	269.07	269.07	8645.0
2018-03-22 06:15:00	SPY	ETF	269.0	269.15	268.93	269.15	2627.0
2018-03-22 06:20:00	SPY	ETF	269.24	269.24	269.08	269.08	1490.0
2018-03-22 06:25:00	SPY	ETF	269.18	269.19	269.05	269.05	9121.0
2018-03-22 06:30:00	SPY	ETF	269.07	269.18	269.04	269.05	3000.0
2018-03-22 06:35:00	SPY	ETF	269.05	269.09	268.96	269.03	14967.0
2018-03-22 06:40:00	SPY	ETF	269.0	269.02	268.93	268.94	15607.0
2018-03-22 06:45:00	SPY	ETF	268.94	268.94	268.72	268.74	9081.0
2018-03-22 06:50:00	SPY	ETF	268.72	268.72	268.56	268.63	14433.0
2018-03-22 06:55:00	SPY	ETF	268.67	268.91	268.67	268.9	12215.0
2018-03-22 07:00:00	SPY	ETF	268.95	269.03	268.9	268.95	18510.0
2018-03-22 07:05:00	SPY	ETF	268.95	269.16	268.95	269.11	33770.0
2018-03-22 07:10:00	SPY	ETF	269.12	269.12	269.07	269.09	33118.0
2018-03-22 07:15:00	SPY	ETF	269.08	269.17	268.99	268.99	62325.0
2018-03-22 07:20:00	SPY	ETF	268.99	269.03	268.9	269.0	45524.0
2018-03-22 07:25:00	SPY	ETF	268.98	268.98	268.84	268.87	13438.0
2018-03-22 07:30:00	SPY	ETF	268.9	269.18	268.9	269.18	77086.0
2018-03-22 07:35:00	SPY	ETF	269.2	269.25	269.16	269.22	24050.0
2018-03-22 07:40:00	SPY	ETF	269.21	269.21	269.03	269.1	96598.0
2018-03-22 07:45:00	SPY	ETF	269.06	269.2	269.05	269.1	98674.0
2018-03-22 07:50:00	SPY	ETF	269.08	269.13	269.0	269.0	27200.0
2018-03-22 07:55:00	SPY	ETF	269.0	269.0	268.72	268.76	53848.0
2018-03-22 08:00:00	SPY	ETF	268.95	270.64	268.75	268.98	71869.0
2018-03-22 08:05:00	SPY	ETF	269.02	269.18	269.02	269.11	32012.0
2018-03-22 08:10:00	SPY	ETF	269.09	269.09	268.9	268.96	49344.0
2018-03-22 08:15:00	SPY	ETF	269.0	269.21	269.0	269.15	38986.0
2018-03-22 08:20:00	SPY	ETF	269.14	269.14	268.81	268.86	45870.0
2018-03-22 08:25:00	SPY	ETF	268.93	269.0	268.9	268.9	25435.0

> showing 50 of 62,212 rows — these rows as CSV

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