PREVIEW / stock_30min / 2018-03-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-23.parquet
  size:    1.7 MB
  rows:    83,442
  symbols: 2,873

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-23 04:00:00	AAPL	Stock	42.0275	42.1125	41.85	41.85	32428.0
2018-03-23 04:30:00	AAPL	Stock	41.845	41.845	41.75	41.8125	15428.0
2018-03-23 05:00:00	AAPL	Stock	41.8	41.8725	41.775	41.7925	10296.0
2018-03-23 05:30:00	AAPL	Stock	41.78	41.78	41.675	41.675	21944.0
2018-03-23 06:00:00	AAPL	Stock	41.6325	41.8075	41.6325	41.805	86608.0
2018-03-23 06:30:00	AAPL	Stock	41.85	41.9375	41.85	41.8775	34608.0
2018-03-23 07:00:00	AAPL	Stock	41.885	42.075	41.885	42.04	103232.0
2018-03-23 07:30:00	AAPL	Stock	42.0	42.195	41.9675	42.1675	153264.0
2018-03-23 08:00:00	AAPL	Stock	42.1775	42.3375	41.95	42.2525	552288.0
2018-03-23 08:30:00	AAPL	Stock	42.2525	42.3675	42.2125	42.235	369608.0
2018-03-23 09:00:00	AAPL	Stock	42.2475	42.3725	42.1075	42.1375	508300.0
2018-03-23 09:30:00	AAPL	Stock	42.135	42.3275	41.885	42.239	20012280.0
2018-03-23 10:00:00	AAPL	Stock	42.24	42.36	42.0575	42.2275	11707328.0
2018-03-23 10:30:00	AAPL	Stock	42.23	42.4175	42.1725	42.405	8631356.0
2018-03-23 11:00:00	AAPL	Stock	42.405	42.435	42.17	42.2	5831260.0
2018-03-23 11:30:00	AAPL	Stock	42.2	42.2362	41.8475	41.864	8011040.0
2018-03-23 12:00:00	AAPL	Stock	41.865	42.1475	41.8475	42.1175	5865656.0
2018-03-23 12:30:00	AAPL	Stock	42.12	42.13	41.9175	41.95	4440292.0
2018-03-23 13:00:00	AAPL	Stock	41.9475	42.255	41.9	42.19	4941828.0
2018-03-23 13:30:00	AAPL	Stock	42.1987	42.48	42.1125	42.43	6131360.0
2018-03-23 14:00:00	AAPL	Stock	42.4325	42.47	42.0675	42.135	5356552.0
2018-03-23 14:30:00	AAPL	Stock	42.1305	42.1575	41.7775	41.78	8317012.0
2018-03-23 15:00:00	AAPL	Stock	41.7825	41.92	41.62	41.765	12957652.0
2018-03-23 15:30:00	AAPL	Stock	41.765	41.7675	41.235	41.24	25944796.0
2018-03-23 16:00:00	AAPL	Stock	41.2675	41.3125	41.23	41.295	12840156.0
2018-03-23 16:30:00	AAPL	Stock	41.295	41.375	41.235	41.2475	167432.0
2018-03-23 17:00:00	AAPL	Stock	41.265	41.2825	41.235	41.26	115908.0
2018-03-23 17:30:00	AAPL	Stock	41.2525	41.2875	41.2525	41.2875	28716.0
2018-03-23 18:00:00	AAPL	Stock	41.2625	41.2875	41.255	41.275	27212.0
2018-03-23 18:30:00	AAPL	Stock	41.2775	41.2775	41.2575	41.2575	43376.0
2018-03-23 19:00:00	AAPL	Stock	41.275	41.28	41.26	41.26	24556.0
2018-03-23 19:30:00	AAPL	Stock	41.275	41.3125	41.275	41.2875	22360.0
2018-03-23 04:00:00	MSFT	Stock	89.1	89.1	88.89	88.9	8192.0
2018-03-23 04:30:00	MSFT	Stock	88.88	88.88	88.6	88.83	3056.0
2018-03-23 05:00:00	MSFT	Stock	88.95	88.95	88.51	88.51	1063.0
2018-03-23 05:30:00	MSFT	Stock	88.8	88.8	88.79	88.8	4100.0
2018-03-23 06:00:00	MSFT	Stock	88.78	88.8	88.6	88.8	4017.0
2018-03-23 06:30:00	MSFT	Stock	88.8	88.8	88.8	88.8	200.0
2018-03-23 07:00:00	MSFT	Stock	89.0	89.41	88.79	89.25	15057.0
2018-03-23 07:30:00	MSFT	Stock	89.25	89.4	89.13	89.3	12155.0
2018-03-23 08:00:00	MSFT	Stock	89.13	89.79	88.8	89.6	48885.0
2018-03-23 08:30:00	MSFT	Stock	89.5	89.76	89.25	89.33	26556.0
2018-03-23 09:00:00	MSFT	Stock	89.34	89.78	89.33	89.5	41066.0
2018-03-23 09:30:00	MSFT	Stock	89.5	90.46	89.161	90.1	3800322.0
2018-03-23 10:00:00	MSFT	Stock	90.1	90.29	89.47	89.81	2132324.0
2018-03-23 10:30:00	MSFT	Stock	89.815	90.35	89.72	90.321	2232021.0
2018-03-23 11:00:00	MSFT	Stock	90.32	90.39	89.965	89.975	1475277.0
2018-03-23 11:30:00	MSFT	Stock	89.97	89.99	88.93	88.99	2177705.0
2018-03-23 12:00:00	MSFT	Stock	88.99	89.565	88.97	89.5	1598064.0
2018-03-23 12:30:00	MSFT	Stock	89.51	89.532	89.1	89.22	1241691.0

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

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