PREVIEW / etf_5min / 2021-03-23

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-03-23.parquet
  size:    1.8 MB
  rows:    86,761

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-03-23 04:00:00	SPY	ETF	391.78	391.78	391.57	391.64	7100.0
2021-03-23 04:05:00	SPY	ETF	391.58	391.58	390.95	391.1	5285.0
2021-03-23 04:10:00	SPY	ETF	391.23	391.28	391.23	391.28	600.0
2021-03-23 04:15:00	SPY	ETF	391.27	391.27	390.99	390.99	3740.0
2021-03-23 04:20:00	SPY	ETF	391.18	391.47	391.18	391.46	1300.0
2021-03-23 04:25:00	SPY	ETF	391.4	391.46	391.4	391.46	2100.0
2021-03-23 04:30:00	SPY	ETF	391.43	391.43	391.1	391.1	14798.0
2021-03-23 04:35:00	SPY	ETF	391.11	391.32	391.11	391.32	2600.0
2021-03-23 04:40:00	SPY	ETF	391.36	391.44	391.36	391.44	950.0
2021-03-23 04:45:00	SPY	ETF	391.36	391.36	391.36	391.36	400.0
2021-03-23 04:55:00	SPY	ETF	391.57	391.67	391.57	391.63	1700.0
2021-03-23 05:00:00	SPY	ETF	391.6	391.67	391.47	391.67	1270.0
2021-03-23 05:05:00	SPY	ETF	391.72	391.72	391.65	391.65	200.0
2021-03-23 05:10:00	SPY	ETF	391.62	391.62	391.51	391.56	1800.0
2021-03-23 05:15:00	SPY	ETF	391.56	391.56	391.56	391.56	100.0
2021-03-23 05:20:00	SPY	ETF	391.18	391.21	391.17	391.21	1700.0
2021-03-23 05:25:00	SPY	ETF	391.21	391.23	390.93	390.95	16999.0
2021-03-23 05:30:00	SPY	ETF	390.93	390.94	390.79	390.8	2500.0
2021-03-23 05:35:00	SPY	ETF	390.83	390.96	390.79	390.81	2900.0
2021-03-23 05:40:00	SPY	ETF	390.97	390.99	390.96	390.99	2000.0
2021-03-23 05:45:00	SPY	ETF	391.08	391.08	390.91	390.91	51306.0
2021-03-23 05:50:00	SPY	ETF	390.9	391.02	390.8	390.95	53289.0
2021-03-23 05:55:00	SPY	ETF	390.91	390.95	390.82	390.82	2100.0
2021-03-23 06:00:00	SPY	ETF	390.72	390.78	390.59	390.7	58020.0
2021-03-23 06:05:00	SPY	ETF	390.66	391.03	390.66	391.03	2840.0
2021-03-23 06:10:00	SPY	ETF	391.05	391.08	390.91	390.91	2700.0
2021-03-23 06:15:00	SPY	ETF	390.91	390.91	390.78	390.78	6449.0
2021-03-23 06:20:00	SPY	ETF	390.82	390.82	390.82	390.82	100.0
2021-03-23 06:25:00	SPY	ETF	390.67	390.7	390.4	390.7	3080.0
2021-03-23 06:30:00	SPY	ETF	390.64	390.76	390.63	390.76	2300.0
2021-03-23 06:35:00	SPY	ETF	390.73	390.82	390.53	390.81	7980.0
2021-03-23 06:40:00	SPY	ETF	390.73	391.0	390.73	390.9	29252.0
2021-03-23 06:45:00	SPY	ETF	390.84	391.02	390.84	391.01	62062.0
2021-03-23 06:50:00	SPY	ETF	391.0	391.0	390.95	390.97	5900.0
2021-03-23 06:55:00	SPY	ETF	390.97	391.11	390.93	391.09	4000.0
2021-03-23 07:00:00	SPY	ETF	391.1	391.2	391.03	391.03	18474.0
2021-03-23 07:05:00	SPY	ETF	391.03	391.16	390.85	390.9	53109.0
2021-03-23 07:10:00	SPY	ETF	390.93	390.96	390.87	390.95	4604.0
2021-03-23 07:15:00	SPY	ETF	390.95	391.12	390.95	391.07	6321.0
2021-03-23 07:20:00	SPY	ETF	391.13	391.54	391.13	391.5	22353.0
2021-03-23 07:25:00	SPY	ETF	391.5	391.5	391.32	391.34	16297.0
2021-03-23 07:30:00	SPY	ETF	391.42	391.52	391.41	391.46	8771.0
2021-03-23 07:35:00	SPY	ETF	391.49	391.56	391.49	391.53	19474.0
2021-03-23 07:40:00	SPY	ETF	391.58	391.65	391.53	391.54	17689.0
2021-03-23 07:45:00	SPY	ETF	391.52	391.59	391.5	391.52	12855.0
2021-03-23 07:50:00	SPY	ETF	391.52	391.65	391.39	391.39	25912.0
2021-03-23 07:55:00	SPY	ETF	391.45	391.45	391.17	391.17	72792.0
2021-03-23 08:00:00	SPY	ETF	391.1201	392.0	390.81	391.08	59836.0
2021-03-23 08:05:00	SPY	ETF	391.19	391.31	391.08	391.2	17312.0
2021-03-23 08:10:00	SPY	ETF	391.21	391.32	391.2	391.31	4373.0

> showing 50 of 86,761 rows — these rows as CSV

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