PREVIEW / stock_30min / 2020-01-06

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-06.parquet
  size:    1.8 MB
  rows:    87,896
  symbols: 2,475

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
2020-01-06 04:00:00	AAPL	Stock	73.8575	73.8775	73.49	73.575	56388.0
2020-01-06 04:30:00	AAPL	Stock	73.5625	73.725	73.5	73.725	54432.0
2020-01-06 05:00:00	AAPL	Stock	73.725	73.825	73.7	73.7775	34400.0
2020-01-06 05:30:00	AAPL	Stock	73.6825	73.7375	73.6725	73.7375	24260.0
2020-01-06 06:00:00	AAPL	Stock	73.6775	73.78	73.475	73.78	65580.0
2020-01-06 06:30:00	AAPL	Stock	73.7725	73.7725	73.5625	73.675	54480.0
2020-01-06 07:00:00	AAPL	Stock	73.685	73.875	73.62	73.875	263152.0
2020-01-06 07:30:00	AAPL	Stock	73.8475	73.8475	73.6025	73.6875	325928.0
2020-01-06 08:00:00	AAPL	Stock	73.7625	73.875	73.57	73.7238	673956.0
2020-01-06 08:30:00	AAPL	Stock	73.7292	73.75	73.575	73.65	416652.0
2020-01-06 09:00:00	AAPL	Stock	73.63	73.8125	73.3675	73.45	903640.0
2020-01-06 09:30:00	AAPL	Stock	73.4475	74.2475	73.1875	74.21	21468984.0
2020-01-06 10:00:00	AAPL	Stock	74.22	74.3925	74.0562	74.3848	8143328.0
2020-01-06 10:30:00	AAPL	Stock	74.39	74.5597	74.1415	74.51	7736164.0
2020-01-06 11:00:00	AAPL	Stock	74.5175	74.8948	74.4125	74.8025	9004792.0
2020-01-06 11:30:00	AAPL	Stock	74.8	74.91	74.555	74.6145	5265044.0
2020-01-06 12:00:00	AAPL	Stock	74.61	74.615	74.285	74.4675	6048256.0
2020-01-06 12:30:00	AAPL	Stock	74.47	74.56	74.41	74.5312	3149552.0
2020-01-06 13:00:00	AAPL	Stock	74.5387	74.72	74.51	74.6875	3761416.0
2020-01-06 13:30:00	AAPL	Stock	74.6925	74.8425	74.68	74.7982	3698272.0
2020-01-06 14:00:00	AAPL	Stock	74.7975	74.99	74.765	74.8465	5529700.0
2020-01-06 14:30:00	AAPL	Stock	74.85	74.8625	74.745	74.845	4017192.0
2020-01-06 15:00:00	AAPL	Stock	74.845	74.925	74.7725	74.8075	4304720.0
2020-01-06 15:30:00	AAPL	Stock	74.8072	74.97	74.735	74.945	9748280.0
2020-01-06 16:00:00	AAPL	Stock	74.95	74.9675	74.825	74.875	5672060.0
2020-01-06 16:30:00	AAPL	Stock	74.8625	74.95	74.8375	74.8925	85184.0
2020-01-06 17:00:00	AAPL	Stock	74.88	74.9225	74.88	74.9	56920.0
2020-01-06 17:30:00	AAPL	Stock	74.8975	74.915	74.8525	74.885	45188.0
2020-01-06 18:00:00	AAPL	Stock	74.885	74.89	74.875	74.875	3200.0
2020-01-06 18:30:00	AAPL	Stock	74.8875	74.8875	74.75	74.7525	73224.0
2020-01-06 19:00:00	AAPL	Stock	74.7625	74.8625	74.7625	74.8375	20312.0
2020-01-06 19:30:00	AAPL	Stock	74.845	74.92	74.845	74.905	66156.0
2020-01-06 04:00:00	MSFT	Stock	157.4	157.4	157.05	157.06	7530.0
2020-01-06 04:30:00	MSFT	Stock	157.01	157.2	156.8	156.92	14089.0
2020-01-06 05:00:00	MSFT	Stock	156.9	157.1	156.86	157.01	3634.0
2020-01-06 05:30:00	MSFT	Stock	156.85	157.0	156.73	157.0	3692.0
2020-01-06 06:00:00	MSFT	Stock	156.82	157.09	156.82	157.0	2402.0
2020-01-06 06:30:00	MSFT	Stock	157.0	157.11	156.88	157.11	2487.0
2020-01-06 07:00:00	MSFT	Stock	157.11	157.48	157.0	157.4	12316.0
2020-01-06 07:30:00	MSFT	Stock	157.33	157.67	157.27	157.33	12413.0
2020-01-06 08:00:00	MSFT	Stock	157.35	157.66	157.01	157.35	24435.0
2020-01-06 08:30:00	MSFT	Stock	157.282	157.35	157.21	157.34	22261.0
2020-01-06 09:00:00	MSFT	Stock	157.37	157.45	156.74	157.09	60557.0
2020-01-06 09:30:00	MSFT	Stock	157.08	158.275	156.51	158.25	2765082.0
2020-01-06 10:00:00	MSFT	Stock	158.25	158.455	157.99	158.43	904748.0
2020-01-06 10:30:00	MSFT	Stock	158.42	158.925	158.33	158.61	1214669.0
2020-01-06 11:00:00	MSFT	Stock	158.62	158.82	158.5	158.57	682340.0
2020-01-06 11:30:00	MSFT	Stock	158.565	158.71	158.24	158.24	586480.0
2020-01-06 12:00:00	MSFT	Stock	158.24	158.26	157.975	158.25	769699.0
2020-01-06 12:30:00	MSFT	Stock	158.24	158.346	158.1	158.306	444563.0

> showing 50 of 87,896 rows — these rows as CSV

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