PREVIEW / etf_5min / 2019-05-16

all etf 5-min files

  file:    by_date/etf_5min/2019/2019-05-16.parquet
  size:    1.4 MB
  rows:    61,045

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
2019-05-16 04:00:00	SPY	ETF	284.67	284.71	284.49	284.52	1133.0
2019-05-16 04:05:00	SPY	ETF	284.95	284.95	284.64	284.73	757.0
2019-05-16 04:10:00	SPY	ETF	284.78	284.79	284.78	284.79	205.0
2019-05-16 04:15:00	SPY	ETF	285.0	285.0	285.0	285.0	335.0
2019-05-16 04:25:00	SPY	ETF	284.92	285.04	284.91	285.04	1825.0
2019-05-16 04:30:00	SPY	ETF	284.83	284.88	284.83	284.88	1466.0
2019-05-16 04:35:00	SPY	ETF	284.9	285.16	284.9	285.08	1477.0
2019-05-16 04:40:00	SPY	ETF	285.2	285.25	285.2	285.25	1005.0
2019-05-16 04:55:00	SPY	ETF	285.25	285.25	285.23	285.23	400.0
2019-05-16 05:00:00	SPY	ETF	285.42	285.42	285.42	285.42	417.0
2019-05-16 05:05:00	SPY	ETF	285.4	285.4	285.4	285.4	501.0
2019-05-16 05:10:00	SPY	ETF	285.37	285.4	285.37	285.4	5817.0
2019-05-16 05:20:00	SPY	ETF	285.2	285.2	285.2	285.2	301.0
2019-05-16 05:30:00	SPY	ETF	285.36	285.36	285.36	285.36	601.0
2019-05-16 05:35:00	SPY	ETF	285.27	285.3	285.27	285.3	201.0
2019-05-16 05:40:00	SPY	ETF	285.37	285.42	285.35	285.37	4910.0
2019-05-16 05:45:00	SPY	ETF	285.49	285.51	285.49	285.51	404.0
2019-05-16 05:50:00	SPY	ETF	285.57	285.57	285.56	285.56	1602.0
2019-05-16 05:55:00	SPY	ETF	285.63	285.63	285.63	285.63	501.0
2019-05-16 06:00:00	SPY	ETF	285.67	285.67	285.65	285.67	3263.0
2019-05-16 06:05:00	SPY	ETF	285.65	286.3	285.65	286.09	4043.0
2019-05-16 06:10:00	SPY	ETF	286.08	286.25	286.08	286.25	3793.0
2019-05-16 06:15:00	SPY	ETF	286.28	286.3	286.22	286.25	3356.0
2019-05-16 06:20:00	SPY	ETF	286.21	286.25	286.21	286.25	2500.0
2019-05-16 06:25:00	SPY	ETF	286.3	286.4	286.27	286.38	10955.0
2019-05-16 06:30:00	SPY	ETF	286.36	286.5	286.34	286.5	5065.0
2019-05-16 06:35:00	SPY	ETF	286.42	286.42	286.16	286.19	8137.0
2019-05-16 06:40:00	SPY	ETF	286.27	286.3	286.25	286.25	5333.0
2019-05-16 06:45:00	SPY	ETF	286.2	286.3	286.19	286.25	5133.0
2019-05-16 06:50:00	SPY	ETF	286.3	286.47	286.3	286.42	6841.0
2019-05-16 06:55:00	SPY	ETF	286.39	286.4	286.3	286.35	40574.0
2019-05-16 07:00:00	SPY	ETF	286.35	286.56	286.35	286.47	56026.0
2019-05-16 07:05:00	SPY	ETF	286.5	286.58	286.48	286.5	40465.0
2019-05-16 07:10:00	SPY	ETF	286.49	286.49	286.43	286.44	12077.0
2019-05-16 07:15:00	SPY	ETF	286.41	286.42	286.3	286.32	37755.0
2019-05-16 07:20:00	SPY	ETF	286.3	286.38	286.26	286.26	14882.0
2019-05-16 07:25:00	SPY	ETF	286.28	286.37	286.28	286.36	8379.0
2019-05-16 07:30:00	SPY	ETF	286.38	286.42	286.28	286.42	21917.0
2019-05-16 07:35:00	SPY	ETF	286.43	286.47	286.35	286.47	71713.0
2019-05-16 07:40:00	SPY	ETF	286.47	286.47	286.05	286.34	93089.0
2019-05-16 07:45:00	SPY	ETF	286.36	286.4	286.15	286.25	32814.0
2019-05-16 07:50:00	SPY	ETF	286.22	286.22	286.05	286.17	58869.0
2019-05-16 07:55:00	SPY	ETF	286.17	286.3	286.17	286.3	12051.0
2019-05-16 08:00:00	SPY	ETF	286.47	286.53	284.48	286.1	53810.0
2019-05-16 08:05:00	SPY	ETF	286.11	286.13	285.99	285.99	17484.0
2019-05-16 08:10:00	SPY	ETF	286.05	286.14	286.0	286.01	43481.0
2019-05-16 08:15:00	SPY	ETF	286.0	286.1	285.97	285.97	27117.0
2019-05-16 08:20:00	SPY	ETF	285.99	286.11	285.98	286.02	52825.0
2019-05-16 08:25:00	SPY	ETF	286.06	286.16	286.03	286.13	34436.0
2019-05-16 08:30:00	SPY	ETF	286.2	286.48	286.2	286.45	92382.0

> showing 50 of 61,045 rows — these rows as CSV

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