PREVIEW / stock_30min / 2018-05-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-22.parquet
  size:    1.7 MB
  rows:    83,337
  symbols: 2,856

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
2018-05-22 04:00:00	AAPL	Stock	46.98	46.98	46.98	46.98	1332.0
2018-05-22 06:00:00	AAPL	Stock	47.0275	47.0275	47.0275	47.0275	612.0
2018-05-22 06:30:00	AAPL	Stock	47.0725	47.075	47.025	47.075	7648.0
2018-05-22 07:00:00	AAPL	Stock	47.0325	47.125	47.0325	47.1	97164.0
2018-05-22 07:30:00	AAPL	Stock	47.0875	47.1	47.07	47.1	29316.0
2018-05-22 08:00:00	AAPL	Stock	47.1125	47.1375	47.0288	47.0875	87008.0
2018-05-22 08:30:00	AAPL	Stock	47.095	47.095	47.025	47.0625	40552.0
2018-05-22 09:00:00	AAPL	Stock	47.0525	47.125	47.05	47.095	54296.0
2018-05-22 09:30:00	AAPL	Stock	47.1225	47.22	46.9658	46.9875	8371336.0
2018-05-22 10:00:00	AAPL	Stock	46.9875	47.0465	46.8428	46.8775	5639368.0
2018-05-22 10:30:00	AAPL	Stock	46.88	46.9275	46.8325	46.8625	3582632.0
2018-05-22 11:00:00	AAPL	Stock	46.8625	46.9075	46.84	46.8462	2449244.0
2018-05-22 11:30:00	AAPL	Stock	46.8475	46.87	46.8125	46.8575	2155088.0
2018-05-22 12:00:00	AAPL	Stock	46.86	46.915	46.8	46.825	2178900.0
2018-05-22 12:30:00	AAPL	Stock	46.8275	46.87	46.7525	46.8425	2304492.0
2018-05-22 13:00:00	AAPL	Stock	46.8438	46.89	46.8162	46.8875	1375172.0
2018-05-22 13:30:00	AAPL	Stock	46.89	46.9075	46.82	46.87	1498484.0
2018-05-22 14:00:00	AAPL	Stock	46.8725	46.94	46.8462	46.9275	1934920.0
2018-05-22 14:30:00	AAPL	Stock	46.925	46.965	46.8525	46.8675	2058124.0
2018-05-22 15:00:00	AAPL	Stock	46.865	46.915	46.85	46.895	2182232.0
2018-05-22 15:30:00	AAPL	Stock	46.895	46.895	46.695	46.8275	7585212.0
2018-05-22 16:00:00	AAPL	Stock	46.8225	46.8525	46.79	46.825	9066860.0
2018-05-22 16:30:00	AAPL	Stock	46.8375	46.8475	46.79	46.825	107756.0
2018-05-22 17:00:00	AAPL	Stock	46.8225	46.83	46.79	46.83	56968.0
2018-05-22 17:30:00	AAPL	Stock	46.83	46.83	46.82	46.82	8232.0
2018-05-22 18:00:00	AAPL	Stock	46.83	46.83	46.805	46.805	9388.0
2018-05-22 18:30:00	AAPL	Stock	46.8125	46.8125	46.8025	46.8025	4284.0
2018-05-22 19:00:00	AAPL	Stock	46.8125	46.835	46.8125	46.835	4632.0
2018-05-22 19:30:00	AAPL	Stock	46.825	46.825	46.8125	46.8125	8268.0
2018-05-22 04:00:00	MSFT	Stock	97.6	98.0	97.6	98.0	440.0
2018-05-22 05:00:00	MSFT	Stock	98.1	98.1	98.1	98.1	100.0
2018-05-22 06:00:00	MSFT	Stock	98.12	98.12	98.0	98.0	535.0
2018-05-22 06:30:00	MSFT	Stock	98.0	98.01	98.0	98.0	1300.0
2018-05-22 07:00:00	MSFT	Stock	98.0	98.0	97.95	97.96	300.0
2018-05-22 07:30:00	MSFT	Stock	97.85	97.99	97.85	97.99	404.0
2018-05-22 08:00:00	MSFT	Stock	98.0	98.01	97.9	97.93	4587.0
2018-05-22 08:30:00	MSFT	Stock	97.86	97.9	97.8	97.8	2664.0
2018-05-22 09:00:00	MSFT	Stock	97.81	97.89	97.69	97.69	13473.0
2018-05-22 09:30:00	MSFT	Stock	97.68	98.17	97.6	97.885	2000982.0
2018-05-22 10:00:00	MSFT	Stock	97.88	97.91	97.235	97.365	1195963.0
2018-05-22 10:30:00	MSFT	Stock	97.37	97.64	97.2	97.5	791277.0
2018-05-22 11:00:00	MSFT	Stock	97.5	97.62	97.48	97.55	410421.0
2018-05-22 11:30:00	MSFT	Stock	97.555	97.58	97.38	97.51	602331.0
2018-05-22 12:00:00	MSFT	Stock	97.51	97.63	97.39	97.464	444876.0
2018-05-22 12:30:00	MSFT	Stock	97.465	97.6	97.32	97.55	447704.0
2018-05-22 13:00:00	MSFT	Stock	97.55	97.73	97.51	97.72	460906.0
2018-05-22 13:30:00	MSFT	Stock	97.72	97.735	97.57	97.665	435340.0
2018-05-22 14:00:00	MSFT	Stock	97.666	97.93	97.66	97.895	521359.0
2018-05-22 14:30:00	MSFT	Stock	97.895	97.995	97.71	97.724	542876.0
2018-05-22 15:00:00	MSFT	Stock	97.73	97.855	97.67	97.69	712633.0

> showing 50 of 83,337 rows — these rows as CSV

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