PREVIEW / stock_30min / 2019-12-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-30.parquet
  size:    1.8 MB
  rows:    86,330
  symbols: 2,467

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-12-30 04:00:00	AAPL	Stock	72.5375	72.5375	72.525	72.525	4844.0
2019-12-30 04:30:00	AAPL	Stock	72.445	72.445	72.445	72.445	1916.0
2019-12-30 05:00:00	AAPL	Stock	72.375	72.38	72.375	72.375	4500.0
2019-12-30 05:30:00	AAPL	Stock	72.35	72.35	72.35	72.35	800.0
2019-12-30 06:00:00	AAPL	Stock	72.35	72.35	72.275	72.345	9136.0
2019-12-30 06:30:00	AAPL	Stock	72.3625	72.3625	72.3625	72.3625	1368.0
2019-12-30 07:00:00	AAPL	Stock	72.3875	72.435	72.35	72.4	78224.0
2019-12-30 07:30:00	AAPL	Stock	72.41	72.4375	72.41	72.43	23536.0
2019-12-30 08:00:00	AAPL	Stock	72.4	72.45	72.3125	72.44	133056.0
2019-12-30 08:30:00	AAPL	Stock	72.43	72.4625	72.405	72.4575	93700.0
2019-12-30 09:00:00	AAPL	Stock	72.4375	72.46	72.3225	72.3925	116512.0
2019-12-30 09:30:00	AAPL	Stock	72.3925	72.3925	71.585	71.6928	16512640.0
2019-12-30 10:00:00	AAPL	Stock	71.7088	71.7875	71.305	71.6	10188348.0
2019-12-30 10:30:00	AAPL	Stock	71.6	71.9475	71.5298	71.9038	8219052.0
2019-12-30 11:00:00	AAPL	Stock	71.904	72.415	71.795	72.3075	10315128.0
2019-12-30 11:30:00	AAPL	Stock	72.31	72.715	72.29	72.6165	11190448.0
2019-12-30 12:00:00	AAPL	Stock	72.6125	72.965	72.5623	72.7812	10968692.0
2019-12-30 12:30:00	AAPL	Stock	72.781	72.9725	72.781	72.87	6144808.0
2019-12-30 13:00:00	AAPL	Stock	72.87	72.9675	72.74	72.9042	4726860.0
2019-12-30 13:30:00	AAPL	Stock	72.91	73.1725	72.8725	73.1562	7533172.0
2019-12-30 14:00:00	AAPL	Stock	73.15	73.154	72.889	72.9275	6542008.0
2019-12-30 14:30:00	AAPL	Stock	72.9225	72.9592	72.77	72.8225	4915424.0
2019-12-30 15:00:00	AAPL	Stock	72.8225	73.075	72.7725	73.0675	5910292.0
2019-12-30 15:30:00	AAPL	Stock	73.065	73.125	72.815	72.9118	10895836.0
2019-12-30 16:00:00	AAPL	Stock	72.88	72.925	72.7725	72.865	6193356.0
2019-12-30 16:30:00	AAPL	Stock	72.8625	72.88	72.8175	72.8325	49340.0
2019-12-30 17:00:00	AAPL	Stock	72.855	72.86	72.835	72.86	23848.0
2019-12-30 17:30:00	AAPL	Stock	72.8625	72.865	72.85	72.8575	14100.0
2019-12-30 18:00:00	AAPL	Stock	72.855	72.875	72.8525	72.87	19756.0
2019-12-30 18:30:00	AAPL	Stock	72.855	72.875	72.855	72.875	17336.0
2019-12-30 19:00:00	AAPL	Stock	72.855	72.8875	72.855	72.8775	37708.0
2019-12-30 19:30:00	AAPL	Stock	72.8625	72.9375	72.8625	72.925	49164.0
2019-12-30 04:00:00	MSFT	Stock	159.1	159.25	159.1	159.2	330.0
2019-12-30 04:30:00	MSFT	Stock	159.2	159.2	158.98	158.98	4000.0
2019-12-30 05:00:00	MSFT	Stock	158.95	158.95	158.9	158.9	1120.0
2019-12-30 05:30:00	MSFT	Stock	158.9	158.9	158.86	158.86	740.0
2019-12-30 06:00:00	MSFT	Stock	158.9	158.9	158.81	158.81	396.0
2019-12-30 06:30:00	MSFT	Stock	158.88	158.88	158.85	158.85	400.0
2019-12-30 07:00:00	MSFT	Stock	158.92	158.96	158.82	158.82	3017.0
2019-12-30 07:30:00	MSFT	Stock	158.82	158.93	158.8	158.8	4518.0
2019-12-30 08:00:00	MSFT	Stock	158.9	158.94	158.712	158.75	8670.0
2019-12-30 08:30:00	MSFT	Stock	158.84	158.9	158.8	158.897	3825.0
2019-12-30 09:00:00	MSFT	Stock	158.761	158.99	158.75	158.99	12285.0
2019-12-30 09:30:00	MSFT	Stock	158.83	159.02	157.07	157.175	2447760.0
2019-12-30 10:00:00	MSFT	Stock	157.17	157.39	156.73	157.11	1553653.0
2019-12-30 10:30:00	MSFT	Stock	157.11	157.668	157.05	157.61	829932.0
2019-12-30 11:00:00	MSFT	Stock	157.62	157.9	157.32	157.771	719130.0
2019-12-30 11:30:00	MSFT	Stock	157.75	157.93	157.675	157.74	449161.0
2019-12-30 12:00:00	MSFT	Stock	157.747	157.87	157.63	157.855	531338.0
2019-12-30 12:30:00	MSFT	Stock	157.86	158.131	157.84	158.02	618772.0

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

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