PREVIEW / stock_30min / 2009-01-28

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-28.parquet
  size:    1.2 MB
  rows:    69,160
  symbols: 3,305

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
2009-01-28 04:00:00	AAPL	Stock	3.2661	3.2661	3.2661	3.2661	30800.0
2009-01-28 04:30:00	AAPL	Stock	3.2661	3.2661	3.2661	3.2661	25200.0
2009-01-28 06:30:00	AAPL	Stock	3.2768	3.2954	3.2768	3.2954	137200.0
2009-01-28 07:00:00	AAPL	Stock	3.2857	3.3	3.2857	3.2946	238000.0
2009-01-28 07:30:00	AAPL	Stock	3.2857	3.3125	3.2821	3.3121	204876.0
2009-01-28 08:00:00	AAPL	Stock	3.3039	3.3189	3.2857	3.3189	1578892.0
2009-01-28 08:30:00	AAPL	Stock	3.3107	3.3186	3.3057	3.3064	1211980.0
2009-01-28 09:00:00	AAPL	Stock	3.3057	3.3104	3.2893	3.2893	1604008.0
2009-01-28 09:30:00	AAPL	Stock	3.29	3.3014	3.2679	3.275	73700928.0
2009-01-28 10:00:00	AAPL	Stock	3.275	3.2904	3.2679	3.2771	51707152.0
2009-01-28 10:30:00	AAPL	Stock	3.2775	3.3089	3.275	3.3079	61720176.0
2009-01-28 11:00:00	AAPL	Stock	3.3089	3.3254	3.2893	3.3216	67345852.0
2009-01-28 11:30:00	AAPL	Stock	3.3214	3.3396	3.3189	3.3389	55426168.0
2009-01-28 12:00:00	AAPL	Stock	3.3389	3.3679	3.3382	3.3661	59999716.0
2009-01-28 12:30:00	AAPL	Stock	3.3664	3.3664	3.335	3.3395	45868760.0
2009-01-28 13:00:00	AAPL	Stock	3.3393	3.3707	3.3371	3.3661	40652472.0
2009-01-28 13:30:00	AAPL	Stock	3.3664	3.3839	3.3657	3.3664	55656048.0
2009-01-28 14:00:00	AAPL	Stock	3.3664	3.3929	3.3636	3.3864	62143256.0
2009-01-28 14:30:00	AAPL	Stock	3.3864	3.3914	3.3625	3.3907	68717236.0
2009-01-28 15:00:00	AAPL	Stock	3.3907	3.3925	3.3464	3.3496	71027488.0
2009-01-28 15:30:00	AAPL	Stock	3.3493	3.3757	3.3411	3.3687	83999328.0
2009-01-28 16:00:00	AAPL	Stock	3.3654	3.3695	3.3399	3.3571	26065172.0
2009-01-28 16:30:00	AAPL	Stock	3.3671	3.3671	3.3464	3.3579	2248148.0
2009-01-28 17:00:00	AAPL	Stock	3.3582	3.3604	3.3571	3.3604	67592.0
2009-01-28 17:30:00	AAPL	Stock	3.3579	3.3636	3.3579	3.3589	84952.0
2009-01-28 18:00:00	AAPL	Stock	3.3579	3.3671	3.2851	3.3571	17255868.0
2009-01-28 18:30:00	AAPL	Stock	3.3571	3.3571	3.3554	3.3568	74116.0
2009-01-28 19:00:00	AAPL	Stock	3.3554	3.3571	3.3536	3.3536	42112.0
2009-01-28 19:30:00	AAPL	Stock	3.3536	3.3621	3.3482	3.3482	38136.0
2009-01-28 07:00:00	MSFT	Stock	17.82	17.82	17.82	17.82	100.0
2009-01-28 07:30:00	MSFT	Stock	17.82	17.92	17.82	17.92	2507.0
2009-01-28 08:00:00	MSFT	Stock	17.92	18.0	17.91	17.99	22797.0
2009-01-28 08:30:00	MSFT	Stock	17.99	18.08	17.99	18.02	51291.0
2009-01-28 09:00:00	MSFT	Stock	18.02	18.08	17.67	17.85	292778.0
2009-01-28 09:30:00	MSFT	Stock	17.83	18.04	17.76	17.83	8434378.0
2009-01-28 10:00:00	MSFT	Stock	17.82	17.9	17.79	17.87	4283182.0
2009-01-28 10:30:00	MSFT	Stock	17.87	18.08	17.859	18.0	4863524.0
2009-01-28 11:00:00	MSFT	Stock	18.0	18.15	17.99	18.08	4660495.0
2009-01-28 11:30:00	MSFT	Stock	18.09	18.12	18.02	18.068	3319356.0
2009-01-28 12:00:00	MSFT	Stock	18.07	18.12	18.02	18.03	1952530.0
2009-01-28 12:30:00	MSFT	Stock	18.03	18.03	17.96	17.97	2224794.0
2009-01-28 13:00:00	MSFT	Stock	17.98	18.06	17.94	18.052	2516237.0
2009-01-28 13:30:00	MSFT	Stock	18.06	18.15	18.05	18.13	2821699.0
2009-01-28 14:00:00	MSFT	Stock	18.125	18.31	18.09	18.17	5149201.0
2009-01-28 14:30:00	MSFT	Stock	18.17	18.25	18.1	18.24	4140626.0
2009-01-28 15:00:00	MSFT	Stock	18.24	18.29	17.85	17.87	5347035.0
2009-01-28 15:30:00	MSFT	Stock	17.87	18.11	17.82	18.06	9006535.0
2009-01-28 16:00:00	MSFT	Stock	18.08	18.08	17.856	18.04	3148563.0
2009-01-28 16:30:00	MSFT	Stock	18.04	18.04	17.95	17.95	20657.0
2009-01-28 17:00:00	MSFT	Stock	17.95	17.96	17.95	17.95	2270.0

> showing 50 of 69,160 rows — these rows as CSV

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