PREVIEW / etf_5min / 2021-10-14

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-10-14.parquet
  size:    1.8 MB
  rows:    82,542

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-10-14 04:00:00	SPY	ETF	436.65	437.85	436.65	437.84	7092.0
2021-10-14 04:05:00	SPY	ETF	437.78	437.78	437.72	437.76	600.0
2021-10-14 04:10:00	SPY	ETF	437.96	438.15	437.94	438.14	2311.0
2021-10-14 04:15:00	SPY	ETF	438.11	438.11	437.99	438.0	400.0
2021-10-14 04:20:00	SPY	ETF	438.02	438.02	437.72	437.72	7498.0
2021-10-14 04:25:00	SPY	ETF	437.85	437.85	437.71	437.75	3736.0
2021-10-14 04:30:00	SPY	ETF	437.77	437.88	437.77	437.79	1292.0
2021-10-14 04:35:00	SPY	ETF	437.81	437.85	437.76	437.83	10423.0
2021-10-14 04:40:00	SPY	ETF	437.96	437.96	437.96	437.96	300.0
2021-10-14 04:45:00	SPY	ETF	438.0	438.04	437.9	438.04	17435.0
2021-10-14 04:50:00	SPY	ETF	438.0	438.11	438.0	438.07	15095.0
2021-10-14 04:55:00	SPY	ETF	438.0	438.01	437.95	437.95	2600.0
2021-10-14 05:00:00	SPY	ETF	438.02	438.04	438.02	438.04	403.0
2021-10-14 05:05:00	SPY	ETF	438.02	438.08	438.02	438.08	13400.0
2021-10-14 05:10:00	SPY	ETF	438.09	438.16	438.04	438.04	740.0
2021-10-14 05:15:00	SPY	ETF	438.08	438.08	437.99	437.99	2200.0
2021-10-14 05:20:00	SPY	ETF	438.01	438.06	437.96	438.06	1401.0
2021-10-14 05:25:00	SPY	ETF	438.04	438.08	438.04	438.08	400.0
2021-10-14 05:30:00	SPY	ETF	438.17	438.3	438.17	438.17	3400.0
2021-10-14 05:35:00	SPY	ETF	438.14	438.21	438.1	438.21	13596.0
2021-10-14 05:40:00	SPY	ETF	438.11	438.11	438.04	438.04	1900.0
2021-10-14 05:45:00	SPY	ETF	438.0	438.2	437.99	438.2	2740.0
2021-10-14 05:50:00	SPY	ETF	438.17	438.17	438.07	438.14	1965.0
2021-10-14 05:55:00	SPY	ETF	438.09	438.09	438.08	438.08	1909.0
2021-10-14 06:00:00	SPY	ETF	438.09	438.15	438.08	438.08	11289.0
2021-10-14 06:05:00	SPY	ETF	438.06	438.2	438.02	438.02	20784.0
2021-10-14 06:10:00	SPY	ETF	437.98	438.0	437.97	438.0	2269.0
2021-10-14 06:15:00	SPY	ETF	437.97	438.01	437.97	438.0	1700.0
2021-10-14 06:20:00	SPY	ETF	437.92	437.98	437.83	437.92	5500.0
2021-10-14 06:25:00	SPY	ETF	437.9	437.98	437.9	437.96	2802.0
2021-10-14 06:30:00	SPY	ETF	437.82	437.99	437.74	437.99	14000.0
2021-10-14 06:35:00	SPY	ETF	438.0	438.0	437.91	437.91	1278.0
2021-10-14 06:40:00	SPY	ETF	437.96	438.03	437.92	437.96	3745.0
2021-10-14 06:45:00	SPY	ETF	437.96	437.98	437.96	437.98	323.0
2021-10-14 06:50:00	SPY	ETF	438.05	438.07	438.01	438.07	2542.0
2021-10-14 06:55:00	SPY	ETF	438.0	438.01	437.96	438.01	3124.0
2021-10-14 07:00:00	SPY	ETF	437.93	438.04	437.87	438.04	9998.0
2021-10-14 07:05:00	SPY	ETF	438.05	438.09	437.96	438.09	14774.0
2021-10-14 07:10:00	SPY	ETF	438.1	438.29	438.1	438.21	12909.0
2021-10-14 07:15:00	SPY	ETF	438.21	438.47	438.21	438.38	6070.0
2021-10-14 07:20:00	SPY	ETF	438.4	438.41	438.31	438.37	27135.0
2021-10-14 07:25:00	SPY	ETF	438.4	438.44	438.22	438.24	20081.0
2021-10-14 07:30:00	SPY	ETF	438.23	438.44	438.23	438.4	12629.0
2021-10-14 07:35:00	SPY	ETF	438.37	438.5	438.37	438.5	42899.0
2021-10-14 07:40:00	SPY	ETF	438.46	438.71	438.46	438.71	15912.0
2021-10-14 07:45:00	SPY	ETF	438.66	438.7	438.6	438.64	23902.0
2021-10-14 07:50:00	SPY	ETF	438.67	438.88	438.67	438.86	24188.0
2021-10-14 07:55:00	SPY	ETF	438.86	439.0	438.86	438.93	22184.0
2021-10-14 08:00:00	SPY	ETF	437.948	439.0304	436.32	439.03	76332.0
2021-10-14 08:05:00	SPY	ETF	439.06	439.29	439.02	439.06	198095.0

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

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