PREVIEW / etf_5min / 2018-03-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-03-01.parquet
  size:    1.5 MB
  rows:    63,697

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-01 04:00:00	SPY	ETF	272.0	272.0	271.62	271.68	17220.0
2018-03-01 04:05:00	SPY	ETF	271.71	271.72	271.51	271.59	16700.0
2018-03-01 04:10:00	SPY	ETF	271.65	271.67	271.49	271.49	2314.0
2018-03-01 04:15:00	SPY	ETF	271.46	271.59	271.46	271.59	5365.0
2018-03-01 04:20:00	SPY	ETF	271.55	271.58	271.55	271.56	780.0
2018-03-01 04:25:00	SPY	ETF	271.74	271.76	271.69	271.72	3470.0
2018-03-01 04:30:00	SPY	ETF	271.76	271.81	271.76	271.78	3030.0
2018-03-01 04:35:00	SPY	ETF	271.73	271.73	271.27	271.27	4631.0
2018-03-01 04:40:00	SPY	ETF	271.3	271.31	270.9	270.95	32057.0
2018-03-01 04:45:00	SPY	ETF	271.05	271.15	270.95	271.08	7991.0
2018-03-01 04:50:00	SPY	ETF	271.03	271.03	270.77	270.77	4754.0
2018-03-01 04:55:00	SPY	ETF	270.74	270.92	270.72	270.83	3426.0
2018-03-01 05:00:00	SPY	ETF	270.95	271.15	270.8	271.15	1625.0
2018-03-01 05:05:00	SPY	ETF	271.13	271.17	271.09	271.12	8373.0
2018-03-01 05:10:00	SPY	ETF	271.0	271.0	270.81	270.81	3738.0
2018-03-01 05:15:00	SPY	ETF	270.89	270.95	270.81	270.81	1844.0
2018-03-01 05:20:00	SPY	ETF	270.77	270.77	270.54	270.76	11716.0
2018-03-01 05:25:00	SPY	ETF	270.75	270.88	270.75	270.77	3772.0
2018-03-01 05:30:00	SPY	ETF	270.67	270.87	270.67	270.87	1589.0
2018-03-01 05:35:00	SPY	ETF	270.81	270.9	270.81	270.9	1655.0
2018-03-01 05:40:00	SPY	ETF	270.78	271.15	270.78	271.11	5203.0
2018-03-01 05:45:00	SPY	ETF	271.1	271.12	271.03	271.06	5880.0
2018-03-01 05:50:00	SPY	ETF	271.12	271.16	271.12	271.16	437.0
2018-03-01 05:55:00	SPY	ETF	271.0	271.13	271.0	271.13	2919.0
2018-03-01 06:00:00	SPY	ETF	271.07	271.25	271.06	271.25	4517.0
2018-03-01 06:05:00	SPY	ETF	271.24	271.32	271.24	271.26	5191.0
2018-03-01 06:10:00	SPY	ETF	271.14	271.21	271.14	271.21	626.0
2018-03-01 06:20:00	SPY	ETF	271.23	271.23	271.23	271.23	1002.0
2018-03-01 06:25:00	SPY	ETF	271.28	271.33	271.1	271.1	5710.0
2018-03-01 06:30:00	SPY	ETF	271.06	271.09	271.06	271.06	6567.0
2018-03-01 06:35:00	SPY	ETF	270.88	270.88	270.88	270.88	1161.0
2018-03-01 06:40:00	SPY	ETF	270.88	270.88	270.8	270.84	12704.0
2018-03-01 06:45:00	SPY	ETF	270.76	270.76	270.49	270.49	13276.0
2018-03-01 06:50:00	SPY	ETF	270.46	270.46	269.94	270.24	55782.0
2018-03-01 06:55:00	SPY	ETF	270.26	270.38	270.21	270.38	25375.0
2018-03-01 07:00:00	SPY	ETF	270.36	270.4	270.24	270.33	26008.0
2018-03-01 07:05:00	SPY	ETF	270.31	270.56	270.31	270.51	41530.0
2018-03-01 07:10:00	SPY	ETF	270.5	270.58	270.44	270.58	24124.0
2018-03-01 07:15:00	SPY	ETF	270.61	270.69	270.56	270.62	73251.0
2018-03-01 07:20:00	SPY	ETF	270.65	270.75	270.49	270.54	99738.0
2018-03-01 07:25:00	SPY	ETF	270.49	270.56	270.44	270.44	42701.0
2018-03-01 07:30:00	SPY	ETF	270.58	270.94	270.58	270.8	33786.0
2018-03-01 07:35:00	SPY	ETF	270.75	270.8	270.68	270.8	55185.0
2018-03-01 07:40:00	SPY	ETF	270.77	270.94	270.58	270.6	76710.0
2018-03-01 07:45:00	SPY	ETF	270.6	270.85	270.6	270.7	8065.0
2018-03-01 07:50:00	SPY	ETF	270.64	270.65	270.52	270.59	11076.0
2018-03-01 07:55:00	SPY	ETF	270.65	270.67	270.46	270.59	26271.0
2018-03-01 08:00:00	SPY	ETF	270.66	272.16	270.31	270.64	462735.0
2018-03-01 08:05:00	SPY	ETF	270.64	270.74	270.48	270.69	34108.0
2018-03-01 08:10:00	SPY	ETF	270.68	270.94	270.62	270.88	59407.0

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

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