PREVIEW / stock_30min / 2019-04-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-10.parquet
  size:    1.7 MB
  rows:    83,774
  symbols: 2,629

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-04-10 04:00:00	AAPL	Stock	49.4475	49.45	49.295	49.32	62416.0
2019-04-10 04:30:00	AAPL	Stock	49.3375	49.4575	49.3375	49.435	27840.0
2019-04-10 05:00:00	AAPL	Stock	49.3775	49.425	49.375	49.425	25404.0
2019-04-10 05:30:00	AAPL	Stock	49.425	49.475	49.425	49.47	32900.0
2019-04-10 06:00:00	AAPL	Stock	49.475	49.5475	49.47	49.485	77868.0
2019-04-10 06:30:00	AAPL	Stock	49.475	49.475	49.35	49.45	66772.0
2019-04-10 07:00:00	AAPL	Stock	49.4675	49.72	49.38	49.655	338752.0
2019-04-10 07:30:00	AAPL	Stock	49.685	49.81	49.675	49.6925	336376.0
2019-04-10 08:00:00	AAPL	Stock	49.55	49.75	49.4	49.7125	367308.0
2019-04-10 08:30:00	AAPL	Stock	49.7225	49.8625	49.62	49.7125	226248.0
2019-04-10 09:00:00	AAPL	Stock	49.725	49.725	49.6	49.685	197936.0
2019-04-10 09:30:00	AAPL	Stock	49.67	49.9925	49.595	49.6608	16060704.0
2019-04-10 10:00:00	AAPL	Stock	49.6588	49.7475	49.545	49.7125	8127064.0
2019-04-10 10:30:00	AAPL	Stock	49.715	49.9275	49.675	49.8502	6211352.0
2019-04-10 11:00:00	AAPL	Stock	49.85	49.9225	49.8022	49.8745	4886552.0
2019-04-10 11:30:00	AAPL	Stock	49.875	49.9125	49.8125	49.835	3489648.0
2019-04-10 12:00:00	AAPL	Stock	49.8375	49.8748	49.785	49.8713	2172804.0
2019-04-10 12:30:00	AAPL	Stock	49.8725	49.9325	49.855	49.8935	2698752.0
2019-04-10 13:00:00	AAPL	Stock	49.895	49.9125	49.8175	49.895	1877372.0
2019-04-10 13:30:00	AAPL	Stock	49.895	50.0	49.8775	49.9968	2901200.0
2019-04-10 14:00:00	AAPL	Stock	49.9952	50.0	49.8315	49.8875	4088476.0
2019-04-10 14:30:00	AAPL	Stock	49.8875	49.9425	49.8425	49.9208	3154780.0
2019-04-10 15:00:00	AAPL	Stock	49.9225	50.1125	49.8975	50.0875	6574712.0
2019-04-10 15:30:00	AAPL	Stock	50.0925	50.185	50.0475	50.165	8912840.0
2019-04-10 16:00:00	AAPL	Stock	50.155	50.2	50.15	50.155	3950248.0
2019-04-10 16:30:00	AAPL	Stock	50.18	50.1875	50.15	50.1575	62812.0
2019-04-10 17:00:00	AAPL	Stock	50.1625	50.165	50.125	50.1375	35896.0
2019-04-10 17:30:00	AAPL	Stock	50.1375	50.155	50.135	50.155	18856.0
2019-04-10 18:00:00	AAPL	Stock	50.16	50.1625	50.15	50.1625	19584.0
2019-04-10 18:30:00	AAPL	Stock	50.185	50.185	50.14	50.1725	29784.0
2019-04-10 19:00:00	AAPL	Stock	50.155	50.17	50.15	50.155	23736.0
2019-04-10 19:30:00	AAPL	Stock	50.155	50.2375	50.15	50.225	40352.0
2019-04-10 04:00:00	MSFT	Stock	119.3	119.4	119.3	119.4	286.0
2019-04-10 04:30:00	MSFT	Stock	119.65	119.65	119.65	119.65	150.0
2019-04-10 05:00:00	MSFT	Stock	119.63	119.63	119.63	119.63	100.0
2019-04-10 06:00:00	MSFT	Stock	119.63	119.63	119.63	119.63	414.0
2019-04-10 06:30:00	MSFT	Stock	119.7	119.7	119.7	119.7	234.0
2019-04-10 07:00:00	MSFT	Stock	119.68	119.83	119.65	119.65	637.0
2019-04-10 07:30:00	MSFT	Stock	119.54	119.56	119.45	119.55	2293.0
2019-04-10 08:00:00	MSFT	Stock	119.54	119.9	119.5	119.58	19218.0
2019-04-10 08:30:00	MSFT	Stock	119.62	119.68	119.3	119.51	6634.0
2019-04-10 09:00:00	MSFT	Stock	119.5	119.76	119.38	119.69	17137.0
2019-04-10 09:30:00	MSFT	Stock	119.76	120.095	119.54	119.77	2323796.0
2019-04-10 10:00:00	MSFT	Stock	119.76	120.0	119.66	119.895	949014.0
2019-04-10 10:30:00	MSFT	Stock	119.9	120.21	119.88	120.03	1107963.0
2019-04-10 11:00:00	MSFT	Stock	120.025	120.23	119.99	120.155	690669.0
2019-04-10 11:30:00	MSFT	Stock	120.15	120.35	120.12	120.21	702177.0
2019-04-10 12:00:00	MSFT	Stock	120.21	120.25	120.074	120.161	422632.0
2019-04-10 12:30:00	MSFT	Stock	120.17	120.27	119.99	120.03	496545.0
2019-04-10 13:00:00	MSFT	Stock	120.024	120.06	119.9	119.9	368704.0

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

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