PREVIEW / stock_30min / 2020-01-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-15.parquet
  size:    1.8 MB
  rows:    86,984
  symbols: 2,474

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-15 04:00:00	AAPL	Stock	77.9725	77.9725	77.72	77.725	54948.0
2020-01-15 04:30:00	AAPL	Stock	77.825	77.995	77.825	77.89	6676.0
2020-01-15 05:00:00	AAPL	Stock	77.8775	77.995	77.8	77.9425	29524.0
2020-01-15 05:30:00	AAPL	Stock	77.97	77.9725	77.9125	77.9725	15436.0
2020-01-15 06:00:00	AAPL	Stock	77.9725	77.9725	77.97	77.97	2000.0
2020-01-15 06:30:00	AAPL	Stock	77.9175	77.9875	77.9175	77.9875	10644.0
2020-01-15 07:00:00	AAPL	Stock	77.975	78.195	77.875	78.025	158056.0
2020-01-15 07:30:00	AAPL	Stock	78.0275	78.325	78.0075	78.2775	133608.0
2020-01-15 08:00:00	AAPL	Stock	78.285	78.3475	77.9175	78.2552	439644.0
2020-01-15 08:30:00	AAPL	Stock	78.2685	78.2925	77.95	78.025	361392.0
2020-01-15 09:00:00	AAPL	Stock	78.0025	78.0375	77.9175	77.97	253624.0
2020-01-15 09:30:00	AAPL	Stock	77.96	78.8575	77.865	78.8375	18342904.0
2020-01-15 10:00:00	AAPL	Stock	78.8393	78.875	78.5025	78.563	9124360.0
2020-01-15 10:30:00	AAPL	Stock	78.56	78.6675	78.4525	78.625	5448964.0
2020-01-15 11:00:00	AAPL	Stock	78.623	78.6675	78.38	78.4042	5737120.0
2020-01-15 11:30:00	AAPL	Stock	78.3975	78.645	78.345	78.4875	4639456.0
2020-01-15 12:00:00	AAPL	Stock	78.4775	78.65	78.44	78.5875	3536316.0
2020-01-15 12:30:00	AAPL	Stock	78.5875	78.63	78.4225	78.4775	3735816.0
2020-01-15 13:00:00	AAPL	Stock	78.475	78.61	78.39	78.4878	4566216.0
2020-01-15 13:30:00	AAPL	Stock	78.4895	78.5518	78.04	78.165	5754688.0
2020-01-15 14:00:00	AAPL	Stock	78.1675	78.3678	78.125	78.33	4643372.0
2020-01-15 14:30:00	AAPL	Stock	78.3325	78.4575	78.225	78.24	3704508.0
2020-01-15 15:00:00	AAPL	Stock	78.245	78.2525	77.7275	77.8125	8185772.0
2020-01-15 15:30:00	AAPL	Stock	77.8188	77.885	77.3875	77.875	17361768.0
2020-01-15 16:00:00	AAPL	Stock	77.875	77.88	77.7875	77.8125	6459576.0
2020-01-15 16:30:00	AAPL	Stock	77.8425	77.8425	77.8125	77.8375	42204.0
2020-01-15 17:00:00	AAPL	Stock	77.8375	77.8925	77.835	77.875	356908.0
2020-01-15 17:30:00	AAPL	Stock	77.87	77.9025	77.8625	77.8625	59852.0
2020-01-15 18:00:00	AAPL	Stock	77.87	78.05	77.87	78.035	69520.0
2020-01-15 18:30:00	AAPL	Stock	78.0375	78.0625	78.0025	78.0175	69252.0
2020-01-15 19:00:00	AAPL	Stock	78.0725	78.0725	78.0	78.0325	45552.0
2020-01-15 19:30:00	AAPL	Stock	78.0225	78.0625	78.01	78.05	67252.0
2020-01-15 04:00:00	MSFT	Stock	162.35	162.5	162.33	162.37	1537.0
2020-01-15 04:30:00	MSFT	Stock	162.45	162.45	162.35	162.35	400.0
2020-01-15 05:30:00	MSFT	Stock	162.6	162.75	162.42	162.55	2100.0
2020-01-15 06:00:00	MSFT	Stock	162.6	162.6	162.57	162.6	1700.0
2020-01-15 06:30:00	MSFT	Stock	162.59	162.63	162.59	162.63	306.0
2020-01-15 07:00:00	MSFT	Stock	162.55	162.65	162.35	162.45	10289.0
2020-01-15 07:30:00	MSFT	Stock	162.54	162.65	162.53	162.65	1592.0
2020-01-15 08:00:00	MSFT	Stock	162.65	162.67	162.45	162.63	14449.0
2020-01-15 08:30:00	MSFT	Stock	162.54	162.7	162.087	162.087	24812.0
2020-01-15 09:00:00	MSFT	Stock	162.11	162.7	162.082	162.65	20647.0
2020-01-15 09:30:00	MSFT	Stock	162.6	163.4	162.57	163.232	2099373.0
2020-01-15 10:00:00	MSFT	Stock	163.28	163.57	163.13	163.49	1082305.0
2020-01-15 10:30:00	MSFT	Stock	163.485	163.925	163.36	163.805	1126156.0
2020-01-15 11:00:00	MSFT	Stock	163.805	163.82	163.32	163.37	863059.0
2020-01-15 11:30:00	MSFT	Stock	163.375	163.64	163.32	163.45	675650.0
2020-01-15 12:00:00	MSFT	Stock	163.46	163.85	163.42	163.73	776627.0
2020-01-15 12:30:00	MSFT	Stock	163.73	163.94	163.4	163.455	689811.0
2020-01-15 13:00:00	MSFT	Stock	163.45	163.61	163.32	163.53	623166.0

> showing 50 of 86,984 rows — these rows as CSV

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