PREVIEW / stock_30min / 2018-04-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-16.parquet
  size:    1.6 MB
  rows:    83,375
  symbols: 2,868

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-16 04:00:00	AAPL	Stock	43.7725	43.8	43.7725	43.8	800.0
2018-04-16 05:30:00	AAPL	Stock	43.935	43.9375	43.935	43.9375	2800.0
2018-04-16 06:00:00	AAPL	Stock	43.9375	43.9375	43.9375	43.9375	1000.0
2018-04-16 06:30:00	AAPL	Stock	43.87	43.96	43.87	43.9475	8196.0
2018-04-16 07:00:00	AAPL	Stock	43.94	43.9625	43.8625	43.8875	74384.0
2018-04-16 07:30:00	AAPL	Stock	43.89	43.925	43.875	43.9125	30924.0
2018-04-16 08:00:00	AAPL	Stock	43.925	43.9375	43.88	43.8875	80336.0
2018-04-16 08:30:00	AAPL	Stock	43.8875	43.98	43.8875	43.97	122548.0
2018-04-16 09:00:00	AAPL	Stock	43.9675	43.975	43.7275	43.7575	281344.0
2018-04-16 09:30:00	AAPL	Stock	43.78	44.0	43.7075	43.9132	13083880.0
2018-04-16 10:00:00	AAPL	Stock	43.915	43.99	43.815	43.92	6704068.0
2018-04-16 10:30:00	AAPL	Stock	43.925	43.9475	43.7575	43.8312	5427012.0
2018-04-16 11:00:00	AAPL	Stock	43.8325	43.9075	43.7312	43.8525	5286020.0
2018-04-16 11:30:00	AAPL	Stock	43.855	43.915	43.8125	43.8825	3824624.0
2018-04-16 12:00:00	AAPL	Stock	43.8825	43.9	43.77	43.8432	4547048.0
2018-04-16 12:30:00	AAPL	Stock	43.845	43.9975	43.8425	43.98	4123728.0
2018-04-16 13:00:00	AAPL	Stock	43.98	44.0	43.95	43.9875	3927704.0
2018-04-16 13:30:00	AAPL	Stock	43.9888	44.0475	43.96	44.0	5123500.0
2018-04-16 14:00:00	AAPL	Stock	44.0	44.0225	43.925	43.94	3783072.0
2018-04-16 14:30:00	AAPL	Stock	43.94	44.01	43.925	43.9875	3255052.0
2018-04-16 15:00:00	AAPL	Stock	43.9852	44.02	43.8625	43.9175	4565016.0
2018-04-16 15:30:00	AAPL	Stock	43.9175	44.0375	43.9125	43.955	8200764.0
2018-04-16 16:00:00	AAPL	Stock	43.955	44.085	43.925	44.0	5042172.0
2018-04-16 16:30:00	AAPL	Stock	44.0375	44.0375	43.955	43.98	34052.0
2018-04-16 17:00:00	AAPL	Stock	43.9725	43.9975	43.955	43.9975	62828.0
2018-04-16 17:30:00	AAPL	Stock	43.9975	43.9975	43.9675	43.975	7284.0
2018-04-16 18:00:00	AAPL	Stock	43.975	43.9975	43.9675	43.9975	12340.0
2018-04-16 19:00:00	AAPL	Stock	43.9925	44.0025	43.99	44.0	8192.0
2018-04-16 19:30:00	AAPL	Stock	44.005	44.035	44.0025	44.025	27696.0
2018-04-16 05:00:00	MSFT	Stock	93.36	93.61	93.35	93.61	1932.0
2018-04-16 05:30:00	MSFT	Stock	93.61	93.9	93.61	93.9	400.0
2018-04-16 06:30:00	MSFT	Stock	93.54	93.54	93.54	93.54	447.0
2018-04-16 07:00:00	MSFT	Stock	93.82	93.82	93.21	93.5	5833.0
2018-04-16 07:30:00	MSFT	Stock	93.5	93.72	93.5	93.65	9131.0
2018-04-16 08:00:00	MSFT	Stock	93.55	93.721	93.55	93.55	9862.0
2018-04-16 08:30:00	MSFT	Stock	93.64	93.9	93.59	93.9	9443.0
2018-04-16 09:00:00	MSFT	Stock	93.79	94.12	93.78	94.07	47445.0
2018-04-16 09:30:00	MSFT	Stock	94.08	94.23	93.51	93.68	2252157.0
2018-04-16 10:00:00	MSFT	Stock	93.68	94.23	93.68	94.17	1387156.0
2018-04-16 10:30:00	MSFT	Stock	94.18	94.27	93.74	93.89	1058257.0
2018-04-16 11:00:00	MSFT	Stock	93.89	93.99	93.42	93.87	1047795.0
2018-04-16 11:30:00	MSFT	Stock	93.87	94.125	93.755	94.078	741603.0
2018-04-16 12:00:00	MSFT	Stock	94.08	94.235	93.98	94.045	924369.0
2018-04-16 12:30:00	MSFT	Stock	94.05	94.613	93.94	94.56	1515600.0
2018-04-16 13:00:00	MSFT	Stock	94.56	94.66	94.34	94.39	919585.0
2018-04-16 13:30:00	MSFT	Stock	94.395	94.45	94.2	94.3	715349.0
2018-04-16 14:00:00	MSFT	Stock	94.31	94.36	94.06	94.12	832878.0
2018-04-16 14:30:00	MSFT	Stock	94.12	94.35	94.075	94.195	666407.0
2018-04-16 15:00:00	MSFT	Stock	94.19	94.305	94.03	94.18	943332.0
2018-04-16 15:30:00	MSFT	Stock	94.17	94.54	94.12	94.17	2562605.0

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

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