PREVIEW / stock_30min / 2018-04-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-26.parquet
  size:    1.6 MB
  rows:    82,866
  symbols: 2,878

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-04-26 04:00:00	AAPL	Stock	41.125	41.15	41.125	41.15	3260.0
2018-04-26 04:30:00	AAPL	Stock	41.1175	41.1175	41.0675	41.105	8800.0
2018-04-26 05:00:00	AAPL	Stock	41.0375	41.125	41.0375	41.125	3920.0
2018-04-26 06:00:00	AAPL	Stock	41.1775	41.2225	41.1625	41.1625	8008.0
2018-04-26 06:30:00	AAPL	Stock	41.1125	41.1125	41.1	41.1	35096.0
2018-04-26 07:00:00	AAPL	Stock	41.195	41.195	41.025	41.0375	65652.0
2018-04-26 07:30:00	AAPL	Stock	41.015	41.015	40.9625	40.9625	52572.0
2018-04-26 08:00:00	AAPL	Stock	41.0	41.1625	40.955	41.01	174992.0
2018-04-26 08:30:00	AAPL	Stock	41.005	41.1	40.9875	41.075	261752.0
2018-04-26 09:00:00	AAPL	Stock	41.075	41.0975	41.0275	41.0325	125204.0
2018-04-26 09:30:00	AAPL	Stock	41.03	41.265	40.925	41.2225	12475292.0
2018-04-26 10:00:00	AAPL	Stock	41.2212	41.3425	41.1325	41.269	8585680.0
2018-04-26 10:30:00	AAPL	Stock	41.27	41.3975	41.2325	41.395	5207324.0
2018-04-26 11:00:00	AAPL	Stock	41.3962	41.4325	41.312	41.3475	4724984.0
2018-04-26 11:30:00	AAPL	Stock	41.3475	41.365	41.0875	41.14	5951892.0
2018-04-26 12:00:00	AAPL	Stock	41.14	41.16	40.9125	41.0712	8766244.0
2018-04-26 12:30:00	AAPL	Stock	41.07	41.1025	40.979	41.022	3528996.0
2018-04-26 13:00:00	AAPL	Stock	41.0225	41.12	41.0125	41.0392	3911468.0
2018-04-26 13:30:00	AAPL	Stock	41.04	41.085	40.985	41.0388	4098552.0
2018-04-26 14:00:00	AAPL	Stock	41.0388	41.041	40.8425	40.935	5847780.0
2018-04-26 14:30:00	AAPL	Stock	40.9375	41.075	40.9228	41.0475	6100588.0
2018-04-26 15:00:00	AAPL	Stock	41.05	41.0725	40.9538	40.98	6349236.0
2018-04-26 15:30:00	AAPL	Stock	40.9812	41.1025	40.9275	41.055	11515248.0
2018-04-26 16:00:00	AAPL	Stock	41.055	41.23	41.045	41.225	10554936.0
2018-04-26 16:30:00	AAPL	Stock	41.215	41.2475	41.055	41.2125	163884.0
2018-04-26 17:00:00	AAPL	Stock	41.225	41.295	41.055	41.25	356376.0
2018-04-26 17:30:00	AAPL	Stock	41.2625	41.2675	41.225	41.225	39988.0
2018-04-26 18:00:00	AAPL	Stock	41.225	41.2375	41.1875	41.2	58400.0
2018-04-26 18:30:00	AAPL	Stock	41.195	41.225	41.19	41.2	32004.0
2018-04-26 19:00:00	AAPL	Stock	41.2125	41.25	41.1925	41.1925	26740.0
2018-04-26 19:30:00	AAPL	Stock	41.225	41.225	41.2075	41.2075	14084.0
2018-04-26 04:00:00	MSFT	Stock	93.5	93.5	93.2	93.25	6600.0
2018-04-26 04:30:00	MSFT	Stock	93.47	93.47	93.3	93.3	1106.0
2018-04-26 05:00:00	MSFT	Stock	93.32	93.45	93.3	93.45	4729.0
2018-04-26 05:30:00	MSFT	Stock	93.48	93.66	93.48	93.64	1367.0
2018-04-26 06:00:00	MSFT	Stock	93.67	93.67	93.54	93.54	200.0
2018-04-26 06:30:00	MSFT	Stock	93.61	93.62	93.61	93.62	610.0
2018-04-26 07:00:00	MSFT	Stock	93.68	93.78	93.61	93.75	14121.0
2018-04-26 07:30:00	MSFT	Stock	93.71	93.75	93.55	93.65	19232.0
2018-04-26 08:00:00	MSFT	Stock	93.732	94.0	93.6	93.95	139088.0
2018-04-26 08:30:00	MSFT	Stock	93.95	94.03	93.83	94.0	35223.0
2018-04-26 09:00:00	MSFT	Stock	94.0	94.18	93.55	93.56	109000.0
2018-04-26 09:30:00	MSFT	Stock	93.54	93.99	93.1	93.955	3703999.0
2018-04-26 10:00:00	MSFT	Stock	93.96	94.56	93.867	94.247	2278341.0
2018-04-26 10:30:00	MSFT	Stock	94.244	94.41	93.91	94.36	1709027.0
2018-04-26 11:00:00	MSFT	Stock	94.36	94.57	94.015	94.22	1468816.0
2018-04-26 11:30:00	MSFT	Stock	94.225	94.36	94.0	94.34	1337194.0
2018-04-26 12:00:00	MSFT	Stock	94.33	94.74	94.317	94.61	1293543.0
2018-04-26 12:30:00	MSFT	Stock	94.62	94.7	94.47	94.534	1033438.0
2018-04-26 13:00:00	MSFT	Stock	94.54	94.8	94.54	94.75	1238577.0

> showing 50 of 82,866 rows — these rows as CSV

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