PREVIEW / etf_5min / 2021-08-04

all etf 5-min files

  file:    by_date/etf_5min/2021/2021-08-04.parquet
  size:    1.7 MB
  rows:    80,762

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-08-04 04:00:00	SPY	ETF	440.56	440.56	440.46	440.49	900.0
2021-08-04 04:05:00	SPY	ETF	440.44	440.47	440.38	440.41	950.0
2021-08-04 04:10:00	SPY	ETF	440.49	440.6	440.49	440.6	396.0
2021-08-04 04:15:00	SPY	ETF	440.68	440.69	440.67	440.67	568.0
2021-08-04 04:20:00	SPY	ETF	440.68	440.68	440.68	440.68	100.0
2021-08-04 04:40:00	SPY	ETF	440.7	440.7	440.7	440.7	100.0
2021-08-04 05:00:00	SPY	ETF	440.74	440.79	440.74	440.78	1238.0
2021-08-04 05:05:00	SPY	ETF	440.74	440.74	440.74	440.74	300.0
2021-08-04 05:10:00	SPY	ETF	440.74	440.74	440.74	440.74	100.0
2021-08-04 05:15:00	SPY	ETF	440.7	440.7	440.66	440.66	300.0
2021-08-04 05:20:00	SPY	ETF	440.72	440.72	440.72	440.72	100.0
2021-08-04 05:30:00	SPY	ETF	440.7	440.71	440.7	440.71	500.0
2021-08-04 05:35:00	SPY	ETF	440.76	440.82	440.76	440.79	1550.0
2021-08-04 05:40:00	SPY	ETF	440.83	440.83	440.83	440.83	100.0
2021-08-04 05:45:00	SPY	ETF	440.83	440.83	440.83	440.83	100.0
2021-08-04 05:50:00	SPY	ETF	440.9	440.9	440.9	440.9	492.0
2021-08-04 05:55:00	SPY	ETF	440.8	440.8	440.8	440.8	300.0
2021-08-04 06:00:00	SPY	ETF	440.79	440.79	440.79	440.79	200.0
2021-08-04 06:05:00	SPY	ETF	440.74	440.75	440.72	440.75	1380.0
2021-08-04 06:20:00	SPY	ETF	440.83	440.83	440.81	440.81	200.0
2021-08-04 06:25:00	SPY	ETF	440.8	440.8	440.8	440.8	200.0
2021-08-04 06:30:00	SPY	ETF	440.9	440.93	440.9	440.93	486.0
2021-08-04 06:40:00	SPY	ETF	440.91	440.93	440.9	440.93	2600.0
2021-08-04 06:45:00	SPY	ETF	440.97	440.98	440.97	440.98	200.0
2021-08-04 06:50:00	SPY	ETF	440.99	441.0	440.99	441.0	200.0
2021-08-04 06:55:00	SPY	ETF	440.87	440.87	440.78	440.82	800.0
2021-08-04 07:00:00	SPY	ETF	440.83	440.84	440.66	440.79	3856.0
2021-08-04 07:05:00	SPY	ETF	440.77	440.77	440.57	440.65	13800.0
2021-08-04 07:10:00	SPY	ETF	440.65	440.74	440.65	440.72	10715.0
2021-08-04 07:15:00	SPY	ETF	440.72	440.72	440.56	440.56	4510.0
2021-08-04 07:20:00	SPY	ETF	440.64	440.72	440.64	440.66	2646.0
2021-08-04 07:25:00	SPY	ETF	440.65	440.66	440.55	440.59	30806.0
2021-08-04 07:30:00	SPY	ETF	440.59	440.59	440.38	440.38	4651.0
2021-08-04 07:35:00	SPY	ETF	440.42	440.46	440.42	440.42	4192.0
2021-08-04 07:40:00	SPY	ETF	440.4	440.46	440.33	440.46	18229.0
2021-08-04 07:45:00	SPY	ETF	440.44	440.44	440.36	440.38	7366.0
2021-08-04 07:50:00	SPY	ETF	440.4	440.5	440.39	440.5	3155.0
2021-08-04 07:55:00	SPY	ETF	440.47	440.52	440.27	440.28	6330.0
2021-08-04 08:00:00	SPY	ETF	440.7499	440.84	440.11	440.21	37418.0
2021-08-04 08:05:00	SPY	ETF	440.22	440.39	440.22	440.39	8261.0
2021-08-04 08:10:00	SPY	ETF	440.3801	440.44	440.35	440.35	13874.0
2021-08-04 08:15:00	SPY	ETF	440.42	440.46	439.95	440.07	54743.0
2021-08-04 08:20:00	SPY	ETF	440.11	440.17	439.88	439.95	65883.0
2021-08-04 08:25:00	SPY	ETF	440.02	440.03	439.67	439.76	27643.0
2021-08-04 08:30:00	SPY	ETF	439.81	440.02	439.79	440.02	18683.0
2021-08-04 08:35:00	SPY	ETF	440.02	440.04	439.83	439.89	72319.0
2021-08-04 08:40:00	SPY	ETF	439.9	440.0	439.86	439.89	70251.0
2021-08-04 08:45:00	SPY	ETF	439.93	439.94	439.52	439.53	39699.0
2021-08-04 08:50:00	SPY	ETF	439.54	439.6	439.41	439.43	60117.0
2021-08-04 08:55:00	SPY	ETF	439.42	439.75	439.39	439.75	71805.0

> showing 50 of 80,762 rows — these rows as CSV

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