PREVIEW / etf_5min / 2018-04-05

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-04-05.parquet
  size:    1.3 MB
  rows:    57,520

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-05 04:00:00	SPY	ETF	265.7	265.73	265.55	265.6	13857.0
2018-04-05 04:05:00	SPY	ETF	265.56	265.62	265.48	265.5	5765.0
2018-04-05 04:10:00	SPY	ETF	265.53	265.66	265.48	265.66	5710.0
2018-04-05 04:15:00	SPY	ETF	265.6	265.83	265.59	265.76	924.0
2018-04-05 04:20:00	SPY	ETF	265.68	265.68	265.5	265.5	3800.0
2018-04-05 04:25:00	SPY	ETF	265.47	265.47	265.38	265.38	1069.0
2018-04-05 04:30:00	SPY	ETF	265.45	265.45	265.28	265.28	1915.0
2018-04-05 04:35:00	SPY	ETF	265.35	265.35	265.17	265.29	1070.0
2018-04-05 04:40:00	SPY	ETF	265.24	265.26	265.13	265.26	3830.0
2018-04-05 04:50:00	SPY	ETF	265.33	265.5	265.33	265.33	1700.0
2018-04-05 04:55:00	SPY	ETF	265.24	265.24	265.21	265.24	397.0
2018-04-05 05:00:00	SPY	ETF	265.1	265.12	264.96	265.0	2075.0
2018-04-05 05:05:00	SPY	ETF	265.11	265.17	264.88	264.88	2090.0
2018-04-05 05:10:00	SPY	ETF	265.15	265.15	265.0	265.0	3765.0
2018-04-05 05:15:00	SPY	ETF	265.05	265.05	265.05	265.05	300.0
2018-04-05 05:20:00	SPY	ETF	264.93	265.0	264.93	264.97	860.0
2018-04-05 05:25:00	SPY	ETF	265.03	265.03	265.03	265.03	500.0
2018-04-05 05:30:00	SPY	ETF	264.96	264.96	264.82	264.83	1858.0
2018-04-05 05:35:00	SPY	ETF	264.88	264.88	264.87	264.87	320.0
2018-04-05 05:40:00	SPY	ETF	264.8	264.8	264.7	264.73	4890.0
2018-04-05 05:45:00	SPY	ETF	264.73	264.87	264.73	264.85	951.0
2018-04-05 05:50:00	SPY	ETF	265.0	265.05	264.95	265.0	2400.0
2018-04-05 05:55:00	SPY	ETF	265.1	265.28	265.1	265.28	7535.0
2018-04-05 06:00:00	SPY	ETF	265.15	265.16	265.12	265.12	920.0
2018-04-05 06:05:00	SPY	ETF	265.11	265.28	265.04	265.28	6091.0
2018-04-05 06:10:00	SPY	ETF	265.21	265.21	265.16	265.16	250.0
2018-04-05 06:15:00	SPY	ETF	265.19	265.32	265.19	265.32	2850.0
2018-04-05 06:20:00	SPY	ETF	265.34	265.34	265.19	265.2	3850.0
2018-04-05 06:25:00	SPY	ETF	265.13	265.15	265.12	265.12	1200.0
2018-04-05 06:30:00	SPY	ETF	265.21	265.21	265.07	265.07	1000.0
2018-04-05 06:35:00	SPY	ETF	265.12	265.24	265.05	265.05	2540.0
2018-04-05 06:40:00	SPY	ETF	265.05	265.12	264.99	265.0	6612.0
2018-04-05 06:45:00	SPY	ETF	264.99	265.22	264.99	265.17	8405.0
2018-04-05 06:50:00	SPY	ETF	265.24	265.3	265.21	265.27	6000.0
2018-04-05 06:55:00	SPY	ETF	265.03	265.03	264.99	264.99	3801.0
2018-04-05 07:00:00	SPY	ETF	265.02	265.13	264.92	265.1	10396.0
2018-04-05 07:05:00	SPY	ETF	265.08	265.15	265.02	265.09	15061.0
2018-04-05 07:10:00	SPY	ETF	265.0	265.15	265.0	265.15	4337.0
2018-04-05 07:15:00	SPY	ETF	265.11	265.28	265.11	265.21	54161.0
2018-04-05 07:20:00	SPY	ETF	265.25	265.47	265.25	265.34	25314.0
2018-04-05 07:25:00	SPY	ETF	265.3	265.4	265.26	265.35	11214.0
2018-04-05 07:30:00	SPY	ETF	265.35	265.4	265.27	265.38	8811.0
2018-04-05 07:35:00	SPY	ETF	265.4	265.4	265.3	265.34	16260.0
2018-04-05 07:40:00	SPY	ETF	265.37	265.37	265.32	265.33	20373.0
2018-04-05 07:45:00	SPY	ETF	265.33	265.38	265.28	265.35	28240.0
2018-04-05 07:50:00	SPY	ETF	265.34	265.34	265.26	265.28	17002.0
2018-04-05 07:55:00	SPY	ETF	265.31	265.31	265.18	265.24	13063.0
2018-04-05 08:00:00	SPY	ETF	265.3	266.33	264.97	265.26	50100.0
2018-04-05 08:05:00	SPY	ETF	265.28	265.3	265.24	265.3	43708.0
2018-04-05 08:10:00	SPY	ETF	265.3	265.76	265.27	265.7	157185.0

> showing 50 of 57,520 rows — these rows as CSV

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