PREVIEW / stock_5min / 2023-08-09

all stock 5-min files

  file:    by_date/stock_5min/2023/2023-08-09.parquet
  size:    6.7 MB
  rows:    407,020
  symbols: 1,514

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
2023-08-09 04:00:00	AAPL	Stock	180.77	180.92	180.75	180.91	5311.0
2023-08-09 04:05:00	AAPL	Stock	180.87	180.91	180.8	180.88	4902.0
2023-08-09 04:10:00	AAPL	Stock	180.85	180.9	180.84	180.9	2380.0
2023-08-09 04:15:00	AAPL	Stock	180.9	181.05	180.9	181.05	4699.0
2023-08-09 04:20:00	AAPL	Stock	181.06	181.28	181.05	181.28	969.0
2023-08-09 04:25:00	AAPL	Stock	181.29	181.4	181.29	181.4	1988.0
2023-08-09 04:30:00	AAPL	Stock	181.39	181.4	181.39	181.4	313.0
2023-08-09 04:35:00	AAPL	Stock	181.47	181.47	181.35	181.35	4019.0
2023-08-09 04:40:00	AAPL	Stock	181.3	181.32	181.23	181.23	593.0
2023-08-09 04:45:00	AAPL	Stock	181.3	181.44	181.3	181.44	2907.0
2023-08-09 04:55:00	AAPL	Stock	181.4	181.41	181.38	181.41	750.0
2023-08-09 05:00:00	AAPL	Stock	181.44	181.44	181.33	181.33	943.0
2023-08-09 05:05:00	AAPL	Stock	181.37	181.4	181.37	181.39	1310.0
2023-08-09 05:10:00	AAPL	Stock	181.36	181.41	181.23	181.38	3976.0
2023-08-09 05:15:00	AAPL	Stock	181.42	181.42	181.38	181.38	277.0
2023-08-09 05:20:00	AAPL	Stock	181.3	181.35	181.3	181.34	2865.0
2023-08-09 05:25:00	AAPL	Stock	181.38	181.38	181.38	181.38	210.0
2023-08-09 05:35:00	AAPL	Stock	181.36	181.36	181.36	181.36	536.0
2023-08-09 05:40:00	AAPL	Stock	181.34	181.35	181.34	181.35	778.0
2023-08-09 05:45:00	AAPL	Stock	181.21	181.22	181.21	181.21	367.0
2023-08-09 05:50:00	AAPL	Stock	181.22	181.22	181.2	181.21	516.0
2023-08-09 06:00:00	AAPL	Stock	181.26	181.26	181.26	181.26	271.0
2023-08-09 06:05:00	AAPL	Stock	181.25	181.25	181.25	181.25	255.0
2023-08-09 06:10:00	AAPL	Stock	181.21	181.21	181.1	181.1	2035.0
2023-08-09 06:15:00	AAPL	Stock	181.1	181.29	181.1	181.29	2106.0
2023-08-09 06:20:00	AAPL	Stock	181.25	181.25	181.25	181.25	100.0
2023-08-09 06:25:00	AAPL	Stock	181.27	181.27	181.27	181.27	400.0
2023-08-09 06:30:00	AAPL	Stock	181.27	181.28	181.23	181.23	700.0
2023-08-09 06:35:00	AAPL	Stock	181.25	181.25	181.25	181.25	141.0
2023-08-09 06:40:00	AAPL	Stock	181.21	181.21	181.1	181.1	3402.0
2023-08-09 06:45:00	AAPL	Stock	181.16	181.16	181.04	181.1	2909.0
2023-08-09 06:50:00	AAPL	Stock	181.22	181.22	181.22	181.22	168.0
2023-08-09 06:55:00	AAPL	Stock	181.2	181.22	181.02	181.02	5443.0
2023-08-09 07:00:00	AAPL	Stock	181.0	181.05	180.76	180.76	9197.0
2023-08-09 07:05:00	AAPL	Stock	180.75	180.75	180.6	180.7	1167.0
2023-08-09 07:10:00	AAPL	Stock	180.6	180.7	180.56	180.56	5434.0
2023-08-09 07:15:00	AAPL	Stock	180.62	180.7	180.61	180.62	7441.0
2023-08-09 07:20:00	AAPL	Stock	180.62	180.8	180.6	180.76	9785.0
2023-08-09 07:25:00	AAPL	Stock	180.77	180.79	180.68	180.76	6564.0
2023-08-09 07:30:00	AAPL	Stock	180.76	180.93	180.76	180.92	3975.0
2023-08-09 07:35:00	AAPL	Stock	180.95	180.98	180.92	180.92	5605.0
2023-08-09 07:40:00	AAPL	Stock	180.95	181.05	180.95	181.0	6736.0
2023-08-09 07:45:00	AAPL	Stock	180.99	181.09	180.99	181.06	3189.0
2023-08-09 07:50:00	AAPL	Stock	181.06	181.09	181.04	181.07	3209.0
2023-08-09 07:55:00	AAPL	Stock	181.08	181.1	181.05	181.06	3281.0
2023-08-09 08:00:00	AAPL	Stock	181.0	181.1	180.52	181.03	87436.0
2023-08-09 08:05:00	AAPL	Stock	181.04	181.05	180.9	180.9	23580.0
2023-08-09 08:10:00	AAPL	Stock	180.91	180.95	180.88	180.9016	10073.0
2023-08-09 08:15:00	AAPL	Stock	180.91	180.91	180.645	180.79	16974.0
2023-08-09 08:20:00	AAPL	Stock	180.79	180.82	180.7	180.77	23176.0

> showing 50 of 407,020 rows — these rows as CSV

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