PREVIEW / etf_5min / 2020-03-23

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-23.parquet
  size:    2.1 MB
  rows:    93,417

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-03-23 04:00:00	SPY	ETF	221.14	222.0	220.7	220.71	67611.0
2020-03-23 04:05:00	SPY	ETF	220.69	221.71	220.42	221.5	38749.0
2020-03-23 04:10:00	SPY	ETF	221.5	221.63	220.44	220.75	22758.0
2020-03-23 04:15:00	SPY	ETF	220.6	221.2	219.79	220.92	31544.0
2020-03-23 04:20:00	SPY	ETF	220.98	220.98	219.87	219.92	11955.0
2020-03-23 04:25:00	SPY	ETF	220.0	221.21	220.0	220.94	11321.0
2020-03-23 04:30:00	SPY	ETF	221.2	221.35	220.5	221.03	22577.0
2020-03-23 04:35:00	SPY	ETF	221.35	221.8	220.8	220.84	23429.0
2020-03-23 04:40:00	SPY	ETF	221.0	221.4	220.9	221.26	12108.0
2020-03-23 04:45:00	SPY	ETF	221.35	221.9	221.33	221.55	10701.0
2020-03-23 04:50:00	SPY	ETF	221.31	221.7	220.75	221.0	6512.0
2020-03-23 04:55:00	SPY	ETF	221.17	221.49	220.8	220.8	3691.0
2020-03-23 05:00:00	SPY	ETF	220.84	222.49	220.84	222.34	14802.0
2020-03-23 05:05:00	SPY	ETF	222.59	222.85	222.1	222.59	5511.0
2020-03-23 05:10:00	SPY	ETF	222.23	222.35	221.57	221.66	19236.0
2020-03-23 05:15:00	SPY	ETF	221.7	222.16	221.2	222.16	9629.0
2020-03-23 05:20:00	SPY	ETF	221.94	222.77	221.67	221.67	18565.0
2020-03-23 05:25:00	SPY	ETF	221.68	221.68	220.95	221.46	22378.0
2020-03-23 05:30:00	SPY	ETF	221.77	222.37	221.62	222.37	10890.0
2020-03-23 05:35:00	SPY	ETF	222.18	222.6	222.17	222.48	12200.0
2020-03-23 05:40:00	SPY	ETF	222.24	222.39	222.02	222.28	11024.0
2020-03-23 05:45:00	SPY	ETF	222.55	223.63	222.55	223.1	35613.0
2020-03-23 05:50:00	SPY	ETF	223.19	223.25	222.37	222.97	28204.0
2020-03-23 05:55:00	SPY	ETF	223.0	223.1	222.52	222.52	8525.0
2020-03-23 06:00:00	SPY	ETF	222.36	222.49	222.0	222.43	11222.0
2020-03-23 06:05:00	SPY	ETF	222.4	223.15	222.4	223.15	12261.0
2020-03-23 06:10:00	SPY	ETF	222.93	223.02	222.4	222.4	12753.0
2020-03-23 06:15:00	SPY	ETF	222.51	222.55	221.86	222.15	11985.0
2020-03-23 06:20:00	SPY	ETF	221.98	222.61	221.95	222.49	13860.0
2020-03-23 06:25:00	SPY	ETF	222.07	223.02	222.07	222.69	28187.0
2020-03-23 06:30:00	SPY	ETF	222.85	223.47	222.71	223.25	17072.0
2020-03-23 06:35:00	SPY	ETF	223.39	224.09	223.39	223.8	32562.0
2020-03-23 06:40:00	SPY	ETF	223.87	224.1	223.35	223.7	29780.0
2020-03-23 06:45:00	SPY	ETF	223.63	224.37	223.63	224.24	14300.0
2020-03-23 06:50:00	SPY	ETF	224.3	224.34	223.83	223.89	10069.0
2020-03-23 06:55:00	SPY	ETF	223.91	224.25	223.79	223.87	16202.0
2020-03-23 07:00:00	SPY	ETF	223.79	224.05	223.25	223.4	158853.0
2020-03-23 07:05:00	SPY	ETF	223.48	223.66	223.01	223.55	50762.0
2020-03-23 07:10:00	SPY	ETF	223.52	223.82	223.28	223.58	91070.0
2020-03-23 07:15:00	SPY	ETF	223.69	223.7	222.96	222.99	134121.0
2020-03-23 07:20:00	SPY	ETF	222.99	223.35	222.92	223.21	114746.0
2020-03-23 07:25:00	SPY	ETF	223.2	223.2	222.5	222.74	198341.0
2020-03-23 07:30:00	SPY	ETF	222.71	222.8	221.75	221.75	82069.0
2020-03-23 07:35:00	SPY	ETF	221.71	222.1	220.9	221.0	208213.0
2020-03-23 07:40:00	SPY	ETF	220.99	221.89	220.99	221.51	192948.0
2020-03-23 07:45:00	SPY	ETF	221.55	222.12	221.505	221.9	92284.0
2020-03-23 07:50:00	SPY	ETF	221.85	222.22	221.42	221.9	98268.0
2020-03-23 07:55:00	SPY	ETF	221.85	222.22	221.65	222.1	72799.0
2020-03-23 08:00:00	SPY	ETF	221.94	227.83	218.34	224.0	1306630.0
2020-03-23 08:05:00	SPY	ETF	227.83	228.63	226.15	228.45	894049.0

> showing 50 of 93,417 rows — these rows as CSV

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