PREVIEW / stock_30min / 2009-02-12

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-12.parquet
  size:    1.2 MB
  rows:    66,816
  symbols: 3,278

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-02-12 05:00:00	AAPL	Stock	3.4214	3.4214	3.4107	3.4107	5600.0
2009-02-12 07:30:00	AAPL	Stock	3.4157	3.4157	3.4146	3.4146	13720.0
2009-02-12 08:00:00	AAPL	Stock	3.4339	3.4393	3.4214	3.4268	532028.0
2009-02-12 08:30:00	AAPL	Stock	3.4318	3.4525	3.4286	3.4479	574252.0
2009-02-12 09:00:00	AAPL	Stock	3.4471	3.4471	3.4204	3.4246	913220.0
2009-02-12 09:30:00	AAPL	Stock	3.4246	3.4961	3.4225	3.4861	105632632.0
2009-02-12 10:00:00	AAPL	Stock	3.4854	3.4864	3.4429	3.4739	79952124.0
2009-02-12 10:30:00	AAPL	Stock	3.4736	3.5193	3.4604	3.5046	68730060.0
2009-02-12 11:00:00	AAPL	Stock	3.5043	3.5143	3.4918	3.5061	51224292.0
2009-02-12 11:30:00	AAPL	Stock	3.5061	3.5318	3.505	3.5171	48963684.0
2009-02-12 12:00:00	AAPL	Stock	3.5168	3.5507	3.5143	3.5432	38113040.0
2009-02-12 12:30:00	AAPL	Stock	3.5432	3.5461	3.5254	3.5264	28069384.0
2009-02-12 13:00:00	AAPL	Stock	3.5264	3.5271	3.485	3.4943	54676860.0
2009-02-12 13:30:00	AAPL	Stock	3.4936	3.5096	3.4761	3.5075	37438772.0
2009-02-12 14:00:00	AAPL	Stock	3.5081	3.51	3.4886	3.4939	41413876.0
2009-02-12 14:30:00	AAPL	Stock	3.4939	3.4979	3.4518	3.4664	55780620.0
2009-02-12 15:00:00	AAPL	Stock	3.4664	3.5282	3.4529	3.5271	72925328.0
2009-02-12 15:30:00	AAPL	Stock	3.5271	3.5625	3.5146	3.5475	107472736.0
2009-02-12 16:00:00	AAPL	Stock	3.5457	3.5546	3.498	3.5454	8204224.0
2009-02-12 16:30:00	AAPL	Stock	3.5446	3.55	3.5432	3.5443	622048.0
2009-02-12 17:00:00	AAPL	Stock	3.5475	3.55	3.5443	3.55	141848.0
2009-02-12 17:30:00	AAPL	Stock	3.5493	3.5536	3.5464	3.55	91700.0
2009-02-12 18:00:00	AAPL	Stock	3.55	3.55	3.5454	3.5496	9741984.0
2009-02-12 18:30:00	AAPL	Stock	3.5475	3.5496	3.5446	3.5446	110180.0
2009-02-12 19:00:00	AAPL	Stock	3.5432	3.5436	3.5429	3.5436	14000.0
2009-02-12 19:30:00	AAPL	Stock	3.5429	3.5443	3.5429	3.5439	18200.0
2009-02-12 07:00:00	MSFT	Stock	18.89	18.94	18.88	18.94	4000.0
2009-02-12 07:30:00	MSFT	Stock	19.08	19.08	19.08	19.08	600.0
2009-02-12 08:00:00	MSFT	Stock	19.09	19.09	19.04	19.04	1296.0
2009-02-12 08:30:00	MSFT	Stock	19.1	19.21	19.08	19.18	16126.0
2009-02-12 09:00:00	MSFT	Stock	19.19	19.19	18.97	19.0	69755.0
2009-02-12 09:30:00	MSFT	Stock	19.0	19.11	18.71	18.778	6730638.0
2009-02-12 10:00:00	MSFT	Stock	18.78	18.85	18.63	18.808	6743213.0
2009-02-12 10:30:00	MSFT	Stock	18.81	18.87	18.72	18.75	4213603.0
2009-02-12 11:00:00	MSFT	Stock	18.75	18.852	18.68	18.75	4733620.0
2009-02-12 11:30:00	MSFT	Stock	18.75	19.04	18.75	18.93	5823443.0
2009-02-12 12:00:00	MSFT	Stock	18.93	19.16	18.91	19.11	2520304.0
2009-02-12 12:30:00	MSFT	Stock	19.11	19.13	18.92	18.95	2109463.0
2009-02-12 13:00:00	MSFT	Stock	18.96	18.96	18.77	18.815	2804061.0
2009-02-12 13:30:00	MSFT	Stock	18.813	18.94	18.78	18.913	2854366.0
2009-02-12 14:00:00	MSFT	Stock	18.91	18.96	18.85	18.872	3374681.0
2009-02-12 14:30:00	MSFT	Stock	18.87	18.9	18.6	18.66	3914263.0
2009-02-12 15:00:00	MSFT	Stock	18.657	18.95	18.54	18.95	7078464.0
2009-02-12 15:30:00	MSFT	Stock	18.95	19.32	18.86	19.32	14715637.0
2009-02-12 16:00:00	MSFT	Stock	19.29	19.32	18.844	18.908	6364259.0
2009-02-12 16:30:00	MSFT	Stock	19.26	19.29	19.22	19.26	507725.0
2009-02-12 17:00:00	MSFT	Stock	19.26	19.28	19.25	19.28	8230.0
2009-02-12 17:30:00	MSFT	Stock	19.28	19.28	19.2	19.2	10388.0
2009-02-12 18:00:00	MSFT	Stock	19.2	19.2	19.19	19.19	1986.0
2009-02-12 18:30:00	MSFT	Stock	19.19	19.24	19.1	19.15	5496.0

> showing 50 of 66,816 rows — these rows as CSV

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