PREVIEW / stock_30min / 2020-01-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-16.parquet
  size:    1.8 MB
  rows:    87,387
  symbols: 2,455

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-01-16 04:00:00	AAPL	Stock	78.2625	78.525	78.2625	78.35	12872.0
2020-01-16 04:30:00	AAPL	Stock	78.37	78.45	78.37	78.45	16312.0
2020-01-16 05:00:00	AAPL	Stock	78.4	78.425	78.395	78.42	15836.0
2020-01-16 05:30:00	AAPL	Stock	78.4	78.445	78.3775	78.425	8524.0
2020-01-16 06:00:00	AAPL	Stock	78.4275	78.4575	78.32	78.4325	11788.0
2020-01-16 06:30:00	AAPL	Stock	78.355	78.45	78.355	78.425	7360.0
2020-01-16 07:00:00	AAPL	Stock	78.4075	78.6225	78.4075	78.475	334280.0
2020-01-16 07:30:00	AAPL	Stock	78.4525	78.55	78.4	78.4025	147252.0
2020-01-16 08:00:00	AAPL	Stock	78.45	78.5925	78.375	78.415	247896.0
2020-01-16 08:30:00	AAPL	Stock	78.46	78.56	78.415	78.5125	224316.0
2020-01-16 09:00:00	AAPL	Stock	78.4875	78.4975	78.375	78.4025	252424.0
2020-01-16 09:30:00	AAPL	Stock	78.4025	78.8175	78.395	78.6422	16730372.0
2020-01-16 10:00:00	AAPL	Stock	78.6375	78.925	78.58	78.6667	9566488.0
2020-01-16 10:30:00	AAPL	Stock	78.6725	78.6825	78.175	78.2	8428036.0
2020-01-16 11:00:00	AAPL	Stock	78.215	78.455	78.0225	78.28	8601500.0
2020-01-16 11:30:00	AAPL	Stock	78.275	78.3925	78.1712	78.3275	3707956.0
2020-01-16 12:00:00	AAPL	Stock	78.3232	78.3675	78.1125	78.1648	2805856.0
2020-01-16 12:30:00	AAPL	Stock	78.1658	78.295	78.155	78.21	2295400.0
2020-01-16 13:00:00	AAPL	Stock	78.215	78.295	78.165	78.25	2043792.0
2020-01-16 13:30:00	AAPL	Stock	78.2475	78.47	78.2125	78.425	3277860.0
2020-01-16 14:00:00	AAPL	Stock	78.4225	78.525	78.38	78.4862	3232888.0
2020-01-16 14:30:00	AAPL	Stock	78.4865	78.581	78.45	78.465	3185120.0
2020-01-16 15:00:00	AAPL	Stock	78.47	78.6325	78.4	78.526	4267760.0
2020-01-16 15:30:00	AAPL	Stock	78.525	78.8425	78.525	78.8325	9557876.0
2020-01-16 16:00:00	AAPL	Stock	78.81	78.82	78.745	78.7475	7392676.0
2020-01-16 16:30:00	AAPL	Stock	78.745	78.81	78.7275	78.775	112240.0
2020-01-16 17:00:00	AAPL	Stock	78.7875	78.81	78.7525	78.765	2838556.0
2020-01-16 17:30:00	AAPL	Stock	78.7525	78.7875	78.7375	78.7875	32420.0
2020-01-16 18:00:00	AAPL	Stock	78.75	78.8725	78.75	78.8125	93708.0
2020-01-16 18:30:00	AAPL	Stock	78.8175	78.8625	78.8025	78.825	48004.0
2020-01-16 19:00:00	AAPL	Stock	78.8125	78.8475	78.8	78.8125	25740.0
2020-01-16 19:30:00	AAPL	Stock	78.845	78.8475	78.81	78.8225	51912.0
2020-01-16 04:00:00	MSFT	Stock	164.05	164.6	164.05	164.16	3458.0
2020-01-16 04:30:00	MSFT	Stock	164.3	164.3	164.19	164.21	300.0
2020-01-16 05:00:00	MSFT	Stock	164.19	164.34	164.11	164.34	3459.0
2020-01-16 05:30:00	MSFT	Stock	164.34	164.34	164.34	164.34	900.0
2020-01-16 06:00:00	MSFT	Stock	164.23	164.39	164.23	164.39	3338.0
2020-01-16 06:30:00	MSFT	Stock	164.22	164.39	164.2	164.39	3793.0
2020-01-16 07:00:00	MSFT	Stock	164.31	164.36	164.12	164.15	17380.0
2020-01-16 07:30:00	MSFT	Stock	164.15	164.27	164.13	164.13	12022.0
2020-01-16 08:00:00	MSFT	Stock	164.3	164.36	164.12	164.17	13310.0
2020-01-16 08:30:00	MSFT	Stock	164.2	164.38	164.1	164.38	18804.0
2020-01-16 09:00:00	MSFT	Stock	164.38	164.38	164.2	164.34	23539.0
2020-01-16 09:30:00	MSFT	Stock	164.35	164.76	164.03	164.69	2284546.0
2020-01-16 10:00:00	MSFT	Stock	164.68	165.025	164.54	164.865	1466221.0
2020-01-16 10:30:00	MSFT	Stock	164.865	165.15	164.82	164.84	1151977.0
2020-01-16 11:00:00	MSFT	Stock	164.85	165.1	164.62	164.69	972252.0
2020-01-16 11:30:00	MSFT	Stock	164.677	165.013	164.53	164.985	655166.0
2020-01-16 12:00:00	MSFT	Stock	164.97	165.12	164.94	164.999	504340.0
2020-01-16 12:30:00	MSFT	Stock	164.995	165.295	164.99	165.01	914797.0

> showing 50 of 87,387 rows — these rows as CSV

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