PREVIEW / etf_5min / 2020-07-09

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-07-09.parquet
  size:    1.6 MB
  rows:    76,152

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
2020-07-09 04:00:00	SPY	ETF	316.18	316.2	316.0	316.18	4979.0
2020-07-09 04:05:00	SPY	ETF	316.18	316.54	316.15	316.54	3038.0
2020-07-09 04:10:00	SPY	ETF	316.52	316.52	316.41	316.41	905.0
2020-07-09 04:15:00	SPY	ETF	316.44	316.47	316.44	316.47	508.0
2020-07-09 04:20:00	SPY	ETF	316.36	316.36	316.26	316.31	2486.0
2020-07-09 04:25:00	SPY	ETF	316.34	316.34	316.19	316.24	5718.0
2020-07-09 04:30:00	SPY	ETF	316.27	316.27	316.08	316.13	5593.0
2020-07-09 04:35:00	SPY	ETF	316.08	316.2	316.08	316.2	510.0
2020-07-09 04:40:00	SPY	ETF	316.38	316.38	316.18	316.21	6610.0
2020-07-09 04:45:00	SPY	ETF	316.16	316.23	316.15	316.16	13492.0
2020-07-09 04:50:00	SPY	ETF	316.21	316.25	316.18	316.25	1360.0
2020-07-09 04:55:00	SPY	ETF	316.3	316.3	316.16	316.16	1830.0
2020-07-09 05:00:00	SPY	ETF	316.09	316.16	316.09	316.09	2734.0
2020-07-09 05:05:00	SPY	ETF	316.16	316.16	316.16	316.16	400.0
2020-07-09 05:10:00	SPY	ETF	316.16	316.23	316.16	316.23	1200.0
2020-07-09 05:15:00	SPY	ETF	316.24	316.24	315.9	315.92	10086.0
2020-07-09 05:20:00	SPY	ETF	315.9	315.93	315.68	315.68	3392.0
2020-07-09 05:25:00	SPY	ETF	315.71	315.8	315.71	315.75	2614.0
2020-07-09 05:30:00	SPY	ETF	315.77	315.84	315.77	315.84	2141.0
2020-07-09 05:35:00	SPY	ETF	315.88	315.96	315.88	315.96	992.0
2020-07-09 05:40:00	SPY	ETF	315.96	315.98	315.9	315.9	711.0
2020-07-09 05:45:00	SPY	ETF	316.02	316.42	316.02	316.27	3815.0
2020-07-09 05:50:00	SPY	ETF	316.33	316.37	316.14	316.14	5681.0
2020-07-09 05:55:00	SPY	ETF	316.32	316.34	316.26	316.27	2417.0
2020-07-09 06:00:00	SPY	ETF	316.18	316.25	316.16	316.25	1130.0
2020-07-09 06:05:00	SPY	ETF	316.32	316.42	316.3	316.3	2904.0
2020-07-09 06:10:00	SPY	ETF	316.39	316.4	316.3	316.3	1156.0
2020-07-09 06:15:00	SPY	ETF	316.3	316.3	316.3	316.3	2533.0
2020-07-09 06:20:00	SPY	ETF	316.36	316.41	316.24	316.31	6233.0
2020-07-09 06:25:00	SPY	ETF	316.35	316.44	316.34	316.39	7724.0
2020-07-09 06:35:00	SPY	ETF	316.25	316.25	316.15	316.17	2319.0
2020-07-09 06:40:00	SPY	ETF	316.18	316.18	316.01	316.04	2146.0
2020-07-09 06:45:00	SPY	ETF	316.04	316.1	316.04	316.07	611.0
2020-07-09 06:50:00	SPY	ETF	316.05	316.05	315.88	315.89	6305.0
2020-07-09 06:55:00	SPY	ETF	315.84	315.99	315.84	315.99	3265.0
2020-07-09 07:00:00	SPY	ETF	316.04	316.14	315.96	316.14	19937.0
2020-07-09 07:05:00	SPY	ETF	316.14	316.14	316.04	316.04	7021.0
2020-07-09 07:10:00	SPY	ETF	316.07	316.13	316.04	316.05	9237.0
2020-07-09 07:15:00	SPY	ETF	316.1	316.18	316.08	316.15	17942.0
2020-07-09 07:20:00	SPY	ETF	316.17	316.21	316.1	316.2	7168.0
2020-07-09 07:25:00	SPY	ETF	316.21	316.78	316.18	316.67	24704.0
2020-07-09 07:30:00	SPY	ETF	316.63	316.63	316.52	316.61	10479.0
2020-07-09 07:35:00	SPY	ETF	316.6	316.73	316.6	316.65	8825.0
2020-07-09 07:40:00	SPY	ETF	316.65	316.67	316.57	316.67	6778.0
2020-07-09 07:45:00	SPY	ETF	316.66	316.66	316.53	316.57	6788.0
2020-07-09 07:50:00	SPY	ETF	316.59	316.59	316.51	316.55	8111.0
2020-07-09 07:55:00	SPY	ETF	316.57	316.69	316.52	316.59	4898.0
2020-07-09 08:00:00	SPY	ETF	316.0541	316.72	316.0	316.54	44245.0
2020-07-09 08:05:00	SPY	ETF	316.56	316.58	316.43	316.5	41208.0
2020-07-09 08:10:00	SPY	ETF	316.52	316.52	316.31	316.52	29240.0

> showing 50 of 76,152 rows — these rows as CSV

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