PREVIEW / etf_5min / 2021-07-27

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-07-27.parquet
  size:    1.7 MB
  rows:    82,048

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-07-27 04:00:00	SPY	ETF	439.38	439.69	439.13	439.21	7715.0
2021-07-27 04:05:00	SPY	ETF	439.46	439.65	439.41	439.61	2750.0
2021-07-27 04:10:00	SPY	ETF	439.79	439.8	439.5	439.52	14754.0
2021-07-27 04:15:00	SPY	ETF	439.47	439.47	439.09	439.09	500.0
2021-07-27 04:20:00	SPY	ETF	439.04	439.04	438.82	439.0	7500.0
2021-07-27 04:25:00	SPY	ETF	438.82	438.82	438.72	438.72	1390.0
2021-07-27 04:30:00	SPY	ETF	438.77	439.0	438.77	439.0	250.0
2021-07-27 04:35:00	SPY	ETF	439.19	439.19	439.0	439.0	2700.0
2021-07-27 04:40:00	SPY	ETF	439.0	439.18	439.0	439.18	700.0
2021-07-27 04:45:00	SPY	ETF	439.32	439.32	439.18	439.19	5800.0
2021-07-27 04:50:00	SPY	ETF	439.25	439.25	439.24	439.24	400.0
2021-07-27 04:55:00	SPY	ETF	439.32	439.32	439.29	439.3	637.0
2021-07-27 05:00:00	SPY	ETF	439.25	439.25	438.95	438.95	4200.0
2021-07-27 05:05:00	SPY	ETF	439.06	439.16	439.03	439.16	1500.0
2021-07-27 05:10:00	SPY	ETF	439.12	439.13	438.85	438.85	7875.0
2021-07-27 05:15:00	SPY	ETF	438.8	439.12	438.8	439.11	5656.0
2021-07-27 05:20:00	SPY	ETF	439.13	439.13	439.13	439.13	400.0
2021-07-27 05:25:00	SPY	ETF	439.13	439.23	439.13	439.23	1300.0
2021-07-27 05:30:00	SPY	ETF	439.17	439.24	439.17	439.24	449.0
2021-07-27 05:35:00	SPY	ETF	439.3	439.7	439.3	439.6	8750.0
2021-07-27 05:40:00	SPY	ETF	439.65	439.65	439.65	439.65	500.0
2021-07-27 05:45:00	SPY	ETF	439.62	439.68	439.62	439.68	5100.0
2021-07-27 05:50:00	SPY	ETF	439.57	439.66	439.57	439.65	5100.0
2021-07-27 05:55:00	SPY	ETF	439.65	439.65	439.52	439.55	2100.0
2021-07-27 06:00:00	SPY	ETF	439.59	439.59	439.57	439.58	600.0
2021-07-27 06:05:00	SPY	ETF	439.65	439.72	439.65	439.66	2860.0
2021-07-27 06:10:00	SPY	ETF	439.67	439.67	439.54	439.54	900.0
2021-07-27 06:15:00	SPY	ETF	439.61	439.64	439.58	439.6	900.0
2021-07-27 06:20:00	SPY	ETF	439.67	439.74	439.67	439.69	750.0
2021-07-27 06:25:00	SPY	ETF	439.63	439.67	439.6	439.67	5405.0
2021-07-27 06:30:00	SPY	ETF	439.78	439.88	439.73	439.85	3101.0
2021-07-27 06:35:00	SPY	ETF	439.85	439.85	439.85	439.85	500.0
2021-07-27 06:40:00	SPY	ETF	439.83	439.91	439.83	439.91	1550.0
2021-07-27 06:45:00	SPY	ETF	440.0	440.05	440.0	440.0	1500.0
2021-07-27 06:50:00	SPY	ETF	440.03	440.03	439.88	439.95	800.0
2021-07-27 06:55:00	SPY	ETF	439.95	440.05	439.95	440.05	1499.0
2021-07-27 07:00:00	SPY	ETF	440.09	440.4	440.09	440.35	20843.0
2021-07-27 07:05:00	SPY	ETF	440.33	440.39	440.31	440.39	5458.0
2021-07-27 07:10:00	SPY	ETF	440.45	440.54	440.45	440.5	8344.0
2021-07-27 07:15:00	SPY	ETF	440.46	440.54	440.46	440.49	8379.0
2021-07-27 07:20:00	SPY	ETF	440.51	440.52	440.35	440.35	5443.0
2021-07-27 07:25:00	SPY	ETF	440.37	440.46	440.36	440.39	6966.0
2021-07-27 07:30:00	SPY	ETF	440.44	440.48	440.35	440.45	3910.0
2021-07-27 07:35:00	SPY	ETF	440.45	440.71	440.45	440.69	8187.0
2021-07-27 07:40:00	SPY	ETF	440.65	440.66	440.39	440.41	12745.0
2021-07-27 07:45:00	SPY	ETF	440.41	440.5	440.26	440.26	16936.0
2021-07-27 07:50:00	SPY	ETF	440.26	440.26	440.12	440.13	20615.0
2021-07-27 07:55:00	SPY	ETF	440.16	440.2	440.13	440.18	7520.0
2021-07-27 08:00:00	SPY	ETF	440.32	440.5196	438.82	440.35	19279.0
2021-07-27 08:05:00	SPY	ETF	440.35	440.35	440.2	440.21	5392.0

> showing 50 of 82,048 rows — these rows as CSV

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