PREVIEW / stock_30min / 2018-08-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-07.parquet
  size:    1.7 MB
  rows:    83,203
  symbols: 2,779

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-07 04:00:00	AAPL	Stock	52.3125	52.39	52.28	52.3825	17312.0
2018-08-07 04:30:00	AAPL	Stock	52.385	52.44	52.385	52.4375	14176.0
2018-08-07 05:00:00	AAPL	Stock	52.4375	52.4675	52.425	52.425	14644.0
2018-08-07 05:30:00	AAPL	Stock	52.445	52.45	52.4125	52.4225	9000.0
2018-08-07 06:00:00	AAPL	Stock	52.42	52.4225	52.36	52.36	12616.0
2018-08-07 06:30:00	AAPL	Stock	52.41	52.4125	52.375	52.4125	11504.0
2018-08-07 07:00:00	AAPL	Stock	52.4125	52.415	52.36	52.3875	73892.0
2018-08-07 07:30:00	AAPL	Stock	52.3875	52.4075	52.3625	52.3625	61140.0
2018-08-07 08:00:00	AAPL	Stock	52.395	52.42	52.3375	52.355	163016.0
2018-08-07 08:30:00	AAPL	Stock	52.3475	52.375	52.315	52.37	145708.0
2018-08-07 09:00:00	AAPL	Stock	52.3725	52.3725	52.25	52.33	630880.0
2018-08-07 09:30:00	AAPL	Stock	52.325	52.375	51.9675	52.0575	15440868.0
2018-08-07 10:00:00	AAPL	Stock	52.0575	52.0925	51.69	51.9233	13615952.0
2018-08-07 10:30:00	AAPL	Stock	51.925	52.0275	51.795	51.8225	8207364.0
2018-08-07 11:00:00	AAPL	Stock	51.825	51.9075	51.735	51.7662	5773532.0
2018-08-07 11:30:00	AAPL	Stock	51.765	51.8225	51.7	51.785	5965856.0
2018-08-07 12:00:00	AAPL	Stock	51.7875	51.8475	51.7275	51.8237	4880604.0
2018-08-07 12:30:00	AAPL	Stock	51.825	51.8775	51.7725	51.8718	3433536.0
2018-08-07 13:00:00	AAPL	Stock	51.8725	51.8847	51.815	51.83	3186788.0
2018-08-07 13:30:00	AAPL	Stock	51.83	51.8925	51.7675	51.8875	3139340.0
2018-08-07 14:00:00	AAPL	Stock	51.8875	51.94	51.8625	51.8938	3287772.0
2018-08-07 14:30:00	AAPL	Stock	51.8925	51.8975	51.7925	51.81	2995348.0
2018-08-07 15:00:00	AAPL	Stock	51.8125	51.8175	51.7325	51.755	5322172.0
2018-08-07 15:30:00	AAPL	Stock	51.755	51.845	51.715	51.7775	8295532.0
2018-08-07 16:00:00	AAPL	Stock	51.7775	51.8787	51.7775	51.8	5242876.0
2018-08-07 16:30:00	AAPL	Stock	51.8	51.8025	51.7525	51.76	92116.0
2018-08-07 17:00:00	AAPL	Stock	51.78	51.78	51.76	51.76	21736.0
2018-08-07 17:30:00	AAPL	Stock	51.76	51.7775	51.7375	51.75	75336.0
2018-08-07 18:00:00	AAPL	Stock	51.75	51.75	51.725	51.745	30912.0
2018-08-07 18:30:00	AAPL	Stock	51.735	51.7625	51.735	51.7375	28128.0
2018-08-07 19:00:00	AAPL	Stock	51.74	51.76	51.74	51.74	9500.0
2018-08-07 19:30:00	AAPL	Stock	51.745	51.7625	51.72	51.72	80372.0
2018-08-07 04:00:00	MSFT	Stock	108.2	108.58	108.2	108.58	386.0
2018-08-07 05:00:00	MSFT	Stock	108.59	108.59	108.59	108.59	320.0
2018-08-07 06:00:00	MSFT	Stock	108.54	108.54	108.5	108.5	328.0
2018-08-07 06:30:00	MSFT	Stock	108.5	108.54	108.5	108.54	500.0
2018-08-07 07:00:00	MSFT	Stock	108.3	108.54	108.3	108.51	644.0
2018-08-07 07:30:00	MSFT	Stock	108.5	108.5	108.4	108.4	1311.0
2018-08-07 08:00:00	MSFT	Stock	108.38	108.59	108.25	108.43	5773.0
2018-08-07 08:30:00	MSFT	Stock	108.4	108.43	108.34	108.35	4576.0
2018-08-07 09:00:00	MSFT	Stock	108.4	108.57	108.336	108.57	34440.0
2018-08-07 09:30:00	MSFT	Stock	108.54	109.1	108.17	108.72	2555922.0
2018-08-07 10:00:00	MSFT	Stock	108.72	108.885	108.61	108.855	1181132.0
2018-08-07 10:30:00	MSFT	Stock	108.86	108.98	108.406	108.48	1147376.0
2018-08-07 11:00:00	MSFT	Stock	108.49	108.64	108.3	108.33	636443.0
2018-08-07 11:30:00	MSFT	Stock	108.334	108.66	108.28	108.605	829071.0
2018-08-07 12:00:00	MSFT	Stock	108.61	108.91	108.585	108.84	766987.0
2018-08-07 12:30:00	MSFT	Stock	108.845	108.92	108.74	108.863	614737.0
2018-08-07 13:00:00	MSFT	Stock	108.87	108.89	108.71	108.72	672668.0
2018-08-07 13:30:00	MSFT	Stock	108.73	109.03	108.71	108.98	911209.0

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

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