PREVIEW / etf_5min / 2020-04-02

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-04-02.parquet
  size:    1.7 MB
  rows:    78,211

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-04-02 04:00:00	SPY	ETF	249.53	250.06	249.53	250.06	22705.0
2020-04-02 04:05:00	SPY	ETF	250.05	250.25	250.03	250.22	28006.0
2020-04-02 04:10:00	SPY	ETF	250.18	250.23	249.89	250.21	23274.0
2020-04-02 04:15:00	SPY	ETF	250.21	250.44	250.21	250.39	54661.0
2020-04-02 04:20:00	SPY	ETF	250.36	250.63	250.28	250.31	29017.0
2020-04-02 04:25:00	SPY	ETF	250.35	250.42	250.17	250.27	116057.0
2020-04-02 04:30:00	SPY	ETF	250.22	250.36	250.14	250.33	91658.0
2020-04-02 04:35:00	SPY	ETF	250.3	250.45	250.2	250.25	138958.0
2020-04-02 04:40:00	SPY	ETF	250.25	250.27	249.88	250.06	74942.0
2020-04-02 04:45:00	SPY	ETF	250.05	250.06	249.84	249.92	17287.0
2020-04-02 04:50:00	SPY	ETF	249.92	250.03	249.59	249.66	18272.0
2020-04-02 04:55:00	SPY	ETF	249.65	249.69	249.53	249.67	17654.0
2020-04-02 05:00:00	SPY	ETF	249.65	249.83	249.28	249.83	18067.0
2020-04-02 05:05:00	SPY	ETF	249.79	249.79	249.49	249.63	4455.0
2020-04-02 05:10:00	SPY	ETF	249.79	249.8	249.45	249.45	3606.0
2020-04-02 05:15:00	SPY	ETF	249.71	249.8	249.53	249.8	6934.0
2020-04-02 05:20:00	SPY	ETF	249.79	249.86	249.7	249.79	8457.0
2020-04-02 05:25:00	SPY	ETF	249.68	249.75	249.36	249.61	14311.0
2020-04-02 05:30:00	SPY	ETF	249.72	249.83	249.64	249.71	6580.0
2020-04-02 05:35:00	SPY	ETF	249.7	249.7	249.08	249.25	29995.0
2020-04-02 05:40:00	SPY	ETF	249.28	249.39	249.02	249.39	3471.0
2020-04-02 05:45:00	SPY	ETF	249.3	249.3	248.89	249.02	13361.0
2020-04-02 05:50:00	SPY	ETF	248.99	249.19	248.94	249.19	9657.0
2020-04-02 05:55:00	SPY	ETF	249.2	249.38	249.0	249.05	9305.0
2020-04-02 06:00:00	SPY	ETF	249.02	249.02	248.5	248.85	39866.0
2020-04-02 06:05:00	SPY	ETF	248.88	248.98	248.85	248.95	3040.0
2020-04-02 06:10:00	SPY	ETF	248.99	249.38	248.99	249.33	31091.0
2020-04-02 06:15:00	SPY	ETF	249.3	249.32	249.0	249.13	4002.0
2020-04-02 06:20:00	SPY	ETF	249.22	249.34	249.22	249.31	5172.0
2020-04-02 06:25:00	SPY	ETF	249.32	249.67	249.32	249.52	10812.0
2020-04-02 06:30:00	SPY	ETF	249.55	249.67	249.43	249.43	16533.0
2020-04-02 06:35:00	SPY	ETF	249.35	249.5	249.34	249.5	8273.0
2020-04-02 06:40:00	SPY	ETF	249.56	249.71	249.49	249.7	10618.0
2020-04-02 06:45:00	SPY	ETF	249.6	249.69	249.44	249.46	8798.0
2020-04-02 06:50:00	SPY	ETF	249.4	249.4	249.02	249.17	27219.0
2020-04-02 06:55:00	SPY	ETF	249.06	249.48	249.06	249.48	66403.0
2020-04-02 07:00:00	SPY	ETF	249.46	249.53	249.0	249.0	58135.0
2020-04-02 07:05:00	SPY	ETF	249.03	249.25	248.68	248.69	45579.0
2020-04-02 07:10:00	SPY	ETF	248.74	248.92	248.65	248.67	57790.0
2020-04-02 07:15:00	SPY	ETF	248.69	249.06	248.69	249.0	17829.0
2020-04-02 07:20:00	SPY	ETF	249.08	249.22	249.0	249.15	35111.0
2020-04-02 07:25:00	SPY	ETF	249.2	249.23	248.9	249.15	72143.0
2020-04-02 07:30:00	SPY	ETF	249.16	249.21	248.8	249.19	35038.0
2020-04-02 07:35:00	SPY	ETF	249.21	249.21	249.04	249.09	28328.0
2020-04-02 07:40:00	SPY	ETF	249.16	249.21	248.9	248.98	26422.0
2020-04-02 07:45:00	SPY	ETF	249.03	249.48	249.02	249.45	78270.0
2020-04-02 07:50:00	SPY	ETF	249.45	249.73	249.45	249.57	42455.0
2020-04-02 07:55:00	SPY	ETF	249.56	250.02	249.51	249.88	61366.0
2020-04-02 08:00:00	SPY	ETF	248.6101	250.18	246.15	249.91	285826.0
2020-04-02 08:05:00	SPY	ETF	249.99	250.0	249.46	249.48	49729.0

> showing 50 of 78,211 rows — these rows as CSV

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