PREVIEW / stock_30min / 2021-01-19

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-01-19.parquet
  size:    2.3 MB
  rows:    118,434
  symbols: 2,715

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-19 04:00:00	AAPL	Stock	128.55	129.0	128.55	128.73	49832.0
2021-01-19 04:30:00	AAPL	Stock	128.63	128.9	128.51	128.9	10013.0
2021-01-19 05:00:00	AAPL	Stock	128.87	128.9	128.8	128.83	6922.0
2021-01-19 05:30:00	AAPL	Stock	128.84	128.99	128.84	128.93	9508.0
2021-01-19 06:00:00	AAPL	Stock	128.95	129.0	128.72	128.9	7812.0
2021-01-19 06:30:00	AAPL	Stock	128.8	128.97	128.7	128.89	17160.0
2021-01-19 07:00:00	AAPL	Stock	128.91	128.93	128.3	128.42	248913.0
2021-01-19 07:30:00	AAPL	Stock	128.43	128.43	128.1	128.35	84644.0
2021-01-19 08:00:00	AAPL	Stock	128.36	128.9	128.12	128.25	204090.0
2021-01-19 08:30:00	AAPL	Stock	128.25	128.35	127.93	127.97	159339.0
2021-01-19 09:00:00	AAPL	Stock	127.95	128.1	127.65	127.75	528268.0
2021-01-19 09:30:00	AAPL	Stock	127.72	128.71	127.32	127.46	12234788.0
2021-01-19 10:00:00	AAPL	Stock	127.46	127.5	126.938	127.169	7535327.0
2021-01-19 10:30:00	AAPL	Stock	127.18	127.42	126.95	127.107	4834512.0
2021-01-19 11:00:00	AAPL	Stock	127.1	127.56	127.05	127.18	5215144.0
2021-01-19 11:30:00	AAPL	Stock	127.18	127.79	127.12	127.71	3273804.0
2021-01-19 12:00:00	AAPL	Stock	127.701	127.78	127.36	127.37	3173147.0
2021-01-19 12:30:00	AAPL	Stock	127.375	128.081	127.28	128.03	4116482.0
2021-01-19 13:00:00	AAPL	Stock	128.039	128.26	127.94	128.11	3226766.0
2021-01-19 13:30:00	AAPL	Stock	128.12	128.18	127.89	127.95	2727251.0
2021-01-19 14:00:00	AAPL	Stock	127.945	128.19	127.83	128.05	2711514.0
2021-01-19 14:30:00	AAPL	Stock	128.05	128.125	127.68	127.89	2939553.0
2021-01-19 15:00:00	AAPL	Stock	127.89	128.13	127.77	127.87	2984454.0
2021-01-19 15:30:00	AAPL	Stock	127.88	128.11	127.64	127.82	6259371.0
2021-01-19 16:00:00	AAPL	Stock	127.83	128.0	127.251	127.94	11166611.0
2021-01-19 16:30:00	AAPL	Stock	127.91	128.14	127.83	128.12	158382.0
2021-01-19 17:00:00	AAPL	Stock	128.11	128.14	128.08	128.1	49745.0
2021-01-19 17:30:00	AAPL	Stock	128.1	128.11	128.01	128.09	42415.0
2021-01-19 18:00:00	AAPL	Stock	128.08	128.24	128.08	128.17	66650.0
2021-01-19 18:30:00	AAPL	Stock	128.18	128.2	128.06	128.15	38965.0
2021-01-19 19:00:00	AAPL	Stock	128.16	128.16	128.07	128.07	51830.0
2021-01-19 19:30:00	AAPL	Stock	128.1	128.18	128.05	128.18	68035.0
2021-01-19 04:00:00	MSFT	Stock	214.0	214.65	214.0	214.25	5736.0
2021-01-19 04:30:00	MSFT	Stock	214.34	214.49	214.3	214.48	826.0
2021-01-19 05:00:00	MSFT	Stock	214.47	214.47	214.42	214.42	466.0
2021-01-19 05:30:00	MSFT	Stock	214.36	214.41	214.36	214.41	400.0
2021-01-19 06:00:00	MSFT	Stock	214.38	214.38	214.02	214.05	600.0
2021-01-19 06:30:00	MSFT	Stock	214.04	214.04	214.02	214.02	1420.0
2021-01-19 07:00:00	MSFT	Stock	214.02	214.05	213.71	213.83	23333.0
2021-01-19 07:30:00	MSFT	Stock	213.88	213.92	213.55	213.78	4531.0
2021-01-19 08:00:00	MSFT	Stock	214.05	214.05	212.12	213.6	22297.0
2021-01-19 08:30:00	MSFT	Stock	213.6	213.77	213.5	213.5	30731.0
2021-01-19 09:00:00	MSFT	Stock	213.5	214.6	213.5	213.81	109162.0
2021-01-19 09:30:00	MSFT	Stock	213.75	214.92	213.053	214.17	2701574.0
2021-01-19 10:00:00	MSFT	Stock	214.17	214.605	213.53	213.615	1211793.0
2021-01-19 10:30:00	MSFT	Stock	213.615	214.0	213.12	213.87	975925.0
2021-01-19 11:00:00	MSFT	Stock	213.88	213.9	212.63	213.11	1121134.0
2021-01-19 11:30:00	MSFT	Stock	213.14	213.9	212.9	213.615	773692.0
2021-01-19 12:00:00	MSFT	Stock	213.618	214.9	213.59	214.6	1115568.0
2021-01-19 12:30:00	MSFT	Stock	214.618	215.09	214.605	215.0	777796.0

> showing 50 of 118,434 rows — these rows as CSV

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