PREVIEW / stock_30min / 2008-09-02

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-02.parquet
  size:    1.3 MB
  rows:    69,363
  symbols: 3,324

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-09-02 04:00:00	AAPL	Stock	6.1071	6.1071	6.1071	6.1071	11228.0
2008-09-02 04:30:00	AAPL	Stock	6.1507	6.1536	6.1507	6.1536	13720.0
2008-09-02 07:00:00	AAPL	Stock	6.1071	6.1443	6.1071	6.1357	122584.0
2008-09-02 07:30:00	AAPL	Stock	6.1532	6.1536	6.125	6.1321	804160.0
2008-09-02 08:00:00	AAPL	Stock	6.13	6.1561	6.1204	6.1375	2934848.0
2008-09-02 08:30:00	AAPL	Stock	6.1346	6.1471	6.1286	6.1321	1901032.0
2008-09-02 09:00:00	AAPL	Stock	6.1321	6.1707	6.1321	6.1636	4620784.0
2008-09-02 09:30:00	AAPL	Stock	6.1611	6.1964	6.1343	6.1782	100934288.0
2008-09-02 10:00:00	AAPL	Stock	6.1782	6.185	6.1429	6.1636	52849048.0
2008-09-02 10:30:00	AAPL	Stock	6.1639	6.1668	6.1268	6.1454	38961048.0
2008-09-02 11:00:00	AAPL	Stock	6.145	6.1482	6.1286	6.1389	25757844.0
2008-09-02 11:30:00	AAPL	Stock	6.1382	6.1561	6.1132	6.1361	28379428.0
2008-09-02 12:00:00	AAPL	Stock	6.1361	6.1534	6.1304	6.1432	26293736.0
2008-09-02 12:30:00	AAPL	Stock	6.1432	6.1464	6.1046	6.1204	36275848.0
2008-09-02 13:00:00	AAPL	Stock	6.1204	6.1207	6.0768	6.0843	34050884.0
2008-09-02 13:30:00	AAPL	Stock	6.0839	6.0846	5.92	5.9418	118107276.0
2008-09-02 14:00:00	AAPL	Stock	5.9411	5.9649	5.8929	5.9311	103335288.0
2008-09-02 14:30:00	AAPL	Stock	5.9296	5.9489	5.8964	5.9136	56969164.0
2008-09-02 15:00:00	AAPL	Stock	5.9136	5.9607	5.9071	5.9568	59965556.0
2008-09-02 15:30:00	AAPL	Stock	5.9571	5.9664	5.9186	5.9357	67991392.0
2008-09-02 16:00:00	AAPL	Stock	5.9371	6.1497	5.9329	5.9454	8729140.0
2008-09-02 16:30:00	AAPL	Stock	5.9425	5.9464	5.9354	5.9404	872060.0
2008-09-02 17:00:00	AAPL	Stock	5.94	5.9471	5.9371	5.9432	447636.0
2008-09-02 17:30:00	AAPL	Stock	6.0546	6.0546	5.9354	5.9486	3049228.0
2008-09-02 18:00:00	AAPL	Stock	5.945	5.95	5.9393	5.9479	303072.0
2008-09-02 18:30:00	AAPL	Stock	5.9479	5.9521	5.9479	5.9521	199696.0
2008-09-02 19:00:00	AAPL	Stock	5.9518	5.9579	5.95	5.9579	104356.0
2008-09-02 19:30:00	AAPL	Stock	5.9557	5.9579	5.9525	5.9579	76160.0
2008-09-02 05:30:00	MSFT	Stock	27.42	27.42	27.42	27.42	900.0
2008-09-02 06:00:00	MSFT	Stock	27.42	27.42	27.42	27.42	100.0
2008-09-02 07:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	400.0
2008-09-02 07:30:00	MSFT	Stock	27.45	27.5	27.45	27.5	1600.0
2008-09-02 08:00:00	MSFT	Stock	27.49	27.51	27.47	27.51	9516.0
2008-09-02 08:30:00	MSFT	Stock	27.47	27.51	27.45	27.45	3430.0
2008-09-02 09:00:00	MSFT	Stock	27.41	27.68	27.4	27.68	97535.0
2008-09-02 09:30:00	MSFT	Stock	27.68	27.76	27.48	27.72	6953233.0
2008-09-02 10:00:00	MSFT	Stock	27.73	27.75	27.55	27.64	7006206.0
2008-09-02 10:30:00	MSFT	Stock	27.635	27.64	27.52	27.622	3380341.0
2008-09-02 11:00:00	MSFT	Stock	27.63	27.7	27.585	27.61	3974918.0
2008-09-02 11:30:00	MSFT	Stock	27.61	27.63	27.56	27.58	4685717.0
2008-09-02 12:00:00	MSFT	Stock	27.59	27.59	27.51	27.53	3331356.0
2008-09-02 12:30:00	MSFT	Stock	27.53	27.55	27.47	27.5	4188674.0
2008-09-02 13:00:00	MSFT	Stock	27.5	27.52	27.43	27.46	2518742.0
2008-09-02 13:30:00	MSFT	Stock	27.45	27.54	27.17	27.29	5154955.0
2008-09-02 14:00:00	MSFT	Stock	27.28	27.33	27.11	27.22	4683343.0
2008-09-02 14:30:00	MSFT	Stock	27.22	27.29	27.08	27.12	5215938.0
2008-09-02 15:00:00	MSFT	Stock	27.12	27.17	27.06	27.13	3019810.0
2008-09-02 15:30:00	MSFT	Stock	27.13	27.17	27.08	27.09	6406920.0
2008-09-02 16:00:00	MSFT	Stock	27.11	27.446	27.07	27.07	1581596.0
2008-09-02 16:30:00	MSFT	Stock	27.08	27.1	27.05	27.1	165952.0

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

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