PREVIEW / stock_30min / 2018-06-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-11.parquet
  size:    1.7 MB
  rows:    84,206
  symbols: 2,833

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-06-11 04:00:00	AAPL	Stock	47.9	47.9	47.9	47.9	1960.0
2018-06-11 04:30:00	AAPL	Stock	47.8675	47.8675	47.8675	47.8675	1148.0
2018-06-11 05:00:00	AAPL	Stock	47.875	47.875	47.875	47.875	3140.0
2018-06-11 05:30:00	AAPL	Stock	47.875	47.875	47.875	47.875	764.0
2018-06-11 06:30:00	AAPL	Stock	47.8075	47.825	47.8075	47.825	1824.0
2018-06-11 07:00:00	AAPL	Stock	47.8125	47.915	47.8125	47.915	108804.0
2018-06-11 07:30:00	AAPL	Stock	47.915	47.9675	47.915	47.9375	91556.0
2018-06-11 08:00:00	AAPL	Stock	47.8402	47.9675	47.8175	47.9	109752.0
2018-06-11 08:30:00	AAPL	Stock	47.9025	47.9025	47.8775	47.8925	42076.0
2018-06-11 09:00:00	AAPL	Stock	47.89	47.9725	47.8375	47.8375	115484.0
2018-06-11 09:30:00	AAPL	Stock	47.835	47.9925	47.725	47.78	10580932.0
2018-06-11 10:00:00	AAPL	Stock	47.7775	47.7975	47.61	47.6575	7095936.0
2018-06-11 10:30:00	AAPL	Stock	47.659	47.69	47.5525	47.6312	5443620.0
2018-06-11 11:00:00	AAPL	Stock	47.6325	47.71	47.6078	47.7025	3820356.0
2018-06-11 11:30:00	AAPL	Stock	47.7038	47.8412	47.6938	47.7962	4086196.0
2018-06-11 12:00:00	AAPL	Stock	47.7975	47.8775	47.7875	47.855	3510772.0
2018-06-11 12:30:00	AAPL	Stock	47.8525	47.965	47.8425	47.93	4323716.0
2018-06-11 13:00:00	AAPL	Stock	47.9275	47.9475	47.855	47.925	2605296.0
2018-06-11 13:30:00	AAPL	Stock	47.9263	47.9375	47.84	47.845	2903984.0
2018-06-11 14:00:00	AAPL	Stock	47.8425	47.88	47.7875	47.857	2910124.0
2018-06-11 14:30:00	AAPL	Stock	47.855	47.8575	47.8	47.8462	2248156.0
2018-06-11 15:00:00	AAPL	Stock	47.8475	47.8725	47.8225	47.8628	2516808.0
2018-06-11 15:30:00	AAPL	Stock	47.865	47.8688	47.7675	47.815	6615360.0
2018-06-11 16:00:00	AAPL	Stock	47.8075	47.8325	47.7627	47.83	5272468.0
2018-06-11 16:30:00	AAPL	Stock	47.81	47.8125	47.7975	47.8075	309940.0
2018-06-11 17:00:00	AAPL	Stock	47.805	47.8075	47.805	47.8075	12440.0
2018-06-11 17:30:00	AAPL	Stock	47.79	47.8075	47.79	47.8075	3488.0
2018-06-11 18:00:00	AAPL	Stock	47.8	47.8	47.7525	47.7525	101892.0
2018-06-11 18:30:00	AAPL	Stock	47.78	47.8125	47.78	47.8	11232.0
2018-06-11 19:00:00	AAPL	Stock	47.785	47.815	47.785	47.815	9584.0
2018-06-11 19:30:00	AAPL	Stock	47.815	47.815	47.7625	47.7625	20040.0
2018-06-11 04:00:00	MSFT	Stock	101.6	101.6	101.51	101.51	1432.0
2018-06-11 06:00:00	MSFT	Stock	101.67	101.67	101.67	101.67	300.0
2018-06-11 07:00:00	MSFT	Stock	101.63	101.8	101.63	101.69	1331.0
2018-06-11 07:30:00	MSFT	Stock	101.7	101.79	101.7	101.79	2282.0
2018-06-11 08:00:00	MSFT	Stock	101.7	101.89	101.5	101.52	8567.0
2018-06-11 08:30:00	MSFT	Stock	101.53	101.65	101.5	101.65	3451.0
2018-06-11 09:00:00	MSFT	Stock	101.59	101.69	101.32	101.33	23749.0
2018-06-11 09:30:00	MSFT	Stock	101.37	101.59	100.67	101.13	3065309.0
2018-06-11 10:00:00	MSFT	Stock	101.13	101.18	100.82	100.945	1659236.0
2018-06-11 10:30:00	MSFT	Stock	100.94	101.11	100.84	101.11	897038.0
2018-06-11 11:00:00	MSFT	Stock	101.11	101.29	100.98	101.265	752922.0
2018-06-11 11:30:00	MSFT	Stock	101.265	101.488	101.18	101.47	642591.0
2018-06-11 12:00:00	MSFT	Stock	101.48	101.54	101.36	101.49	826399.0
2018-06-11 12:30:00	MSFT	Stock	101.495	101.53	101.34	101.37	583987.0
2018-06-11 13:00:00	MSFT	Stock	101.367	101.426	101.27	101.37	487326.0
2018-06-11 13:30:00	MSFT	Stock	101.371	101.44	101.2	101.275	606863.0
2018-06-11 14:00:00	MSFT	Stock	101.27	101.275	101.07	101.109	846989.0
2018-06-11 14:30:00	MSFT	Stock	101.107	101.2	101.04	101.18	666806.0
2018-06-11 15:00:00	MSFT	Stock	101.185	101.31	101.14	101.195	807873.0

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

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