PREVIEW / stock_30min / 2019-02-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-25.parquet
  size:    1.8 MB
  rows:    86,500
  symbols: 2,662

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
2019-02-25 04:00:00	AAPL	Stock	43.4175	43.4175	43.4175	43.4175	4400.0
2019-02-25 04:30:00	AAPL	Stock	43.4075	43.5025	43.4075	43.495	10232.0
2019-02-25 05:00:00	AAPL	Stock	43.495	43.52	43.4825	43.4825	6460.0
2019-02-25 05:30:00	AAPL	Stock	43.4925	43.5275	43.4925	43.5225	23400.0
2019-02-25 06:00:00	AAPL	Stock	43.5225	43.5725	43.5225	43.55	10172.0
2019-02-25 06:30:00	AAPL	Stock	43.5625	43.67	43.52	43.65	26368.0
2019-02-25 07:00:00	AAPL	Stock	43.625	43.6475	43.5275	43.5925	98128.0
2019-02-25 07:30:00	AAPL	Stock	43.5775	43.605	43.56	43.5725	111948.0
2019-02-25 08:00:00	AAPL	Stock	43.5875	43.665	43.375	43.45	469236.0
2019-02-25 08:30:00	AAPL	Stock	43.4525	43.5625	43.45	43.54	173588.0
2019-02-25 09:00:00	AAPL	Stock	43.5475	43.5625	43.47	43.4875	171420.0
2019-02-25 09:30:00	AAPL	Stock	43.54	43.9025	43.4875	43.8425	15390436.0
2019-02-25 10:00:00	AAPL	Stock	43.85	43.9675	43.7625	43.842	8657404.0
2019-02-25 10:30:00	AAPL	Stock	43.8412	43.8725	43.7605	43.855	5512288.0
2019-02-25 11:00:00	AAPL	Stock	43.855	43.905	43.7725	43.7888	4100156.0
2019-02-25 11:30:00	AAPL	Stock	43.79	43.87	43.7525	43.8488	4441820.0
2019-02-25 12:00:00	AAPL	Stock	43.8475	43.8662	43.68	43.715	4927220.0
2019-02-25 12:30:00	AAPL	Stock	43.7175	43.7525	43.5575	43.5975	3944704.0
2019-02-25 13:00:00	AAPL	Stock	43.5975	43.65	43.55	43.5575	2778332.0
2019-02-25 13:30:00	AAPL	Stock	43.555	43.625	43.5075	43.6188	3275080.0
2019-02-25 14:00:00	AAPL	Stock	43.6188	43.72	43.6062	43.6825	3193772.0
2019-02-25 14:30:00	AAPL	Stock	43.685	43.715	43.6525	43.695	2665508.0
2019-02-25 15:00:00	AAPL	Stock	43.6975	43.7075	43.6052	43.615	3737032.0
2019-02-25 15:30:00	AAPL	Stock	43.615	43.6775	43.52	43.565	7712812.0
2019-02-25 16:00:00	AAPL	Stock	43.565	43.57	43.4975	43.5125	6498640.0
2019-02-25 16:30:00	AAPL	Stock	43.51	43.51	43.49	43.4975	14284.0
2019-02-25 17:00:00	AAPL	Stock	43.4975	43.5125	43.45	43.4625	16920.0
2019-02-25 17:30:00	AAPL	Stock	43.455	43.4575	43.43	43.4375	24528.0
2019-02-25 18:00:00	AAPL	Stock	43.4375	43.4375	43.38	43.4	12276.0
2019-02-25 18:30:00	AAPL	Stock	43.3875	43.42	43.3875	43.39	6168.0
2019-02-25 19:00:00	AAPL	Stock	43.4075	43.4225	43.3925	43.395	6576.0
2019-02-25 19:30:00	AAPL	Stock	43.425	43.4475	43.3775	43.41	29604.0
2019-02-25 04:00:00	MSFT	Stock	111.73	111.73	111.47	111.47	2120.0
2019-02-25 05:00:00	MSFT	Stock	111.5	111.67	111.5	111.67	1698.0
2019-02-25 05:30:00	MSFT	Stock	111.77	111.82	111.73	111.75	3641.0
2019-02-25 06:00:00	MSFT	Stock	111.67	111.67	111.65	111.65	951.0
2019-02-25 06:30:00	MSFT	Stock	111.66	111.8	111.6	111.8	822.0
2019-02-25 07:00:00	MSFT	Stock	111.66	111.85	111.6	111.76	28066.0
2019-02-25 07:30:00	MSFT	Stock	111.75	111.87	111.7	111.87	22953.0
2019-02-25 08:00:00	MSFT	Stock	111.83	111.98	111.6	111.84	18992.0
2019-02-25 08:30:00	MSFT	Stock	111.84	112.1	111.81	111.95	40809.0
2019-02-25 09:00:00	MSFT	Stock	111.98	112.14	111.59	111.67	51273.0
2019-02-25 09:30:00	MSFT	Stock	111.66	112.04	111.26	111.57	3511743.0
2019-02-25 10:00:00	MSFT	Stock	111.57	112.18	111.42	111.81	1740956.0
2019-02-25 10:30:00	MSFT	Stock	111.8	112.14	111.63	112.015	1193826.0
2019-02-25 11:00:00	MSFT	Stock	112.02	112.08	111.77	111.815	992222.0
2019-02-25 11:30:00	MSFT	Stock	111.81	111.99	111.77	111.92	1070065.0
2019-02-25 12:00:00	MSFT	Stock	111.91	111.935	111.5	111.52	964816.0
2019-02-25 12:30:00	MSFT	Stock	111.51	111.67	111.33	111.545	1109235.0
2019-02-25 13:00:00	MSFT	Stock	111.56	111.66	111.495	111.516	784560.0

> showing 50 of 86,500 rows — these rows as CSV

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