PREVIEW / stock_30min / 2018-03-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-27.parquet
  size:    1.7 MB
  rows:    83,592
  symbols: 2,877

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-03-27 04:00:00	AAPL	Stock	43.325	43.5125	43.325	43.475	20200.0
2018-03-27 04:30:00	AAPL	Stock	43.5	43.55	43.5	43.55	10584.0
2018-03-27 05:00:00	AAPL	Stock	43.55	43.5675	43.55	43.55	5500.0
2018-03-27 05:30:00	AAPL	Stock	43.5275	43.57	43.5175	43.57	8184.0
2018-03-27 06:00:00	AAPL	Stock	43.565	43.62	43.505	43.505	26320.0
2018-03-27 06:30:00	AAPL	Stock	43.51	43.525	43.49	43.49	11900.0
2018-03-27 07:00:00	AAPL	Stock	43.465	43.675	43.465	43.625	165976.0
2018-03-27 07:30:00	AAPL	Stock	43.6125	43.65	43.525	43.535	85340.0
2018-03-27 08:00:00	AAPL	Stock	43.627	43.68	43.4	43.4	264580.0
2018-03-27 08:30:00	AAPL	Stock	43.415	43.45	43.3475	43.3875	255808.0
2018-03-27 09:00:00	AAPL	Stock	43.38	43.4575	43.3475	43.4475	255836.0
2018-03-27 09:30:00	AAPL	Stock	43.4225	43.7875	43.405	43.66	21188408.0
2018-03-27 10:00:00	AAPL	Stock	43.66	43.6675	43.29	43.45	9390128.0
2018-03-27 10:30:00	AAPL	Stock	43.45	43.575	43.29	43.3725	6288880.0
2018-03-27 11:00:00	AAPL	Stock	43.3675	43.385	43.2225	43.355	5585880.0
2018-03-27 11:30:00	AAPL	Stock	43.3575	43.6525	43.35	43.5808	6696064.0
2018-03-27 12:00:00	AAPL	Stock	43.585	43.665	43.2825	43.3398	4849200.0
2018-03-27 12:30:00	AAPL	Stock	43.33	43.41	43.1525	43.3073	7361552.0
2018-03-27 13:00:00	AAPL	Stock	43.31	43.405	43.2175	43.2475	4221240.0
2018-03-27 13:30:00	AAPL	Stock	43.2507	43.285	42.8375	42.9388	8864696.0
2018-03-27 14:00:00	AAPL	Stock	42.94	42.9475	42.5875	42.6475	11226544.0
2018-03-27 14:30:00	AAPL	Stock	42.65	42.785	42.42	42.4735	9748104.0
2018-03-27 15:00:00	AAPL	Stock	42.4675	42.5075	42.1	42.101	13153016.0
2018-03-27 15:30:00	AAPL	Stock	42.1	42.135	41.73	42.0875	21979620.0
2018-03-27 16:00:00	AAPL	Stock	42.0875	42.885	42.085	42.1825	10167808.0
2018-03-27 16:30:00	AAPL	Stock	42.1825	42.185	42.085	42.12	55528.0
2018-03-27 17:00:00	AAPL	Stock	42.12	42.12	42.0025	42.0925	1013872.0
2018-03-27 17:30:00	AAPL	Stock	42.085	42.12	42.085	42.1125	4158092.0
2018-03-27 18:00:00	AAPL	Stock	42.11	42.1225	42.0625	42.1225	32884.0
2018-03-27 18:30:00	AAPL	Stock	42.16	42.16	42.0925	42.1375	21628.0
2018-03-27 19:00:00	AAPL	Stock	42.1425	42.1475	42.1	42.14	11032.0
2018-03-27 19:30:00	AAPL	Stock	42.1475	42.1875	42.125	42.1875	23364.0
2018-03-27 04:00:00	MSFT	Stock	94.31	94.85	94.31	94.61	6404.0
2018-03-27 04:30:00	MSFT	Stock	94.66	94.86	94.66	94.85	2701.0
2018-03-27 05:00:00	MSFT	Stock	94.85	94.86	94.84	94.85	3600.0
2018-03-27 05:30:00	MSFT	Stock	94.79	94.97	94.76	94.85	7882.0
2018-03-27 06:00:00	MSFT	Stock	94.85	94.89	94.77	94.77	1476.0
2018-03-27 06:30:00	MSFT	Stock	94.8	94.8	94.65	94.65	2250.0
2018-03-27 07:00:00	MSFT	Stock	94.7	94.95	94.55	94.9	19714.0
2018-03-27 07:30:00	MSFT	Stock	94.9	94.99	94.65	94.78	23376.0
2018-03-27 08:00:00	MSFT	Stock	94.9	94.97	94.67	94.73	64123.0
2018-03-27 08:30:00	MSFT	Stock	94.78	94.78	94.5	94.638	39196.0
2018-03-27 09:00:00	MSFT	Stock	94.6	94.95	94.5	94.93	85089.0
2018-03-27 09:30:00	MSFT	Stock	94.94	95.139	94.231	94.65	6306174.0
2018-03-27 10:00:00	MSFT	Stock	94.66	94.85	93.98	94.18	3497707.0
2018-03-27 10:30:00	MSFT	Stock	94.16	94.35	93.86	93.94	2156977.0
2018-03-27 11:00:00	MSFT	Stock	93.93	93.95	93.41	93.59	2061432.0
2018-03-27 11:30:00	MSFT	Stock	93.591	94.31	93.591	94.13	1679309.0
2018-03-27 12:00:00	MSFT	Stock	94.14	94.14	93.29	93.299	1501493.0
2018-03-27 12:30:00	MSFT	Stock	93.28	93.36	92.75	92.96	2120113.0

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

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