PREVIEW / etf_5min / 2020-03-17

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-17.parquet
  size:    2.1 MB
  rows:    90,451

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-17 04:00:00	SPY	ETF	246.97	256.45	246.97	256.45	69687.0
2020-03-17 04:05:00	SPY	ETF	256.21	256.21	254.97	255.0	83017.0
2020-03-17 04:10:00	SPY	ETF	254.72	254.72	253.36	253.89	25103.0
2020-03-17 04:15:00	SPY	ETF	253.89	254.0	253.12	253.12	20011.0
2020-03-17 04:20:00	SPY	ETF	253.11	253.2	249.08	250.47	89718.0
2020-03-17 04:25:00	SPY	ETF	250.24	250.4	248.37	250.3	86407.0
2020-03-17 04:30:00	SPY	ETF	250.16	250.74	248.89	249.7	104203.0
2020-03-17 04:35:00	SPY	ETF	249.8	249.88	248.1	248.1	57942.0
2020-03-17 04:40:00	SPY	ETF	248.03	248.43	246.0	247.27	112312.0
2020-03-17 04:45:00	SPY	ETF	247.41	247.54	246.74	246.77	45434.0
2020-03-17 04:50:00	SPY	ETF	246.36	246.86	245.36	245.62	97575.0
2020-03-17 04:55:00	SPY	ETF	245.45	245.72	244.69	245.02	90244.0
2020-03-17 05:00:00	SPY	ETF	245.1	246.58	244.23	246.58	51847.0
2020-03-17 05:05:00	SPY	ETF	246.66	246.73	244.06	244.14	31123.0
2020-03-17 05:10:00	SPY	ETF	244.5	245.18	244.37	244.86	39237.0
2020-03-17 05:15:00	SPY	ETF	244.49	244.9	243.56	243.94	22540.0
2020-03-17 05:20:00	SPY	ETF	244.2	244.6	242.99	243.74	48649.0
2020-03-17 05:25:00	SPY	ETF	243.61	243.61	242.02	242.5	29268.0
2020-03-17 05:30:00	SPY	ETF	242.29	242.29	239.2	239.2	73674.0
2020-03-17 05:35:00	SPY	ETF	239.15	240.25	239.14	240.25	41841.0
2020-03-17 05:40:00	SPY	ETF	240.03	241.34	240.03	240.63	34924.0
2020-03-17 05:45:00	SPY	ETF	240.64	243.63	240.64	243.33	51655.0
2020-03-17 05:50:00	SPY	ETF	243.32	243.5	240.56	241.13	31399.0
2020-03-17 05:55:00	SPY	ETF	241.19	242.7	240.74	241.66	16338.0
2020-03-17 06:00:00	SPY	ETF	241.86	244.15	241.0	244.0	25605.0
2020-03-17 06:05:00	SPY	ETF	243.45	243.5	243.01	243.36	24247.0
2020-03-17 06:10:00	SPY	ETF	243.36	245.16	243.35	244.89	45107.0
2020-03-17 06:15:00	SPY	ETF	245.0	245.5	244.42	245.5	32867.0
2020-03-17 06:20:00	SPY	ETF	245.64	246.97	245.12	246.51	62603.0
2020-03-17 06:25:00	SPY	ETF	246.47	246.8	245.94	246.61	20822.0
2020-03-17 06:30:00	SPY	ETF	246.6	246.66	244.91	245.86	31225.0
2020-03-17 06:35:00	SPY	ETF	245.79	246.71	245.16	245.65	19240.0
2020-03-17 06:40:00	SPY	ETF	245.51	245.51	244.2	244.41	110644.0
2020-03-17 06:45:00	SPY	ETF	244.38	245.89	244.38	245.8	20795.0
2020-03-17 06:50:00	SPY	ETF	245.8	247.82	245.49	247.5	63430.0
2020-03-17 06:55:00	SPY	ETF	247.73	250.02	247.62	250.0	163670.0
2020-03-17 07:00:00	SPY	ETF	250.02	250.02	247.4	247.68	149388.0
2020-03-17 07:05:00	SPY	ETF	247.7	248.49	247.64	247.88	88191.0
2020-03-17 07:10:00	SPY	ETF	248.02	248.19	246.11	247.81	53122.0
2020-03-17 07:15:00	SPY	ETF	247.82	247.96	246.59	246.94	76978.0
2020-03-17 07:20:00	SPY	ETF	247.1	247.15	244.73	245.87	118203.0
2020-03-17 07:25:00	SPY	ETF	245.92	246.18	244.69	245.07	48583.0
2020-03-17 07:30:00	SPY	ETF	245.01	245.02	242.89	242.99	94679.0
2020-03-17 07:35:00	SPY	ETF	242.99	244.44	242.99	244.44	62255.0
2020-03-17 07:40:00	SPY	ETF	244.26	244.89	243.17	243.61	57669.0
2020-03-17 07:45:00	SPY	ETF	243.61	245.26	243.35	244.2	59311.0
2020-03-17 07:50:00	SPY	ETF	244.24	244.7	243.56	243.82	85640.0
2020-03-17 07:55:00	SPY	ETF	243.77	244.08	242.38	242.62	98065.0
2020-03-17 08:00:00	SPY	ETF	242.68	252.26	241.71	242.77	202057.0
2020-03-17 08:05:00	SPY	ETF	242.8	243.78	242.0	242.49	152579.0

> showing 50 of 90,451 rows — these rows as CSV

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