PREVIEW / stock_30min / 2021-08-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-09.parquet
  size:    2.2 MB
  rows:    111,155
  symbols: 2,798

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-09 04:00:00	AAPL	Stock	145.98	146.05	145.74	146.05	6007.0
2021-08-09 04:30:00	AAPL	Stock	146.0	146.05	146.0	146.0	2382.0
2021-08-09 05:00:00	AAPL	Stock	145.98	145.99	145.94	145.95	1588.0
2021-08-09 05:30:00	AAPL	Stock	146.0	146.02	145.98	146.02	4030.0
2021-08-09 06:00:00	AAPL	Stock	146.01	146.09	145.99	146.0	3890.0
2021-08-09 06:30:00	AAPL	Stock	145.99	146.06	145.93	146.02	1829.0
2021-08-09 07:00:00	AAPL	Stock	146.0	146.06	145.89	146.02	32627.0
2021-08-09 07:30:00	AAPL	Stock	146.04	146.05	146.01	146.03	17199.0
2021-08-09 08:00:00	AAPL	Stock	145.9001	146.04	145.83	145.985	61823.0
2021-08-09 08:30:00	AAPL	Stock	145.99	146.25	145.99	146.16	1201836.0
2021-08-09 09:00:00	AAPL	Stock	146.16	146.29	145.87	146.22	160842.0
2021-08-09 09:30:00	AAPL	Stock	146.23	146.7	145.52	146.51	7869950.0
2021-08-09 10:00:00	AAPL	Stock	146.51	146.69	146.015	146.4368	4100859.0
2021-08-09 10:30:00	AAPL	Stock	146.435	146.5899	145.95	146.0613	3413270.0
2021-08-09 11:00:00	AAPL	Stock	146.0643	146.16	145.79	146.09	2953981.0
2021-08-09 11:30:00	AAPL	Stock	146.1	146.15	145.91	146.1369	1913290.0
2021-08-09 12:00:00	AAPL	Stock	146.1398	146.15	145.82	145.8449	1575593.0
2021-08-09 12:30:00	AAPL	Stock	145.845	145.97	145.785	145.855	1376897.0
2021-08-09 13:00:00	AAPL	Stock	145.85	145.9699	145.81	145.9017	1218888.0
2021-08-09 13:30:00	AAPL	Stock	145.9092	146.09	145.82	145.835	1483332.0
2021-08-09 14:00:00	AAPL	Stock	145.8381	146.09	145.79	146.085	1579832.0
2021-08-09 14:30:00	AAPL	Stock	146.0899	146.13	145.98	146.055	1613841.0
2021-08-09 15:00:00	AAPL	Stock	146.045	146.1375	145.93	146.021	1799456.0
2021-08-09 15:30:00	AAPL	Stock	146.02	146.18	145.87	146.09	3727908.0
2021-08-09 16:00:00	AAPL	Stock	146.09	146.18	146.0	146.01	7100689.0
2021-08-09 16:30:00	AAPL	Stock	146.04	146.05	146.0	146.04	16783.0
2021-08-09 17:00:00	AAPL	Stock	146.05	146.05	146.0	146.03	7148.0
2021-08-09 17:30:00	AAPL	Stock	146.04	146.04	146.01	146.02	4518.0
2021-08-09 18:00:00	AAPL	Stock	146.03	146.05	146.01	146.04	14950.0
2021-08-09 18:30:00	AAPL	Stock	146.05	146.05	146.02	146.02	6581.0
2021-08-09 19:00:00	AAPL	Stock	146.04	146.04	146.02	146.03	6333.0
2021-08-09 19:30:00	AAPL	Stock	146.03	146.04	145.95	146.02	7568.0
2021-08-09 04:00:00	MSFT	Stock	289.2	289.55	289.2	289.55	4678.0
2021-08-09 04:30:00	MSFT	Stock	289.7	290.67	289.7	290.5	8404.0
2021-08-09 05:00:00	MSFT	Stock	290.21	290.38	290.21	290.38	566.0
2021-08-09 05:30:00	MSFT	Stock	290.29	290.29	290.08	290.08	828.0
2021-08-09 06:00:00	MSFT	Stock	290.37	290.38	290.37	290.38	1953.0
2021-08-09 06:30:00	MSFT	Stock	290.0	290.28	290.0	290.28	1000.0
2021-08-09 07:00:00	MSFT	Stock	290.02	290.38	289.93	290.31	4899.0
2021-08-09 07:30:00	MSFT	Stock	290.26	290.3	290.24	290.3	1389.0
2021-08-09 08:00:00	MSFT	Stock	289.9601	290.36	289.8301	289.96	20956.0
2021-08-09 08:30:00	MSFT	Stock	289.99	290.0201	289.85	289.91	8030.0
2021-08-09 09:00:00	MSFT	Stock	289.95	289.9799	289.5	289.77	14015.0
2021-08-09 09:30:00	MSFT	Stock	289.77	291.55	288.8098	289.33	1883656.0
2021-08-09 10:00:00	MSFT	Stock	289.35	289.6	288.92	289.27	804588.0
2021-08-09 10:30:00	MSFT	Stock	289.27	289.65	288.54	288.8	1020052.0
2021-08-09 11:00:00	MSFT	Stock	288.8001	289.02	288.2	288.64	673209.0
2021-08-09 11:30:00	MSFT	Stock	288.64	288.7	288.25	288.46	446647.0
2021-08-09 12:00:00	MSFT	Stock	288.47	288.6	287.96	287.98	552472.0
2021-08-09 12:30:00	MSFT	Stock	287.9809	288.1598	287.81	287.91	472400.0

> showing 50 of 111,155 rows — these rows as CSV

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