PREVIEW / stock_30min / 2021-01-05

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-05.parquet
  size:    2.2 MB
  rows:    110,936
  symbols: 2,677

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-05 04:00:00	AAPL	Stock	130.07	130.07	129.68	129.8	26474.0
2021-01-05 04:30:00	AAPL	Stock	129.83	130.2	129.75	130.02	19236.0
2021-01-05 05:00:00	AAPL	Stock	130.18	130.26	130.09	130.11	9712.0
2021-01-05 05:30:00	AAPL	Stock	130.09	130.2	129.97	130.2	19451.0
2021-01-05 06:00:00	AAPL	Stock	130.2	130.27	130.1	130.25	9267.0
2021-01-05 06:30:00	AAPL	Stock	130.25	130.3	129.5	129.56	46129.0
2021-01-05 07:00:00	AAPL	Stock	129.69	129.8	128.97	128.97	154774.0
2021-01-05 07:30:00	AAPL	Stock	128.97	129.57	128.85	129.45	233476.0
2021-01-05 08:00:00	AAPL	Stock	129.53	129.83	128.5	128.69	390748.0
2021-01-05 08:30:00	AAPL	Stock	128.69	128.87	128.35	128.4	274660.0
2021-01-05 09:00:00	AAPL	Stock	128.4	128.88	128.31	128.88	272011.0
2021-01-05 09:30:00	AAPL	Stock	128.88	131.48	128.43	131.31	13631779.0
2021-01-05 10:00:00	AAPL	Stock	131.32	131.74	130.7	131.052	8635944.0
2021-01-05 10:30:00	AAPL	Stock	131.07	131.419	130.431	130.52	5844660.0
2021-01-05 11:00:00	AAPL	Stock	130.535	130.69	129.93	130.38	5931249.0
2021-01-05 11:30:00	AAPL	Stock	130.375	130.68	130.2	130.29	4477107.0
2021-01-05 12:00:00	AAPL	Stock	130.29	130.302	129.84	130.15	4482292.0
2021-01-05 12:30:00	AAPL	Stock	130.145	130.34	129.85	130.145	3160972.0
2021-01-05 13:00:00	AAPL	Stock	130.15	130.24	129.94	130.045	2170714.0
2021-01-05 13:30:00	AAPL	Stock	130.041	130.63	130.04	130.625	3639024.0
2021-01-05 14:00:00	AAPL	Stock	130.63	131.25	130.595	131.11	4851881.0
2021-01-05 14:30:00	AAPL	Stock	131.11	131.405	130.85	130.95	3958500.0
2021-01-05 15:00:00	AAPL	Stock	130.96	131.27	130.815	130.83	3702569.0
2021-01-05 15:30:00	AAPL	Stock	130.833	131.45	130.76	130.95	7835210.0
2021-01-05 16:00:00	AAPL	Stock	131.01	131.32	130.82	130.83	10244308.0
2021-01-05 16:30:00	AAPL	Stock	130.83	131.01	130.81	130.93	71714.0
2021-01-05 17:00:00	AAPL	Stock	130.93	130.93	130.89	130.9	43415.0
2021-01-05 17:30:00	AAPL	Stock	130.9	130.92	130.85	130.9	28821.0
2021-01-05 18:00:00	AAPL	Stock	130.9	131.0	130.8	130.82	65969.0
2021-01-05 18:30:00	AAPL	Stock	130.81	130.85	130.7	130.75	50459.0
2021-01-05 19:00:00	AAPL	Stock	130.75	131.22	130.7	131.21	76672.0
2021-01-05 19:30:00	AAPL	Stock	131.2	131.4	130.6	130.65	153968.0
2021-01-05 04:00:00	MSFT	Stock	218.5	218.5	217.76	218.15	14573.0
2021-01-05 04:30:00	MSFT	Stock	217.89	218.01	217.77	218.0	2811.0
2021-01-05 05:00:00	MSFT	Stock	218.0	218.1	217.72	217.72	2587.0
2021-01-05 05:30:00	MSFT	Stock	217.9	217.9	217.9	217.9	2052.0
2021-01-05 06:30:00	MSFT	Stock	218.0	218.19	217.05	217.41	11850.0
2021-01-05 07:00:00	MSFT	Stock	217.67	217.67	217.35	217.4	6420.0
2021-01-05 07:30:00	MSFT	Stock	217.3	217.65	217.1	217.65	8491.0
2021-01-05 08:00:00	MSFT	Stock	217.304	217.7	216.5	216.65	18791.0
2021-01-05 08:30:00	MSFT	Stock	216.74	216.88	216.15	216.26	20971.0
2021-01-05 09:00:00	MSFT	Stock	216.26	217.62	216.26	217.61	20328.0
2021-01-05 09:30:00	MSFT	Stock	217.61	218.52	215.7	217.74	2726695.0
2021-01-05 10:00:00	MSFT	Stock	217.74	218.1	216.2	216.95	1267979.0
2021-01-05 10:30:00	MSFT	Stock	216.96	217.48	216.6	216.78	954098.0
2021-01-05 11:00:00	MSFT	Stock	216.78	217.17	215.98	216.675	1073386.0
2021-01-05 11:30:00	MSFT	Stock	216.68	217.74	216.62	217.384	962373.0
2021-01-05 12:00:00	MSFT	Stock	217.36	217.49	216.32	216.37	733622.0
2021-01-05 12:30:00	MSFT	Stock	216.38	216.63	216.09	216.445	656068.0
2021-01-05 13:00:00	MSFT	Stock	216.45	216.49	216.1	216.15	495622.0

> showing 50 of 110,936 rows — these rows as CSV

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