PREVIEW / stock_30min / 2021-01-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-20.parquet
  size:    2.3 MB
  rows:    114,574
  symbols: 2,712

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-01-20 04:00:00	AAPL	Stock	128.68	128.7	128.0	128.6	18825.0
2021-01-20 04:30:00	AAPL	Stock	128.55	128.75	128.5	128.68	9525.0
2021-01-20 05:00:00	AAPL	Stock	128.66	128.75	128.57	128.66	6414.0
2021-01-20 05:30:00	AAPL	Stock	128.64	128.75	128.61	128.72	9921.0
2021-01-20 06:00:00	AAPL	Stock	128.72	128.72	128.6	128.6	8245.0
2021-01-20 06:30:00	AAPL	Stock	128.61	128.65	128.46	128.58	9796.0
2021-01-20 07:00:00	AAPL	Stock	128.58	128.64	128.45	128.58	79580.0
2021-01-20 07:30:00	AAPL	Stock	128.59	128.73	128.58	128.73	64047.0
2021-01-20 08:00:00	AAPL	Stock	128.74	128.75	128.45	128.57	228433.0
2021-01-20 08:30:00	AAPL	Stock	128.57	128.69	128.5	128.68	120979.0
2021-01-20 09:00:00	AAPL	Stock	128.69	128.75	128.56	128.59	271089.0
2021-01-20 09:30:00	AAPL	Stock	128.59	130.423	128.55	129.985	13537673.0
2021-01-20 10:00:00	AAPL	Stock	129.985	131.2	129.8	131.12	9709380.0
2021-01-20 10:30:00	AAPL	Stock	131.13	131.82	130.91	131.71	7968515.0
2021-01-20 11:00:00	AAPL	Stock	131.708	131.89	131.062	131.842	6369885.0
2021-01-20 11:30:00	AAPL	Stock	131.84	132.25	131.68	132.085	5562327.0
2021-01-20 12:00:00	AAPL	Stock	132.09	132.22	131.74	131.96	3966008.0
2021-01-20 12:30:00	AAPL	Stock	131.97	132.027	131.68	131.87	3221435.0
2021-01-20 13:00:00	AAPL	Stock	131.87	132.21	131.82	132.158	3759850.0
2021-01-20 13:30:00	AAPL	Stock	132.17	132.44	131.9	131.934	3589891.0
2021-01-20 14:00:00	AAPL	Stock	131.935	132.2	131.73	132.194	3683064.0
2021-01-20 14:30:00	AAPL	Stock	132.19	132.49	132.12	132.183	3818639.0
2021-01-20 15:00:00	AAPL	Stock	132.18	132.33	131.94	132.18	3888185.0
2021-01-20 15:30:00	AAPL	Stock	132.18	132.46	131.97	131.97	8385254.0
2021-01-20 16:00:00	AAPL	Stock	131.98	132.25	131.96	132.1	13053075.0
2021-01-20 16:30:00	AAPL	Stock	132.14	132.28	132.03	132.25	140751.0
2021-01-20 17:00:00	AAPL	Stock	132.25	132.27	132.2	132.22	27520.0
2021-01-20 17:30:00	AAPL	Stock	132.22	132.25	132.17	132.22	27292.0
2021-01-20 18:00:00	AAPL	Stock	132.23	132.4	132.19	132.37	98603.0
2021-01-20 18:30:00	AAPL	Stock	132.39	132.55	132.36	132.55	100544.0
2021-01-20 19:00:00	AAPL	Stock	132.52	132.57	132.41	132.43	52458.0
2021-01-20 19:30:00	AAPL	Stock	132.46	133.0	132.43	133.0	156708.0
2021-01-20 04:00:00	MSFT	Stock	217.28	217.3	217.18	217.18	1604.0
2021-01-20 04:30:00	MSFT	Stock	217.21	217.47	217.21	217.45	2199.0
2021-01-20 05:00:00	MSFT	Stock	217.32	217.55	217.32	217.55	529.0
2021-01-20 05:30:00	MSFT	Stock	217.55	217.97	217.55	217.97	2366.0
2021-01-20 06:00:00	MSFT	Stock	217.83	218.07	217.5	217.5	26046.0
2021-01-20 06:30:00	MSFT	Stock	217.45	217.49	217.32	217.38	5699.0
2021-01-20 07:00:00	MSFT	Stock	217.38	217.49	217.35	217.41	11729.0
2021-01-20 07:30:00	MSFT	Stock	217.48	217.78	217.41	217.78	7281.0
2021-01-20 08:00:00	MSFT	Stock	217.8	218.01	216.44	217.61	34551.0
2021-01-20 08:30:00	MSFT	Stock	217.7	217.9	217.58	217.67	11306.0
2021-01-20 09:00:00	MSFT	Stock	217.76	218.2	217.52	217.91	55180.0
2021-01-20 09:30:00	MSFT	Stock	217.88	221.25	217.291	221.18	4475346.0
2021-01-20 10:00:00	MSFT	Stock	221.15	223.19	220.99	222.58	3442675.0
2021-01-20 10:30:00	MSFT	Stock	222.56	224.31	222.56	223.81	3045463.0
2021-01-20 11:00:00	MSFT	Stock	223.8	225.192	223.45	224.54	2610879.0
2021-01-20 11:30:00	MSFT	Stock	224.53	224.57	223.72	223.91	1450864.0
2021-01-20 12:00:00	MSFT	Stock	223.94	224.39	223.73	224.32	1015233.0
2021-01-20 12:30:00	MSFT	Stock	224.3	224.92	224.174	224.82	996003.0

> showing 50 of 114,574 rows — these rows as CSV

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