PREVIEW / stock_30min / 2021-08-06

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-06.parquet
  size:    2.2 MB
  rows:    109,185
  symbols: 2,804

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-06 04:00:00	AAPL	Stock	146.5	146.95	146.5	146.75	12326.0
2021-08-06 04:30:00	AAPL	Stock	146.81	146.81	146.7	146.76	1647.0
2021-08-06 05:00:00	AAPL	Stock	146.76	146.84	146.57	146.57	3897.0
2021-08-06 05:30:00	AAPL	Stock	146.57	146.74	146.57	146.72	1744.0
2021-08-06 06:00:00	AAPL	Stock	146.7	146.7	146.6	146.6	2734.0
2021-08-06 06:30:00	AAPL	Stock	146.58	146.64	146.53	146.53	2019.0
2021-08-06 07:00:00	AAPL	Stock	146.65	146.82	146.6	146.61	23870.0
2021-08-06 07:30:00	AAPL	Stock	146.63	146.72	146.62	146.65	24055.0
2021-08-06 08:00:00	AAPL	Stock	146.6001	146.83	146.6	146.64	84177.0
2021-08-06 08:30:00	AAPL	Stock	146.64	146.85	146.06	146.34	330908.0
2021-08-06 09:00:00	AAPL	Stock	146.33	146.44	146.14	146.32	179389.0
2021-08-06 09:30:00	AAPL	Stock	146.32	146.86	145.9	146.59	8033744.0
2021-08-06 10:00:00	AAPL	Stock	146.59	146.975	146.4	146.875	3673051.0
2021-08-06 10:30:00	AAPL	Stock	146.88	147.11	146.4438	146.53	3013602.0
2021-08-06 11:00:00	AAPL	Stock	146.54	146.7	146.015	146.24	3549241.0
2021-08-06 11:30:00	AAPL	Stock	146.2401	146.3	145.97	146.29	2267628.0
2021-08-06 12:00:00	AAPL	Stock	146.2891	146.33	146.07	146.235	1668797.0
2021-08-06 12:30:00	AAPL	Stock	146.23	146.28	145.91	146.1	1902663.0
2021-08-06 13:00:00	AAPL	Stock	146.1006	146.235	145.86	145.8999	1736192.0
2021-08-06 13:30:00	AAPL	Stock	145.89	145.95	145.72	145.94	1717167.0
2021-08-06 14:00:00	AAPL	Stock	145.9414	145.97	145.78	145.925	1479229.0
2021-08-06 14:30:00	AAPL	Stock	145.92	145.96	145.63	145.71	1906659.0
2021-08-06 15:00:00	AAPL	Stock	145.71	145.99	145.66	145.99	1960212.0
2021-08-06 15:30:00	AAPL	Stock	145.99	146.16	145.83	146.14	5567751.0
2021-08-06 16:00:00	AAPL	Stock	146.09	146.14	145.97	146.0	6711255.0
2021-08-06 16:30:00	AAPL	Stock	146.0	146.14	145.99	146.0	47781.0
2021-08-06 17:00:00	AAPL	Stock	146.0	146.01	145.95	145.96	28047.0
2021-08-06 17:30:00	AAPL	Stock	145.96	145.98	145.92	145.94	15681.0
2021-08-06 18:00:00	AAPL	Stock	145.97	145.97	145.91	145.93	10901.0
2021-08-06 18:30:00	AAPL	Stock	145.92	145.95	145.9	145.95	5987.0
2021-08-06 19:00:00	AAPL	Stock	145.94	145.98	145.92	145.93	7990.0
2021-08-06 19:30:00	AAPL	Stock	145.92	145.99	145.92	145.96	12184.0
2021-08-06 04:00:00	MSFT	Stock	289.8	289.97	289.5	289.97	8721.0
2021-08-06 04:30:00	MSFT	Stock	289.85	290.02	289.85	290.02	3662.0
2021-08-06 05:00:00	MSFT	Stock	290.09	290.18	289.91	289.92	3445.0
2021-08-06 05:30:00	MSFT	Stock	289.99	290.3	289.99	290.3	4149.0
2021-08-06 06:00:00	MSFT	Stock	290.06	290.06	289.55	289.6	5217.0
2021-08-06 06:30:00	MSFT	Stock	289.8	289.8	289.61	289.61	1381.0
2021-08-06 07:00:00	MSFT	Stock	289.79	289.79	289.6	289.6	4643.0
2021-08-06 07:30:00	MSFT	Stock	289.58	289.58	289.45	289.51	1122.0
2021-08-06 08:00:00	MSFT	Stock	289.6001	290.243	289.17	289.17	5499.0
2021-08-06 08:30:00	MSFT	Stock	289.15	289.21	288.06	288.5	51092.0
2021-08-06 09:00:00	MSFT	Stock	288.5	289.37	288.05	288.16	34144.0
2021-08-06 09:30:00	MSFT	Stock	288.16	289.5	288.14	288.5499	1594000.0
2021-08-06 10:00:00	MSFT	Stock	288.54	288.92	288.04	288.61	813748.0
2021-08-06 10:30:00	MSFT	Stock	288.65	288.83	287.6238	287.91	647602.0
2021-08-06 11:00:00	MSFT	Stock	287.93	288.36	287.71	288.31	552695.0
2021-08-06 11:30:00	MSFT	Stock	288.3	288.45	287.91	288.415	444594.0
2021-08-06 12:00:00	MSFT	Stock	288.42	288.5182	287.97	288.33	349104.0
2021-08-06 12:30:00	MSFT	Stock	288.33	288.45	288.04	288.33	311897.0

> showing 50 of 109,185 rows — these rows as CSV

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