PREVIEW / stock_30min / 2018-08-09

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-09.parquet
  size:    1.7 MB
  rows:    82,336
  symbols: 2,782

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-08-09 04:00:00	AAPL	Stock	51.725	51.725	51.6325	51.6325	4948.0
2018-08-09 04:30:00	AAPL	Stock	51.6125	51.7225	51.6125	51.7225	17100.0
2018-08-09 05:00:00	AAPL	Stock	51.725	51.725	51.725	51.725	5112.0
2018-08-09 05:30:00	AAPL	Stock	51.735	51.8	51.735	51.8	43712.0
2018-08-09 06:00:00	AAPL	Stock	51.8	51.8	51.8	51.8	1000.0
2018-08-09 06:30:00	AAPL	Stock	51.81	51.81	51.81	51.81	800.0
2018-08-09 07:00:00	AAPL	Stock	51.745	51.8025	51.7375	51.775	34196.0
2018-08-09 07:30:00	AAPL	Stock	51.775	51.785	51.7375	51.785	29052.0
2018-08-09 08:00:00	AAPL	Stock	51.7725	51.8075	51.7488	51.805	56888.0
2018-08-09 08:30:00	AAPL	Stock	51.805	51.8375	51.765	51.8325	44528.0
2018-08-09 09:00:00	AAPL	Stock	51.8175	51.8625	51.805	51.85	101668.0
2018-08-09 09:30:00	AAPL	Stock	51.82	52.1825	51.8	52.1325	11065616.0
2018-08-09 10:00:00	AAPL	Stock	52.1345	52.3975	52.1275	52.3675	10588188.0
2018-08-09 10:30:00	AAPL	Stock	52.37	52.3925	52.1825	52.215	5624168.0
2018-08-09 11:00:00	AAPL	Stock	52.216	52.3125	52.0575	52.24	7664624.0
2018-08-09 11:30:00	AAPL	Stock	52.2375	52.3225	52.17	52.2375	5621800.0
2018-08-09 12:00:00	AAPL	Stock	52.2375	52.3475	52.2262	52.305	3980228.0
2018-08-09 12:30:00	AAPL	Stock	52.3075	52.39	52.2575	52.39	3632224.0
2018-08-09 13:00:00	AAPL	Stock	52.39	52.4375	52.325	52.3575	3474684.0
2018-08-09 13:30:00	AAPL	Stock	52.3593	52.4025	52.3475	52.37	3164608.0
2018-08-09 14:00:00	AAPL	Stock	52.37	52.4275	52.36	52.415	2872980.0
2018-08-09 14:30:00	AAPL	Stock	52.415	52.445	52.3475	52.3538	3727200.0
2018-08-09 15:00:00	AAPL	Stock	52.3525	52.42	52.3512	52.3925	3048076.0
2018-08-09 15:30:00	AAPL	Stock	52.39	52.4075	52.2062	52.2225	10724500.0
2018-08-09 16:00:00	AAPL	Stock	52.22	52.2675	52.175	52.215	5671056.0
2018-08-09 16:30:00	AAPL	Stock	52.2125	52.22	52.2	52.2075	43108.0
2018-08-09 17:00:00	AAPL	Stock	52.2	52.22	52.1875	52.19	311976.0
2018-08-09 17:30:00	AAPL	Stock	52.1875	52.215	52.1875	52.215	5848.0
2018-08-09 18:00:00	AAPL	Stock	52.2	52.215	52.185	52.1875	12420.0
2018-08-09 18:30:00	AAPL	Stock	52.1975	52.1975	52.18	52.18	24960.0
2018-08-09 19:00:00	AAPL	Stock	52.195	52.195	52.175	52.195	14928.0
2018-08-09 19:30:00	AAPL	Stock	52.2075	52.21	52.1975	52.21	40824.0
2018-08-09 06:00:00	MSFT	Stock	109.74	109.74	109.74	109.74	100.0
2018-08-09 06:30:00	MSFT	Stock	109.5	109.5	109.5	109.5	632.0
2018-08-09 07:00:00	MSFT	Stock	109.49	109.49	109.49	109.49	300.0
2018-08-09 07:30:00	MSFT	Stock	109.49	109.49	109.46	109.46	1496.0
2018-08-09 08:00:00	MSFT	Stock	109.49	109.75	109.2	109.6	11419.0
2018-08-09 08:30:00	MSFT	Stock	109.6	109.69	109.55	109.6	23592.0
2018-08-09 09:00:00	MSFT	Stock	109.66	109.99	109.65	109.99	23205.0
2018-08-09 09:30:00	MSFT	Stock	109.84	110.16	109.71	109.91	1998992.0
2018-08-09 10:00:00	MSFT	Stock	109.92	110.05	109.71	109.95	1085776.0
2018-08-09 10:30:00	MSFT	Stock	109.96	110.05	109.9	109.94	810794.0
2018-08-09 11:00:00	MSFT	Stock	109.95	110.105	109.87	110.03	757400.0
2018-08-09 11:30:00	MSFT	Stock	110.04	110.04	109.77	109.905	650450.0
2018-08-09 12:00:00	MSFT	Stock	109.903	109.97	109.85	109.945	456845.0
2018-08-09 12:30:00	MSFT	Stock	109.95	110.04	109.87	110.015	595025.0
2018-08-09 13:00:00	MSFT	Stock	110.01	110.02	109.91	109.97	440375.0
2018-08-09 13:30:00	MSFT	Stock	109.98	110.06	109.955	110.04	405654.0
2018-08-09 14:00:00	MSFT	Stock	110.04	110.04	109.77	109.89	725072.0
2018-08-09 14:30:00	MSFT	Stock	109.88	109.99	109.85	109.86	452172.0

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

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