PREVIEW / stock_30min / 2019-01-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-09.parquet
  size:    1.7 MB
  rows:    84,787
  symbols: 2,697

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-01-09 04:00:00	AAPL	Stock	37.8	38.11	37.8	38.0875	21012.0
2019-01-09 04:30:00	AAPL	Stock	38.1	38.1	38.025	38.0375	26648.0
2019-01-09 05:00:00	AAPL	Stock	38.075	38.25	38.0375	38.2	114988.0
2019-01-09 05:30:00	AAPL	Stock	38.1825	38.3	38.15	38.3	27908.0
2019-01-09 06:00:00	AAPL	Stock	38.2725	38.3	38.15	38.22	99220.0
2019-01-09 06:30:00	AAPL	Stock	38.1775	38.2	38.1525	38.175	46428.0
2019-01-09 07:00:00	AAPL	Stock	38.185	38.2225	37.905	37.9625	324772.0
2019-01-09 07:30:00	AAPL	Stock	37.955	38.025	37.8325	37.92	309028.0
2019-01-09 08:00:00	AAPL	Stock	38.0	38.19	37.82	37.855	624300.0
2019-01-09 08:30:00	AAPL	Stock	37.8625	37.905	37.6075	37.7075	692952.0
2019-01-09 09:00:00	AAPL	Stock	37.7	37.8	37.5525	37.7425	919740.0
2019-01-09 09:30:00	AAPL	Stock	37.79	38.01	37.4075	37.9548	23714108.0
2019-01-09 10:00:00	AAPL	Stock	37.9575	38.2025	37.85	38.1672	16528036.0
2019-01-09 10:30:00	AAPL	Stock	38.1625	38.18	37.9925	38.1255	11180964.0
2019-01-09 11:00:00	AAPL	Stock	38.1225	38.325	38.0825	38.2075	16559056.0
2019-01-09 11:30:00	AAPL	Stock	38.21	38.51	38.1962	38.4525	13128200.0
2019-01-09 12:00:00	AAPL	Stock	38.4525	38.569	38.4175	38.4993	9471980.0
2019-01-09 12:30:00	AAPL	Stock	38.501	38.5925	38.4225	38.4625	8871804.0
2019-01-09 13:00:00	AAPL	Stock	38.4625	38.5075	38.3852	38.4475	6339440.0
2019-01-09 13:30:00	AAPL	Stock	38.4475	38.5525	38.3825	38.4762	6191604.0
2019-01-09 14:00:00	AAPL	Stock	38.475	38.6325	38.2725	38.285	10401028.0
2019-01-09 14:30:00	AAPL	Stock	38.2875	38.5	38.2325	38.4425	7010160.0
2019-01-09 15:00:00	AAPL	Stock	38.4425	38.6243	38.4325	38.5325	6985288.0
2019-01-09 15:30:00	AAPL	Stock	38.5375	38.5375	38.2775	38.3275	13236588.0
2019-01-09 16:00:00	AAPL	Stock	38.3275	38.3275	38.26	38.3	8309764.0
2019-01-09 16:30:00	AAPL	Stock	38.3	38.4525	38.0852	38.3275	579000.0
2019-01-09 17:00:00	AAPL	Stock	38.25	38.25	38.2	38.2225	39564.0
2019-01-09 17:30:00	AAPL	Stock	38.2075	38.2425	38.2	38.225	17628.0
2019-01-09 18:00:00	AAPL	Stock	38.2175	38.24	38.2	38.2125	25092.0
2019-01-09 18:30:00	AAPL	Stock	38.225	38.2375	38.1875	38.1925	24264.0
2019-01-09 19:00:00	AAPL	Stock	38.1875	38.225	38.1525	38.1525	31936.0
2019-01-09 19:30:00	AAPL	Stock	38.1375	38.1975	38.1375	38.155	50308.0
2019-01-09 04:30:00	MSFT	Stock	103.74	103.74	103.43	103.51	2710.0
2019-01-09 05:00:00	MSFT	Stock	103.51	103.52	103.01	103.01	9420.0
2019-01-09 05:30:00	MSFT	Stock	103.16	103.23	103.03	103.15	2837.0
2019-01-09 06:00:00	MSFT	Stock	103.24	103.24	103.06	103.06	2884.0
2019-01-09 06:30:00	MSFT	Stock	103.0	103.2	102.91	103.2	3766.0
2019-01-09 07:00:00	MSFT	Stock	103.24	103.25	102.61	102.98	10716.0
2019-01-09 07:30:00	MSFT	Stock	102.98	103.15	102.98	103.15	5006.0
2019-01-09 08:00:00	MSFT	Stock	103.2	103.5	102.8	103.4	35322.0
2019-01-09 08:30:00	MSFT	Stock	103.35	103.47	103.31	103.4	13599.0
2019-01-09 09:00:00	MSFT	Stock	103.4	103.9	103.21	103.69	38492.0
2019-01-09 09:30:00	MSFT	Stock	103.86	104.27	103.54	104.15	4042852.0
2019-01-09 10:00:00	MSFT	Stock	104.145	104.29	103.63	104.08	2404867.0
2019-01-09 10:30:00	MSFT	Stock	104.08	104.14	103.244	103.79	2157716.0
2019-01-09 11:00:00	MSFT	Stock	103.79	104.455	103.68	104.355	2074161.0
2019-01-09 11:30:00	MSFT	Stock	104.36	104.62	103.99	104.42	1737664.0
2019-01-09 12:00:00	MSFT	Stock	104.41	104.475	104.135	104.37	1394324.0
2019-01-09 12:30:00	MSFT	Stock	104.37	104.79	104.34	104.67	1500644.0
2019-01-09 13:00:00	MSFT	Stock	104.68	104.763	104.33	104.664	1167367.0

> showing 50 of 84,787 rows — these rows as CSV

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