PREVIEW / etf_5min / 2018-05-01

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-05-01.parquet
  size:    1.3 MB
  rows:    56,781

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-05-01 04:00:00	SPY	ETF	264.59	264.59	264.59	264.59	365.0
2018-05-01 04:05:00	SPY	ETF	264.57	264.57	264.5	264.5	4900.0
2018-05-01 04:10:00	SPY	ETF	264.54	264.54	264.38	264.38	13400.0
2018-05-01 04:15:00	SPY	ETF	264.44	264.47	264.44	264.47	3816.0
2018-05-01 04:20:00	SPY	ETF	264.42	264.55	264.42	264.55	1500.0
2018-05-01 04:25:00	SPY	ETF	264.53	264.53	264.49	264.49	900.0
2018-05-01 04:30:00	SPY	ETF	264.45	264.49	264.44	264.44	2300.0
2018-05-01 04:35:00	SPY	ETF	264.43	264.43	264.3	264.3	1000.0
2018-05-01 04:40:00	SPY	ETF	264.22	264.25	264.22	264.25	3502.0
2018-05-01 04:45:00	SPY	ETF	264.16	264.18	264.13	264.18	3851.0
2018-05-01 04:50:00	SPY	ETF	264.19	264.21	264.1	264.21	3750.0
2018-05-01 04:55:00	SPY	ETF	264.14	264.14	264.1	264.1	3000.0
2018-05-01 05:00:00	SPY	ETF	264.08	264.08	264.05	264.08	1201.0
2018-05-01 05:05:00	SPY	ETF	264.11	264.11	264.1	264.1	1100.0
2018-05-01 05:10:00	SPY	ETF	264.12	264.13	264.12	264.13	600.0
2018-05-01 05:15:00	SPY	ETF	264.13	264.18	264.13	264.18	2555.0
2018-05-01 05:20:00	SPY	ETF	264.18	264.18	264.18	264.18	400.0
2018-05-01 05:25:00	SPY	ETF	264.19	264.19	264.18	264.18	952.0
2018-05-01 05:30:00	SPY	ETF	264.22	264.22	264.18	264.18	800.0
2018-05-01 05:35:00	SPY	ETF	264.15	264.15	264.15	264.15	1000.0
2018-05-01 05:45:00	SPY	ETF	264.27	264.27	264.27	264.27	1000.0
2018-05-01 05:50:00	SPY	ETF	264.28	264.28	264.28	264.28	1000.0
2018-05-01 06:00:00	SPY	ETF	264.35	264.35	264.25	264.25	2450.0
2018-05-01 06:05:00	SPY	ETF	264.28	264.28	264.28	264.28	1000.0
2018-05-01 06:10:00	SPY	ETF	264.28	264.28	264.28	264.28	400.0
2018-05-01 06:15:00	SPY	ETF	264.21	264.21	264.1	264.1	1405.0
2018-05-01 06:25:00	SPY	ETF	264.07	264.08	264.07	264.08	10055.0
2018-05-01 06:30:00	SPY	ETF	264.07	264.1	264.07	264.1	1200.0
2018-05-01 06:40:00	SPY	ETF	264.26	264.27	264.26	264.27	1250.0
2018-05-01 06:45:00	SPY	ETF	264.4	264.55	264.4	264.53	6860.0
2018-05-01 06:50:00	SPY	ETF	264.56	264.59	264.5	264.5	13100.0
2018-05-01 06:55:00	SPY	ETF	264.49	264.5	264.39	264.39	14560.0
2018-05-01 07:00:00	SPY	ETF	264.45	264.48	264.34	264.34	7773.0
2018-05-01 07:05:00	SPY	ETF	264.33	264.45	264.33	264.4	3271.0
2018-05-01 07:10:00	SPY	ETF	264.4	264.41	264.4	264.4	1300.0
2018-05-01 07:15:00	SPY	ETF	264.49	264.67	264.49	264.55	5850.0
2018-05-01 07:20:00	SPY	ETF	264.52	264.61	264.5	264.6	2605.0
2018-05-01 07:25:00	SPY	ETF	264.61	264.75	264.58	264.71	5800.0
2018-05-01 07:30:00	SPY	ETF	264.65	264.66	264.6	264.6	7054.0
2018-05-01 07:35:00	SPY	ETF	264.61	264.61	264.54	264.55	3405.0
2018-05-01 07:40:00	SPY	ETF	264.56	264.64	264.56	264.61	62130.0
2018-05-01 07:45:00	SPY	ETF	264.62	264.65	264.59	264.59	3165.0
2018-05-01 07:50:00	SPY	ETF	264.51	264.52	264.4	264.4	11608.0
2018-05-01 07:55:00	SPY	ETF	264.43	264.43	264.3	264.34	31290.0
2018-05-01 08:00:00	SPY	ETF	264.36	265.12	264.3	264.35	12930.0
2018-05-01 08:05:00	SPY	ETF	264.3501	264.37	264.17	264.21	73988.0
2018-05-01 08:10:00	SPY	ETF	264.21	264.25	264.18	264.18	9166.0
2018-05-01 08:15:00	SPY	ETF	264.2	264.32	264.17	264.28	38263.0
2018-05-01 08:20:00	SPY	ETF	264.3	264.32	264.21	264.32	59380.0
2018-05-01 08:25:00	SPY	ETF	264.35	264.4073	264.27	264.35	234560.0

> showing 50 of 56,781 rows — these rows as CSV

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