PREVIEW / stock_30min / 2008-01-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-02.parquet
  size:    1.3 MB
  rows:    71,657
  symbols: 3,257

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
2008-01-02 05:30:00	AAPL	Stock	7.1239	7.125	7.1239	7.125	56000.0
2008-01-02 06:00:00	AAPL	Stock	7.1246	7.1246	7.1246	7.1246	40880.0
2008-01-02 06:30:00	AAPL	Stock	7.1286	7.1364	7.1286	7.1364	78400.0
2008-01-02 07:00:00	AAPL	Stock	7.1364	7.1364	7.1179	7.13	63000.0
2008-01-02 07:30:00	AAPL	Stock	7.1304	7.1404	7.1286	7.1304	379400.0
2008-01-02 08:00:00	AAPL	Stock	7.1318	7.1382	7.0743	7.1064	4929792.0
2008-01-02 08:30:00	AAPL	Stock	7.1043	7.1114	7.0964	7.0964	1180340.0
2008-01-02 09:00:00	AAPL	Stock	7.0982	7.1357	7.0743	7.1196	3072972.0
2008-01-02 09:30:00	AAPL	Stock	7.1179	7.1504	7.0911	7.1486	108981348.0
2008-01-02 10:00:00	AAPL	Stock	7.1493	7.1521	7.1032	7.1393	93431100.0
2008-01-02 10:30:00	AAPL	Stock	7.1379	7.1464	7.0711	7.0732	78313984.0
2008-01-02 11:00:00	AAPL	Stock	7.0732	7.0961	6.9607	6.99	120499624.0
2008-01-02 11:30:00	AAPL	Stock	6.9893	6.9932	6.9107	6.9696	94747856.0
2008-01-02 12:00:00	AAPL	Stock	6.9686	7.125	6.8768	6.9007	77408296.0
2008-01-02 12:30:00	AAPL	Stock	6.9007	6.9536	6.8989	6.9454	49558908.0
2008-01-02 13:00:00	AAPL	Stock	6.9454	6.9604	6.9107	6.95	50416800.0
2008-01-02 13:30:00	AAPL	Stock	6.9496	6.9804	6.9368	6.9636	47305692.0
2008-01-02 14:00:00	AAPL	Stock	6.9639	7.0386	6.9539	7.0086	97071716.0
2008-01-02 14:30:00	AAPL	Stock	7.0096	7.0207	6.9286	6.9329	77884492.0
2008-01-02 15:00:00	AAPL	Stock	6.9318	6.96	6.9204	6.9361	64052100.0
2008-01-02 15:30:00	AAPL	Stock	6.9372	6.975	6.925	6.9618	94792628.0
2008-01-02 16:00:00	AAPL	Stock	6.9629	7.0064	6.9586	6.9757	11389196.0
2008-01-02 16:30:00	AAPL	Stock	6.9757	7.0743	6.9586	6.9714	2250164.0
2008-01-02 17:00:00	AAPL	Stock	6.9757	7.0061	6.9586	6.9736	497336.0
2008-01-02 17:30:00	AAPL	Stock	6.9357	7.0076	6.9357	6.975	334068.0
2008-01-02 18:00:00	AAPL	Stock	6.975	6.9768	6.9718	6.9718	198492.0
2008-01-02 18:30:00	AAPL	Stock	6.9714	6.9768	6.97	6.9768	71820.0
2008-01-02 19:00:00	AAPL	Stock	6.9768	6.9814	6.9714	6.9814	77308.0
2008-01-02 19:30:00	AAPL	Stock	6.975	6.9821	6.9721	6.9821	212548.0
2008-01-02 07:00:00	MSFT	Stock	35.65	35.65	35.65	35.65	500.0
2008-01-02 07:30:00	MSFT	Stock	35.65	35.65	35.65	35.65	600.0
2008-01-02 08:00:00	MSFT	Stock	35.65	35.7	35.6	35.6	623992.0
2008-01-02 08:30:00	MSFT	Stock	35.73	35.75	35.6	35.71	81915.0
2008-01-02 09:00:00	MSFT	Stock	35.71	35.8	35.6	35.8	59820.0
2008-01-02 09:30:00	MSFT	Stock	35.79	35.96	35.7	35.87	4851448.0
2008-01-02 10:00:00	MSFT	Stock	35.86	35.86	35.47	35.5	6239643.0
2008-01-02 10:30:00	MSFT	Stock	35.495	35.56	35.4	35.49	3128945.0
2008-01-02 11:00:00	MSFT	Stock	35.49	35.67	35.47	35.551	5921349.0
2008-01-02 11:30:00	MSFT	Stock	35.55	35.56	35.18	35.407	3494854.0
2008-01-02 12:00:00	MSFT	Stock	35.4	35.58	35.02	35.1	3579692.0
2008-01-02 12:30:00	MSFT	Stock	35.107	35.31	35.1	35.19	2850027.0
2008-01-02 13:00:00	MSFT	Stock	35.19	35.275	35.07	35.113	3539175.0
2008-01-02 13:30:00	MSFT	Stock	35.12	35.33	35.105	35.22	3400723.0
2008-01-02 14:00:00	MSFT	Stock	35.23	35.48	35.18	35.29	4572418.0
2008-01-02 14:30:00	MSFT	Stock	35.29	35.37	35.07	35.08	3616004.0
2008-01-02 15:00:00	MSFT	Stock	35.08	35.25	35.0	35.12	5604371.0
2008-01-02 15:30:00	MSFT	Stock	35.13	35.3	35.088	35.23	8333916.0
2008-01-02 16:00:00	MSFT	Stock	35.23	35.83	35.14	35.22	2629606.0
2008-01-02 16:30:00	MSFT	Stock	35.22	35.6	35.2	35.22	494578.0
2008-01-02 17:00:00	MSFT	Stock	35.22	35.33	35.22	35.33	66200.0

> showing 50 of 71,657 rows — these rows as CSV

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