PREVIEW / stock_30min / 2018-04-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-24.parquet
  size:    1.6 MB
  rows:    82,144
  symbols: 2,855

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-24 04:00:00	AAPL	Stock	41.4975	41.4975	41.3725	41.4225	24696.0
2018-04-24 04:30:00	AAPL	Stock	41.45	41.5425	41.45	41.5425	11344.0
2018-04-24 05:00:00	AAPL	Stock	41.5425	41.5425	41.525	41.525	1908.0
2018-04-24 05:30:00	AAPL	Stock	41.525	41.525	41.525	41.525	400.0
2018-04-24 06:00:00	AAPL	Stock	41.55	41.56	41.5	41.56	20836.0
2018-04-24 06:30:00	AAPL	Stock	41.575	41.575	41.54	41.5625	3184.0
2018-04-24 07:00:00	AAPL	Stock	41.54	41.5725	41.4375	41.4375	80960.0
2018-04-24 07:30:00	AAPL	Stock	41.4375	41.5	41.425	41.4575	199320.0
2018-04-24 08:00:00	AAPL	Stock	41.5575	41.575	41.4375	41.445	168824.0
2018-04-24 08:30:00	AAPL	Stock	41.45	41.4625	41.385	41.4375	147188.0
2018-04-24 09:00:00	AAPL	Stock	41.4375	41.46	41.395	41.445	68860.0
2018-04-24 09:30:00	AAPL	Stock	41.4175	41.5825	41.19	41.325	16224372.0
2018-04-24 10:00:00	AAPL	Stock	41.32	41.3625	41.04	41.1075	9639440.0
2018-04-24 10:30:00	AAPL	Stock	41.1025	41.2475	40.8575	41.045	12248828.0
2018-04-24 11:00:00	AAPL	Stock	41.0475	41.1125	40.91	41.1025	7524784.0
2018-04-24 11:30:00	AAPL	Stock	41.1025	41.155	40.92	40.92	6172192.0
2018-04-24 12:00:00	AAPL	Stock	40.9175	41.045	40.8	40.8825	6156940.0
2018-04-24 12:30:00	AAPL	Stock	40.8825	40.895	40.59	40.5925	7478548.0
2018-04-24 13:00:00	AAPL	Stock	40.59	40.835	40.5825	40.7125	7000968.0
2018-04-24 13:30:00	AAPL	Stock	40.7125	40.7645	40.52	40.5802	5929492.0
2018-04-24 14:00:00	AAPL	Stock	40.5775	40.67	40.305	40.525	8948524.0
2018-04-24 14:30:00	AAPL	Stock	40.5225	40.725	40.495	40.6655	6645244.0
2018-04-24 15:00:00	AAPL	Stock	40.6675	40.7525	40.6075	40.6325	5954720.0
2018-04-24 15:30:00	AAPL	Stock	40.6325	40.77	40.485	40.735	12225484.0
2018-04-24 16:00:00	AAPL	Stock	40.7	40.7745	40.5095	40.7525	6880280.0
2018-04-24 16:30:00	AAPL	Stock	40.75	40.7775	40.735	40.7675	148256.0
2018-04-24 17:00:00	AAPL	Stock	40.77	40.775	40.7375	40.7375	48528.0
2018-04-24 17:30:00	AAPL	Stock	40.76	40.7725	40.705	40.7725	19504.0
2018-04-24 18:00:00	AAPL	Stock	40.74	40.775	40.74	40.775	11452.0
2018-04-24 18:30:00	AAPL	Stock	40.7625	40.79	40.7625	40.7875	4548.0
2018-04-24 19:00:00	AAPL	Stock	40.78	40.7825	40.7625	40.7625	9364.0
2018-04-24 19:30:00	AAPL	Stock	40.7625	40.79	40.7625	40.77	8880.0
2018-04-24 06:30:00	MSFT	Stock	96.21	96.21	96.2	96.2	600.0
2018-04-24 07:00:00	MSFT	Stock	96.05	96.25	96.01	96.01	4115.0
2018-04-24 07:30:00	MSFT	Stock	96.11	96.25	96.1	96.23	10916.0
2018-04-24 08:00:00	MSFT	Stock	96.2	96.24	96.0	96.21	9660.0
2018-04-24 08:30:00	MSFT	Stock	96.2	96.2	96.05	96.1	8566.0
2018-04-24 09:00:00	MSFT	Stock	96.07	96.33	96.07	96.33	7960.0
2018-04-24 09:30:00	MSFT	Stock	96.242	96.47	95.5	95.78	2640505.0
2018-04-24 10:00:00	MSFT	Stock	95.785	96.18	95.3	95.38	1698763.0
2018-04-24 10:30:00	MSFT	Stock	95.38	95.66	95.04	95.26	1653399.0
2018-04-24 11:00:00	MSFT	Stock	95.25	95.29	94.37	94.806	1852945.0
2018-04-24 11:30:00	MSFT	Stock	94.815	95.03	94.39	94.39	1207936.0
2018-04-24 12:00:00	MSFT	Stock	94.38	94.63	93.82	93.96	1820363.0
2018-04-24 12:30:00	MSFT	Stock	93.96	93.98	93.41	93.41	1648830.0
2018-04-24 13:00:00	MSFT	Stock	93.42	93.66	93.1	93.19	1905472.0
2018-04-24 13:30:00	MSFT	Stock	93.2	93.53	92.96	93.116	2312464.0
2018-04-24 14:00:00	MSFT	Stock	93.11	93.125	92.47	92.646	2166690.0
2018-04-24 14:30:00	MSFT	Stock	92.64	93.12	92.41	93.014	2135312.0
2018-04-24 15:00:00	MSFT	Stock	93.01	93.35	92.84	93.05	1713108.0

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

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