PREVIEW / etf_5min / 2021-01-22

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-01-22.parquet
  size:    1.8 MB
  rows:    84,021

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
2021-01-22 04:00:00	SPY	ETF	382.59	382.66	382.46	382.59	4719.0
2021-01-22 04:05:00	SPY	ETF	382.71	382.71	382.41	382.44	8750.0
2021-01-22 04:10:00	SPY	ETF	382.47	382.48	382.32	382.39	4600.0
2021-01-22 04:15:00	SPY	ETF	382.41	382.41	382.17	382.19	1164.0
2021-01-22 04:20:00	SPY	ETF	382.19	382.24	382.06	382.22	1900.0
2021-01-22 04:25:00	SPY	ETF	382.14	382.17	382.08	382.17	300.0
2021-01-22 04:30:00	SPY	ETF	382.0	382.0	381.73	381.73	5307.0
2021-01-22 04:35:00	SPY	ETF	381.72	381.83	381.66	381.82	5650.0
2021-01-22 04:40:00	SPY	ETF	381.88	381.88	381.53	381.53	2400.0
2021-01-22 04:45:00	SPY	ETF	381.5	381.63	381.38	381.63	7212.0
2021-01-22 04:50:00	SPY	ETF	381.69	381.7	381.66	381.69	1300.0
2021-01-22 04:55:00	SPY	ETF	381.66	381.73	381.66	381.73	900.0
2021-01-22 05:00:00	SPY	ETF	381.6	381.67	381.5	381.67	27694.0
2021-01-22 05:05:00	SPY	ETF	381.69	381.78	381.68	381.71	11352.0
2021-01-22 05:10:00	SPY	ETF	381.74	381.75	381.71	381.71	300.0
2021-01-22 05:15:00	SPY	ETF	381.68	381.68	381.6	381.6	400.0
2021-01-22 05:25:00	SPY	ETF	381.82	381.98	381.82	381.94	5495.0
2021-01-22 05:30:00	SPY	ETF	382.05	382.05	381.87	381.9	15300.0
2021-01-22 05:35:00	SPY	ETF	381.91	381.91	381.85	381.86	2099.0
2021-01-22 05:45:00	SPY	ETF	381.82	381.82	381.75	381.75	400.0
2021-01-22 05:50:00	SPY	ETF	381.71	381.71	381.4	381.43	7000.0
2021-01-22 05:55:00	SPY	ETF	381.36	381.48	381.36	381.43	18475.0
2021-01-22 06:00:00	SPY	ETF	381.59	381.59	381.55	381.59	1988.0
2021-01-22 06:05:00	SPY	ETF	381.59	381.59	381.38	381.38	7800.0
2021-01-22 06:10:00	SPY	ETF	381.35	381.35	381.2	381.3	19519.0
2021-01-22 06:15:00	SPY	ETF	381.28	381.3	381.28	381.3	16000.0
2021-01-22 06:20:00	SPY	ETF	381.32	381.35	381.08	381.29	47700.0
2021-01-22 06:25:00	SPY	ETF	381.29	381.45	381.15	381.42	69090.0
2021-01-22 06:30:00	SPY	ETF	381.33	381.42	381.33	381.36	2603.0
2021-01-22 06:35:00	SPY	ETF	381.4	381.47	381.09	381.09	16201.0
2021-01-22 06:40:00	SPY	ETF	381.14	381.23	381.02	381.21	12554.0
2021-01-22 06:45:00	SPY	ETF	381.25	381.52	381.24	381.52	8695.0
2021-01-22 06:50:00	SPY	ETF	381.57	381.6	381.42	381.51	3469.0
2021-01-22 06:55:00	SPY	ETF	381.6	381.62	381.56	381.61	1114.0
2021-01-22 07:00:00	SPY	ETF	381.46	381.75	381.46	381.72	44636.0
2021-01-22 07:05:00	SPY	ETF	381.7	381.78	381.5	381.5	50603.0
2021-01-22 07:10:00	SPY	ETF	381.53	381.55	381.4	381.5	14191.0
2021-01-22 07:15:00	SPY	ETF	381.5	381.55	381.44	381.51	16122.0
2021-01-22 07:20:00	SPY	ETF	381.44	381.51	381.31	381.31	19361.0
2021-01-22 07:25:00	SPY	ETF	381.3	381.37	381.23	381.27	19295.0
2021-01-22 07:30:00	SPY	ETF	381.42	381.51	381.2	381.21	30166.0
2021-01-22 07:35:00	SPY	ETF	381.2	381.46	381.12	381.13	56107.0
2021-01-22 07:40:00	SPY	ETF	381.1	381.3	380.97	381.24	68308.0
2021-01-22 07:45:00	SPY	ETF	381.34	381.51	381.14	381.45	54047.0
2021-01-22 07:50:00	SPY	ETF	381.46	381.63	381.45	381.48	31386.0
2021-01-22 07:55:00	SPY	ETF	381.5	381.64	381.5	381.64	18845.0
2021-01-22 08:00:00	SPY	ETF	381.6	383.4	381.0	381.32	145849.0
2021-01-22 08:05:00	SPY	ETF	381.3	381.65	381.18	381.62	75950.0
2021-01-22 08:10:00	SPY	ETF	381.58	381.63	381.43	381.5	36539.0
2021-01-22 08:15:00	SPY	ETF	381.47	381.5	381.4	381.48	16238.0

> showing 50 of 84,021 rows — these rows as CSV

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