PREVIEW / stock_30min / 2021-01-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-14.parquet
  size:    2.3 MB
  rows:    115,114
  symbols: 2,709

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-14 04:00:00	AAPL	Stock	131.2	131.2	130.52	130.61	7899.0
2021-01-14 04:30:00	AAPL	Stock	130.69	130.69	130.25	130.3	12295.0
2021-01-14 05:00:00	AAPL	Stock	130.27	130.4	130.01	130.16	11008.0
2021-01-14 05:30:00	AAPL	Stock	130.2	130.36	130.0	130.3	4443.0
2021-01-14 06:00:00	AAPL	Stock	130.39	130.65	130.08	130.1	10071.0
2021-01-14 06:30:00	AAPL	Stock	130.4	130.62	130.2	130.6	8791.0
2021-01-14 07:00:00	AAPL	Stock	130.64	130.86	130.56	130.79	148171.0
2021-01-14 07:30:00	AAPL	Stock	130.79	130.96	130.6	130.85	80956.0
2021-01-14 08:00:00	AAPL	Stock	130.75	130.95	130.6	130.8	158891.0
2021-01-14 08:30:00	AAPL	Stock	130.77	131.16	130.67	130.97	145686.0
2021-01-14 09:00:00	AAPL	Stock	130.98	131.07	130.64	130.8	218626.0
2021-01-14 09:30:00	AAPL	Stock	130.8	131.0	129.664	130.01	11630583.0
2021-01-14 10:00:00	AAPL	Stock	130.0	130.36	129.6	130.255	6989318.0
2021-01-14 10:30:00	AAPL	Stock	130.255	130.87	130.04	130.623	6756753.0
2021-01-14 11:00:00	AAPL	Stock	130.63	130.7	130.15	130.395	4108649.0
2021-01-14 11:30:00	AAPL	Stock	130.398	130.509	129.86	130.0	3769877.0
2021-01-14 12:00:00	AAPL	Stock	129.995	130.08	129.76	130.02	3180112.0
2021-01-14 12:30:00	AAPL	Stock	130.02	130.2	129.54	130.13	3945532.0
2021-01-14 13:00:00	AAPL	Stock	130.132	130.133	129.72	129.773	2765345.0
2021-01-14 13:30:00	AAPL	Stock	129.77	129.91	129.5	129.53	2988741.0
2021-01-14 14:00:00	AAPL	Stock	129.52	129.74	129.35	129.472	3855019.0
2021-01-14 14:30:00	AAPL	Stock	129.471	129.63	129.29	129.625	3116487.0
2021-01-14 15:00:00	AAPL	Stock	129.623	129.73	128.9	129.03	5535852.0
2021-01-14 15:30:00	AAPL	Stock	129.04	129.44	128.76	128.92	8664681.0
2021-01-14 16:00:00	AAPL	Stock	128.91	129.18	128.91	129.16	9016080.0
2021-01-14 16:30:00	AAPL	Stock	129.16	129.18	128.91	128.98	122780.0
2021-01-14 17:00:00	AAPL	Stock	128.98	129.3	128.96	129.25	79830.0
2021-01-14 17:30:00	AAPL	Stock	129.3	129.35	129.25	129.34	38738.0
2021-01-14 18:00:00	AAPL	Stock	129.3	129.34	129.25	129.32	39382.0
2021-01-14 18:30:00	AAPL	Stock	129.29	129.34	129.25	129.29	33832.0
2021-01-14 19:00:00	AAPL	Stock	129.27	129.28	129.06	129.28	51833.0
2021-01-14 19:30:00	AAPL	Stock	129.3	129.35	129.0	129.2	74580.0
2021-01-14 04:00:00	MSFT	Stock	216.34	216.47	215.85	216.0	2814.0
2021-01-14 04:30:00	MSFT	Stock	216.0	216.15	215.15	215.15	4193.0
2021-01-14 05:00:00	MSFT	Stock	215.28	215.42	214.54	214.54	2012.0
2021-01-14 05:30:00	MSFT	Stock	214.53	214.71	214.53	214.71	400.0
2021-01-14 06:00:00	MSFT	Stock	215.71	216.01	215.4	215.4	3930.0
2021-01-14 06:30:00	MSFT	Stock	215.5	215.52	215.05	215.05	4228.0
2021-01-14 07:00:00	MSFT	Stock	215.88	216.03	215.41	215.66	14025.0
2021-01-14 07:30:00	MSFT	Stock	215.66	215.81	215.41	215.81	6103.0
2021-01-14 08:00:00	MSFT	Stock	215.7	215.97	215.39	215.5	15010.0
2021-01-14 08:30:00	MSFT	Stock	215.65	216.2	215.5	216.02	12068.0
2021-01-14 09:00:00	MSFT	Stock	216.01	216.31	215.75	216.07	44807.0
2021-01-14 09:30:00	MSFT	Stock	216.07	217.46	215.51	215.92	2268645.0
2021-01-14 10:00:00	MSFT	Stock	215.935	216.3	215.56	215.937	1316797.0
2021-01-14 10:30:00	MSFT	Stock	215.95	216.415	215.676	215.898	1024638.0
2021-01-14 11:00:00	MSFT	Stock	215.9	215.96	214.82	215.05	1152566.0
2021-01-14 11:30:00	MSFT	Stock	215.04	215.23	214.42	214.631	1060941.0
2021-01-14 12:00:00	MSFT	Stock	214.64	214.696	214.21	214.516	757416.0
2021-01-14 12:30:00	MSFT	Stock	214.51	214.81	213.94	214.79	1244112.0

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

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