PREVIEW / stock_30min / 2021-12-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-20.parquet
  size:    2.3 MB
  rows:    113,591
  symbols: 2,647

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-12-20 04:00:00	AAPL	Stock	167.98	168.49	167.05	167.41	56816.0
2021-12-20 04:30:00	AAPL	Stock	167.44	167.71	167.43	167.7	19504.0
2021-12-20 05:00:00	AAPL	Stock	167.77	167.99	167.45	167.64	35733.0
2021-12-20 05:30:00	AAPL	Stock	167.64	167.99	167.64	167.91	14062.0
2021-12-20 06:00:00	AAPL	Stock	167.9	168.3	167.71	168.04	45768.0
2021-12-20 06:30:00	AAPL	Stock	168.03	168.5	167.8	168.38	16712.0
2021-12-20 07:00:00	AAPL	Stock	168.39	168.79	167.95	167.95	145185.0
2021-12-20 07:30:00	AAPL	Stock	167.94	168.25	167.81	167.81	123337.0
2021-12-20 08:00:00	AAPL	Stock	168.4999	168.8292	167.7	167.78	509585.0
2021-12-20 08:30:00	AAPL	Stock	167.81	168.16	167.5	167.93	322664.0
2021-12-20 09:00:00	AAPL	Stock	167.95	168.5	167.82	168.28	369268.0
2021-12-20 09:30:00	AAPL	Stock	168.28	169.95	167.46	169.55	13045350.0
2021-12-20 10:00:00	AAPL	Stock	169.55	169.58	167.7201	167.945	8253095.0
2021-12-20 10:30:00	AAPL	Stock	167.94	169.1484	167.7301	168.391	6461239.0
2021-12-20 11:00:00	AAPL	Stock	168.39	169.13	167.95	168.73	5339440.0
2021-12-20 11:30:00	AAPL	Stock	168.73	169.69	168.31	169.5421	5105268.0
2021-12-20 12:00:00	AAPL	Stock	169.535	170.58	169.26	170.105	5658469.0
2021-12-20 12:30:00	AAPL	Stock	170.1	170.135	168.89	169.025	4758639.0
2021-12-20 13:00:00	AAPL	Stock	169.03	169.57	168.82	169.4216	3506728.0
2021-12-20 13:30:00	AAPL	Stock	169.421	170.07	169.185	169.76	3753689.0
2021-12-20 14:00:00	AAPL	Stock	169.76	170.29	169.42	169.5984	4375633.0
2021-12-20 14:30:00	AAPL	Stock	169.59	170.235	169.36	169.95	3534349.0
2021-12-20 15:00:00	AAPL	Stock	169.95	170.43	169.44	169.78	4749922.0
2021-12-20 15:30:00	AAPL	Stock	169.77	170.19	169.09	169.88	9304305.0
2021-12-20 16:00:00	AAPL	Stock	169.84	170.45	169.5	170.27	10324626.0
2021-12-20 16:30:00	AAPL	Stock	170.31	170.42	169.75	170.25	15212.0
2021-12-20 17:00:00	AAPL	Stock	170.27	170.28	169.75	170.15	260883.0
2021-12-20 17:30:00	AAPL	Stock	170.11	170.2	170.05	170.15	5698.0
2021-12-20 18:00:00	AAPL	Stock	170.15	170.79	170.15	170.62	36658.0
2021-12-20 18:30:00	AAPL	Stock	170.64	171.38	170.64	171.36	47535.0
2021-12-20 19:00:00	AAPL	Stock	171.36	171.38	170.9	170.94	50762.0
2021-12-20 19:30:00	AAPL	Stock	170.92	171.25	170.84	171.04	34790.0
2021-12-20 04:00:00	MSFT	Stock	319.3	319.3	317.37	318.5	8872.0
2021-12-20 04:30:00	MSFT	Stock	318.6	318.78	318.42	318.78	2847.0
2021-12-20 05:00:00	MSFT	Stock	318.8	319.01	318.8	318.8	1945.0
2021-12-20 05:30:00	MSFT	Stock	318.5	318.99	318.5	318.99	1068.0
2021-12-20 06:00:00	MSFT	Stock	318.98	318.98	318.98	318.98	242.0
2021-12-20 06:30:00	MSFT	Stock	319.3	319.49	318.81	319.49	2055.0
2021-12-20 07:00:00	MSFT	Stock	319.8	319.9	319.2	319.65	13912.0
2021-12-20 07:30:00	MSFT	Stock	319.55	319.62	319.5	319.5	17495.0
2021-12-20 08:00:00	MSFT	Stock	319.7885	319.9199	318.55	318.5654	62734.0
2021-12-20 08:30:00	MSFT	Stock	318.55	319.0	318.31	318.75	23534.0
2021-12-20 09:00:00	MSFT	Stock	318.9	320.0	318.9	319.95	15013.0
2021-12-20 09:30:00	MSFT	Stock	320.0	322.8	319.35	321.38	2100386.0
2021-12-20 10:00:00	MSFT	Stock	321.29	321.5154	318.65	319.28	1349778.0
2021-12-20 10:30:00	MSFT	Stock	319.22	321.39	318.83	319.36	1082255.0
2021-12-20 11:00:00	MSFT	Stock	319.36	319.69	318.06	318.39	1169126.0
2021-12-20 11:30:00	MSFT	Stock	318.37	319.22	317.57	319.21	1160112.0
2021-12-20 12:00:00	MSFT	Stock	319.23	320.28	318.83	319.42	705221.0
2021-12-20 12:30:00	MSFT	Stock	319.4	319.43	318.43	318.73	683797.0

> showing 50 of 113,591 rows — these rows as CSV

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