PREVIEW / stock_30min / 2016-08-03

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-03.parquet
  size:    1.6 MB
  rows:    81,717
  symbols: 3,248

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
2016-08-03 04:00:00	AAPL	Stock	26.08	26.08	26.08	26.08	1908.0
2016-08-03 04:30:00	AAPL	Stock	26.1175	26.1175	26.08	26.08	1264.0
2016-08-03 05:00:00	AAPL	Stock	26.1175	26.1175	26.1175	26.1175	400.0
2016-08-03 05:30:00	AAPL	Stock	26.15	26.15	26.15	26.15	1200.0
2016-08-03 06:00:00	AAPL	Stock	26.15	26.15	26.145	26.145	5636.0
2016-08-03 06:30:00	AAPL	Stock	26.1625	26.165	26.135	26.135	13840.0
2016-08-03 07:00:00	AAPL	Stock	26.13	26.15	26.13	26.13	3528.0
2016-08-03 07:30:00	AAPL	Stock	26.13	26.145	26.125	26.1325	19880.0
2016-08-03 08:00:00	AAPL	Stock	26.145	26.1975	26.12	26.19	176292.0
2016-08-03 08:30:00	AAPL	Stock	26.185	26.19	26.15	26.1675	88872.0
2016-08-03 09:00:00	AAPL	Stock	26.1675	26.2125	26.1675	26.2125	185208.0
2016-08-03 09:30:00	AAPL	Stock	26.2025	26.4	26.1925	26.39	20830840.0
2016-08-03 10:00:00	AAPL	Stock	26.39	26.46	26.355	26.39	11772832.0
2016-08-03 10:30:00	AAPL	Stock	26.3875	26.41	26.3262	26.348	7661640.0
2016-08-03 11:00:00	AAPL	Stock	26.3488	26.3925	26.325	26.3425	5690500.0
2016-08-03 11:30:00	AAPL	Stock	26.3435	26.3675	26.34	26.36	4517500.0
2016-08-03 12:00:00	AAPL	Stock	26.36	26.37	26.3525	26.3575	3923976.0
2016-08-03 12:30:00	AAPL	Stock	26.36	26.3875	26.3525	26.3725	4381340.0
2016-08-03 13:00:00	AAPL	Stock	26.3748	26.4325	26.3675	26.4275	4828216.0
2016-08-03 13:30:00	AAPL	Stock	26.426	26.4425	26.4175	26.42	5857952.0
2016-08-03 14:00:00	AAPL	Stock	26.4175	26.4375	26.3725	26.3888	5194864.0
2016-08-03 14:30:00	AAPL	Stock	26.39	26.425	26.3825	26.4175	4045160.0
2016-08-03 15:00:00	AAPL	Stock	26.416	26.4525	26.4125	26.4475	6254600.0
2016-08-03 15:30:00	AAPL	Stock	26.4462	26.4575	26.4375	26.45	12552356.0
2016-08-03 16:00:00	AAPL	Stock	26.45	26.4725	26.364	26.46	7887400.0
2016-08-03 16:30:00	AAPL	Stock	26.465	26.4725	26.4525	26.4725	66820.0
2016-08-03 17:00:00	AAPL	Stock	26.4625	26.4725	26.4475	26.465	4670900.0
2016-08-03 17:30:00	AAPL	Stock	26.465	26.4675	26.45	26.45	52456.0
2016-08-03 18:00:00	AAPL	Stock	26.45	26.4525	26.445	26.4525	25760.0
2016-08-03 18:30:00	AAPL	Stock	26.4475	26.4525	26.4475	26.4475	9800.0
2016-08-03 19:00:00	AAPL	Stock	26.4475	26.47	26.445	26.47	17208.0
2016-08-03 19:30:00	AAPL	Stock	26.4675	26.48	26.4625	26.47	68208.0
2016-08-03 04:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	625.0
2016-08-03 06:30:00	MSFT	Stock	56.45	56.45	56.45	56.45	375.0
2016-08-03 08:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	175.0
2016-08-03 09:00:00	MSFT	Stock	56.56	56.68	56.56	56.68	4527.0
2016-08-03 09:30:00	MSFT	Stock	56.68	56.845	56.49	56.815	2371480.0
2016-08-03 10:00:00	MSFT	Stock	56.82	57.11	56.73	57.02	2540131.0
2016-08-03 10:30:00	MSFT	Stock	57.01	57.06	56.84	56.855	1502169.0
2016-08-03 11:00:00	MSFT	Stock	56.86	56.89	56.79	56.845	866045.0
2016-08-03 11:30:00	MSFT	Stock	56.85	56.919	56.75	56.836	1821825.0
2016-08-03 12:00:00	MSFT	Stock	56.84	56.84	56.77	56.779	737094.0
2016-08-03 12:30:00	MSFT	Stock	56.78	56.84	56.75	56.755	789599.0
2016-08-03 13:00:00	MSFT	Stock	56.755	56.77	56.715	56.735	1032597.0
2016-08-03 13:30:00	MSFT	Stock	56.73	56.78	56.67	56.765	752081.0
2016-08-03 14:00:00	MSFT	Stock	56.77	56.84	56.74	56.795	861781.0
2016-08-03 14:30:00	MSFT	Stock	56.79	56.845	56.75	56.825	1061592.0
2016-08-03 15:00:00	MSFT	Stock	56.82	56.93	56.81	56.92	1533001.0
2016-08-03 15:30:00	MSFT	Stock	56.92	56.98	56.81	56.96	3111219.0
2016-08-03 16:00:00	MSFT	Stock	56.97	56.97	56.83	56.96	2099684.0

> showing 50 of 81,717 rows — these rows as CSV

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