PREVIEW / stock_30min / 2019-10-03

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-03.parquet
  size:    1.7 MB
  rows:    82,021
  symbols: 2,517

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
2019-10-03 04:00:00	AAPL	Stock	54.825	54.95	54.775	54.95	13700.0
2019-10-03 05:00:00	AAPL	Stock	54.805	54.805	54.805	54.805	692.0
2019-10-03 05:30:00	AAPL	Stock	54.805	54.825	54.805	54.825	4832.0
2019-10-03 06:00:00	AAPL	Stock	54.8125	54.8125	54.8125	54.8125	18336.0
2019-10-03 06:30:00	AAPL	Stock	54.815	54.815	54.75	54.75	2212.0
2019-10-03 07:00:00	AAPL	Stock	54.795	54.795	54.6325	54.7125	51744.0
2019-10-03 07:30:00	AAPL	Stock	54.7125	54.7125	54.525	54.5525	115912.0
2019-10-03 08:00:00	AAPL	Stock	54.7	54.8125	54.525	54.54	127840.0
2019-10-03 08:30:00	AAPL	Stock	54.54	54.65	54.54	54.56	143516.0
2019-10-03 09:00:00	AAPL	Stock	54.585	54.705	54.5275	54.6325	145996.0
2019-10-03 09:30:00	AAPL	Stock	54.6325	54.835	54.415	54.5725	12313064.0
2019-10-03 10:00:00	AAPL	Stock	54.5725	54.58	53.783	54.215	18386960.0
2019-10-03 10:30:00	AAPL	Stock	54.2	54.4025	54.0275	54.365	7342620.0
2019-10-03 11:00:00	AAPL	Stock	54.3625	54.92	54.3	54.78	9693172.0
2019-10-03 11:30:00	AAPL	Stock	54.7825	54.8225	54.6525	54.7075	5023604.0
2019-10-03 12:00:00	AAPL	Stock	54.7062	55.035	54.7062	54.998	5899060.0
2019-10-03 12:30:00	AAPL	Stock	54.9925	55.2075	54.9575	55.1475	5609372.0
2019-10-03 13:00:00	AAPL	Stock	55.1525	55.18	55.075	55.135	3210428.0
2019-10-03 13:30:00	AAPL	Stock	55.1375	55.24	55.0062	55.1628	3951356.0
2019-10-03 14:00:00	AAPL	Stock	55.1675	55.17	55.03	55.12	3212880.0
2019-10-03 14:30:00	AAPL	Stock	55.1202	55.1325	54.965	55.005	2725724.0
2019-10-03 15:00:00	AAPL	Stock	55.005	55.0465	54.9225	55.0195	2485052.0
2019-10-03 15:30:00	AAPL	Stock	55.02	55.2375	54.94	55.2025	6400172.0
2019-10-03 16:00:00	AAPL	Stock	55.205	55.245	55.1875	55.2	8034088.0
2019-10-03 16:30:00	AAPL	Stock	55.19	55.2875	55.17	55.2	99088.0
2019-10-03 17:00:00	AAPL	Stock	55.195	55.2	55.1625	55.1875	31692.0
2019-10-03 17:30:00	AAPL	Stock	55.2	55.2	55.1225	55.1575	36656.0
2019-10-03 18:00:00	AAPL	Stock	55.145	55.15	55.0775	55.1375	35252.0
2019-10-03 18:30:00	AAPL	Stock	55.1375	55.1375	55.1	55.1175	6000.0
2019-10-03 19:00:00	AAPL	Stock	55.1125	55.1125	55.075	55.09	30304.0
2019-10-03 19:30:00	AAPL	Stock	55.0925	55.1375	55.09	55.125	39388.0
2019-10-03 04:00:00	MSFT	Stock	135.44	135.44	134.95	135.0	900.0
2019-10-03 04:30:00	MSFT	Stock	134.91	134.91	134.9	134.9	493.0
2019-10-03 06:00:00	MSFT	Stock	135.1	135.1	135.1	135.1	900.0
2019-10-03 06:30:00	MSFT	Stock	134.83	134.83	134.8	134.8	900.0
2019-10-03 07:00:00	MSFT	Stock	134.77	134.77	134.7	134.71	3637.0
2019-10-03 07:30:00	MSFT	Stock	134.75	134.78	134.09	134.21	10063.0
2019-10-03 08:00:00	MSFT	Stock	134.75	134.9	134.03	134.5	19637.0
2019-10-03 08:30:00	MSFT	Stock	134.55	134.63	134.39	134.42	10196.0
2019-10-03 09:00:00	MSFT	Stock	134.42	134.96	134.4	134.96	15285.0
2019-10-03 09:30:00	MSFT	Stock	134.95	135.3	134.31	135.06	1735633.0
2019-10-03 10:00:00	MSFT	Stock	135.03	135.03	133.22	134.67	3050839.0
2019-10-03 10:30:00	MSFT	Stock	134.68	135.18	134.46	135.05	1598088.0
2019-10-03 11:00:00	MSFT	Stock	135.06	136.505	134.9	136.08	2425837.0
2019-10-03 11:30:00	MSFT	Stock	136.08	136.155	135.55	135.76	851376.0
2019-10-03 12:00:00	MSFT	Stock	135.76	136.32	135.73	136.15	978450.0
2019-10-03 12:30:00	MSFT	Stock	136.15	136.34	136.05	136.21	1134862.0
2019-10-03 13:00:00	MSFT	Stock	136.215	136.38	136.188	136.245	796001.0
2019-10-03 13:30:00	MSFT	Stock	136.26	136.75	136.22	136.53	976660.0
2019-10-03 14:00:00	MSFT	Stock	136.54	136.55	136.18	136.537	689045.0

> showing 50 of 82,021 rows — these rows as CSV

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