PREVIEW / etf_5min / 2021-04-12

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-04-12.parquet
  size:    1.8 MB
  rows:    82,954

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-04-12 04:00:00	SPY	ETF	410.66	410.66	410.59	410.63	2508.0
2021-04-12 04:05:00	SPY	ETF	410.68	410.68	410.48	410.48	2700.0
2021-04-12 04:10:00	SPY	ETF	410.54	410.64	410.54	410.58	700.0
2021-04-12 04:15:00	SPY	ETF	410.51	410.51	410.41	410.41	3550.0
2021-04-12 04:20:00	SPY	ETF	410.5	410.5	410.46	410.46	600.0
2021-04-12 04:25:00	SPY	ETF	410.42	410.42	410.35	410.35	1000.0
2021-04-12 04:30:00	SPY	ETF	410.37	410.37	410.36	410.36	200.0
2021-04-12 04:35:00	SPY	ETF	410.42	410.42	410.42	410.42	200.0
2021-04-12 04:40:00	SPY	ETF	410.39	410.39	410.39	410.39	100.0
2021-04-12 04:45:00	SPY	ETF	410.55	410.55	410.54	410.54	400.0
2021-04-12 05:00:00	SPY	ETF	410.69	410.69	410.66	410.66	2000.0
2021-04-12 05:05:00	SPY	ETF	410.67	410.67	410.67	410.67	100.0
2021-04-12 05:15:00	SPY	ETF	410.76	410.76	410.73	410.73	300.0
2021-04-12 05:20:00	SPY	ETF	410.75	410.77	410.75	410.77	506.0
2021-04-12 05:25:00	SPY	ETF	410.79	410.82	410.7	410.82	1400.0
2021-04-12 05:30:00	SPY	ETF	410.89	410.9	410.72	410.72	1800.0
2021-04-12 05:35:00	SPY	ETF	410.79	410.89	410.79	410.89	1400.0
2021-04-12 05:40:00	SPY	ETF	410.85	410.95	410.84	410.94	5347.0
2021-04-12 05:45:00	SPY	ETF	410.87	410.87	410.85	410.85	200.0
2021-04-12 05:50:00	SPY	ETF	410.87	410.89	410.79	410.89	824.0
2021-04-12 06:00:00	SPY	ETF	410.75	410.75	410.73	410.73	508.0
2021-04-12 06:10:00	SPY	ETF	410.86	410.94	410.86	410.9	697.0
2021-04-12 06:15:00	SPY	ETF	410.9	410.9	410.66	410.66	1700.0
2021-04-12 06:20:00	SPY	ETF	410.69	410.7	410.69	410.7	700.0
2021-04-12 06:25:00	SPY	ETF	410.69	410.69	410.69	410.69	100.0
2021-04-12 06:30:00	SPY	ETF	410.69	410.72	410.69	410.72	1100.0
2021-04-12 06:35:00	SPY	ETF	410.67	410.69	410.67	410.69	700.0
2021-04-12 06:40:00	SPY	ETF	410.68	410.71	410.68	410.71	200.0
2021-04-12 06:45:00	SPY	ETF	410.7	410.72	410.69	410.72	2300.0
2021-04-12 06:50:00	SPY	ETF	410.75	410.75	410.69	410.69	800.0
2021-04-12 06:55:00	SPY	ETF	410.74	410.74	410.74	410.74	200.0
2021-04-12 07:00:00	SPY	ETF	410.72	410.8	410.69	410.8	8508.0
2021-04-12 07:05:00	SPY	ETF	410.85	410.92	410.85	410.89	3190.0
2021-04-12 07:10:00	SPY	ETF	410.9	411.03	410.9	410.99	6639.0
2021-04-12 07:15:00	SPY	ETF	410.98	411.04	410.91	411.04	3241.0
2021-04-12 07:20:00	SPY	ETF	411.03	411.17	411.03	411.17	4535.0
2021-04-12 07:25:00	SPY	ETF	411.16	411.16	411.11	411.11	2019.0
2021-04-12 07:30:00	SPY	ETF	411.13	411.16	410.99	411.01	7467.0
2021-04-12 07:35:00	SPY	ETF	411.0	411.0	410.87	410.9	2518.0
2021-04-12 07:40:00	SPY	ETF	410.95	411.05	410.95	411.03	2508.0
2021-04-12 07:45:00	SPY	ETF	411.06	411.06	410.77	410.77	4600.0
2021-04-12 07:50:00	SPY	ETF	410.82	410.9	410.78	410.87	2625.0
2021-04-12 07:55:00	SPY	ETF	410.87	410.88	410.78	410.848	6443.0
2021-04-12 08:00:00	SPY	ETF	410.9	411.16	410.46	410.79	19197.0
2021-04-12 08:05:00	SPY	ETF	410.75	410.92	410.75	410.92	3671.0
2021-04-12 08:10:00	SPY	ETF	410.86	410.86	410.69	410.71	10402.0
2021-04-12 08:15:00	SPY	ETF	410.71	410.8	410.71	410.8	6182.0
2021-04-12 08:20:00	SPY	ETF	410.8	410.89	410.74	410.78	2354.0
2021-04-12 08:25:00	SPY	ETF	410.89	410.92	410.88	410.92	1333.0
2021-04-12 08:30:00	SPY	ETF	410.95	411.01	410.93	410.98	27867.0

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

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