PREVIEW / stock_30min / 2020-07-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-13.parquet
  size:    2.0 MB
  rows:    100,412
  symbols: 2,458

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
2020-07-13 04:00:00	AAPL	Stock	96.6	96.8	96.575	96.625	74860.0
2020-07-13 04:30:00	AAPL	Stock	96.6325	96.9225	96.6	96.875	54116.0
2020-07-13 05:00:00	AAPL	Stock	96.9625	97.025	96.7575	96.8	33020.0
2020-07-13 05:30:00	AAPL	Stock	96.85	97.0	96.85	97.0	10368.0
2020-07-13 06:00:00	AAPL	Stock	97.0	97.1175	96.9	97.1175	9292.0
2020-07-13 06:30:00	AAPL	Stock	97.125	97.1675	96.95	97.0	11760.0
2020-07-13 07:00:00	AAPL	Stock	97.0625	97.125	96.875	96.96	317364.0
2020-07-13 07:30:00	AAPL	Stock	96.985	97.0625	96.9725	97.015	191004.0
2020-07-13 08:00:00	AAPL	Stock	97.0062	97.105	96.85	96.97	385396.0
2020-07-13 08:30:00	AAPL	Stock	96.97	97.1875	96.97	97.1425	298684.0
2020-07-13 09:00:00	AAPL	Stock	97.1408	97.36	97.1348	97.32	535404.0
2020-07-13 09:30:00	AAPL	Stock	97.2775	98.6875	97.0875	98.435	19732520.0
2020-07-13 10:00:00	AAPL	Stock	98.44	99.655	98.4	99.64	15524780.0
2020-07-13 10:30:00	AAPL	Stock	99.6372	99.8675	99.23	99.295	10767568.0
2020-07-13 11:00:00	AAPL	Stock	99.2875	99.955	99.195	99.8988	10071664.0
2020-07-13 11:30:00	AAPL	Stock	99.9	99.905	99.2275	99.4162	7186792.0
2020-07-13 12:00:00	AAPL	Stock	99.4225	99.6225	99.24	99.4275	4978944.0
2020-07-13 12:30:00	AAPL	Stock	99.4425	99.56	98.755	98.8	6128932.0
2020-07-13 13:00:00	AAPL	Stock	98.8075	99.175	98.6825	99.0925	6325504.0
2020-07-13 13:30:00	AAPL	Stock	99.0975	99.1475	98.34	98.39	5560788.0
2020-07-13 14:00:00	AAPL	Stock	98.38	98.4675	97.225	97.3025	11137660.0
2020-07-13 14:30:00	AAPL	Stock	97.2925	97.855	96.6375	97.8125	11440552.0
2020-07-13 15:00:00	AAPL	Stock	97.805	97.8275	96.4025	96.485	11556412.0
2020-07-13 15:30:00	AAPL	Stock	96.4838	96.61	95.2575	95.4775	18341440.0
2020-07-13 16:00:00	AAPL	Stock	95.4775	95.785	95.24	95.6275	12801760.0
2020-07-13 16:30:00	AAPL	Stock	95.625	95.625	95.375	95.6	1312148.0
2020-07-13 17:00:00	AAPL	Stock	95.62	95.6275	95.375	95.375	65524.0
2020-07-13 17:30:00	AAPL	Stock	95.38	95.5	95.3775	95.455	47920.0
2020-07-13 18:00:00	AAPL	Stock	95.5	95.9375	95.5	95.9	93504.0
2020-07-13 18:30:00	AAPL	Stock	95.94	96.1425	95.8025	95.9	75332.0
2020-07-13 19:00:00	AAPL	Stock	95.875	96.1625	95.8025	96.1625	49804.0
2020-07-13 19:30:00	AAPL	Stock	96.1875	96.22	96.0875	96.125	75240.0
2020-07-13 04:00:00	MSFT	Stock	215.01	215.01	214.11	214.46	8747.0
2020-07-13 04:30:00	MSFT	Stock	214.46	214.8	214.28	214.79	5258.0
2020-07-13 05:00:00	MSFT	Stock	214.82	214.82	214.5	214.51	2277.0
2020-07-13 05:30:00	MSFT	Stock	214.51	214.87	214.51	214.56	4785.0
2020-07-13 06:00:00	MSFT	Stock	214.63	215.09	214.63	214.91	4543.0
2020-07-13 06:30:00	MSFT	Stock	214.9	215.15	214.51	215.04	10655.0
2020-07-13 07:00:00	MSFT	Stock	215.04	215.45	214.85	215.15	45790.0
2020-07-13 07:30:00	MSFT	Stock	215.2	215.22	215.0	215.14	16673.0
2020-07-13 08:00:00	MSFT	Stock	215.09	215.45	214.2	215.0	63001.0
2020-07-13 08:30:00	MSFT	Stock	214.89	215.2	214.85	215.14	30932.0
2020-07-13 09:00:00	MSFT	Stock	215.15	215.22	214.3	214.47	93194.0
2020-07-13 09:30:00	MSFT	Stock	214.47	215.18	214.2	214.44	3428803.0
2020-07-13 10:00:00	MSFT	Stock	214.44	214.85	213.97	214.5	1741022.0
2020-07-13 10:30:00	MSFT	Stock	214.48	214.6	213.71	214.5	1670549.0
2020-07-13 11:00:00	MSFT	Stock	214.51	215.52	214.34	215.37	1547073.0
2020-07-13 11:30:00	MSFT	Stock	215.378	215.623	214.75	215.04	1347736.0
2020-07-13 12:00:00	MSFT	Stock	215.07	215.8	215.013	215.44	1103870.0
2020-07-13 12:30:00	MSFT	Stock	215.44	215.51	213.8	214.121	1334037.0

> showing 50 of 100,412 rows — these rows as CSV

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