PREVIEW / stock_30min / 2018-03-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-05.parquet
  size:    1.7 MB
  rows:    84,224
  symbols: 2,882

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-05 04:00:00	AAPL	Stock	44.025	44.025	43.8825	43.8825	4800.0
2018-03-05 04:30:00	AAPL	Stock	43.8825	44.0125	43.85	43.9975	57028.0
2018-03-05 05:00:00	AAPL	Stock	43.9975	44.0	43.95	44.0	45420.0
2018-03-05 05:30:00	AAPL	Stock	43.96	44.0525	43.96	44.0525	20256.0
2018-03-05 06:00:00	AAPL	Stock	44.07	44.075	43.975	44.01	37736.0
2018-03-05 06:30:00	AAPL	Stock	43.9775	44.0125	43.9775	44.005	4800.0
2018-03-05 07:00:00	AAPL	Stock	43.975	43.9975	43.925	43.96	150000.0
2018-03-05 07:30:00	AAPL	Stock	43.935	43.9475	43.8175	43.8375	127388.0
2018-03-05 08:00:00	AAPL	Stock	43.9875	43.9875	43.8375	43.9575	123452.0
2018-03-05 08:30:00	AAPL	Stock	43.965	44.02	43.875	43.8875	177952.0
2018-03-05 09:00:00	AAPL	Stock	43.8875	43.8975	43.785	43.7875	167576.0
2018-03-05 09:30:00	AAPL	Stock	43.785	44.145	43.63	43.83	17988264.0
2018-03-05 10:00:00	AAPL	Stock	43.8275	43.9575	43.6925	43.86	8167596.0
2018-03-05 10:30:00	AAPL	Stock	43.8638	44.1175	43.79	44.1025	7171540.0
2018-03-05 11:00:00	AAPL	Stock	44.1	44.2175	44.0375	44.165	6157032.0
2018-03-05 11:30:00	AAPL	Stock	44.165	44.3575	44.14	44.32	6157912.0
2018-03-05 12:00:00	AAPL	Stock	44.32	44.405	44.1825	44.27	5429260.0
2018-03-05 12:30:00	AAPL	Stock	44.275	44.35	44.2225	44.345	4220540.0
2018-03-05 13:00:00	AAPL	Stock	44.3475	44.435	44.325	44.3267	4540860.0
2018-03-05 13:30:00	AAPL	Stock	44.325	44.36	44.2098	44.3525	4338700.0
2018-03-05 14:00:00	AAPL	Stock	44.3542	44.3575	44.1175	44.21	5918128.0
2018-03-05 14:30:00	AAPL	Stock	44.2112	44.3475	44.195	44.3395	4635104.0
2018-03-05 15:00:00	AAPL	Stock	44.3375	44.4	44.265	44.285	5498372.0
2018-03-05 15:30:00	AAPL	Stock	44.2875	44.38	44.1875	44.2075	10297428.0
2018-03-05 16:00:00	AAPL	Stock	44.205	44.2325	44.1525	44.1525	8884088.0
2018-03-05 16:30:00	AAPL	Stock	44.175	44.205	44.135	44.155	84824.0
2018-03-05 17:00:00	AAPL	Stock	44.15	44.2	44.15	44.1625	27016.0
2018-03-05 17:30:00	AAPL	Stock	44.1625	44.17	44.1625	44.17	15392.0
2018-03-05 18:00:00	AAPL	Stock	44.17	44.195	44.16	44.16	7400.0
2018-03-05 18:30:00	AAPL	Stock	44.16	44.175	44.16	44.16	9764.0
2018-03-05 19:00:00	AAPL	Stock	44.1875	44.2	44.1875	44.1875	4488.0
2018-03-05 19:30:00	AAPL	Stock	44.195	44.2475	44.1875	44.2225	18256.0
2018-03-05 07:00:00	MSFT	Stock	93.0	93.05	92.73	92.73	1361.0
2018-03-05 07:30:00	MSFT	Stock	92.9	92.9	92.9	92.9	100.0
2018-03-05 08:00:00	MSFT	Stock	93.0	93.06	92.5	93.06	48407.0
2018-03-05 08:30:00	MSFT	Stock	93.05	93.07	92.78	92.78	7406.0
2018-03-05 09:00:00	MSFT	Stock	92.77	92.77	92.44	92.44	22531.0
2018-03-05 09:30:00	MSFT	Stock	92.44	93.2	92.26	92.955	3402086.0
2018-03-05 10:00:00	MSFT	Stock	92.96	93.11	92.31	92.565	1598769.0
2018-03-05 10:30:00	MSFT	Stock	92.565	92.95	92.47	92.92	1043111.0
2018-03-05 11:00:00	MSFT	Stock	92.92	93.32	92.86	93.25	1285726.0
2018-03-05 11:30:00	MSFT	Stock	93.24	93.63	93.235	93.577	1088928.0
2018-03-05 12:00:00	MSFT	Stock	93.575	93.83	93.41	93.59	1133278.0
2018-03-05 12:30:00	MSFT	Stock	93.59	93.82	93.485	93.81	635973.0
2018-03-05 13:00:00	MSFT	Stock	93.82	94.09	93.82	93.84	1023766.0
2018-03-05 13:30:00	MSFT	Stock	93.84	93.93	93.55	93.71	814553.0
2018-03-05 14:00:00	MSFT	Stock	93.71	93.82	93.404	93.662	925027.0
2018-03-05 14:30:00	MSFT	Stock	93.67	94.05	93.65	94.005	1117716.0
2018-03-05 15:00:00	MSFT	Stock	94.0	94.27	93.76	93.82	1328342.0
2018-03-05 15:30:00	MSFT	Stock	93.81	94.02	93.62	93.64	2978051.0

> showing 50 of 84,224 rows — these rows as CSV

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