PREVIEW / stock_1min / 2004-09-16
file: by_date/stock_1min/2004/2004-09-16.parquet size: 5.5 MB rows: 467,558 symbols: 1,493
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-16 08:57:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6293 | 0.6293 | 16800.0 |
| 2004-09-16 09:19:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6293 | 0.6293 | 33600.0 |
| 2004-09-16 09:22:00 | AAPL | Stock | 0.6293 | 0.6293 | 0.6293 | 0.6293 | 5600.0 |
| 2004-09-16 09:23:00 | AAPL | Stock | 0.6286 | 0.6286 | 0.6286 | 0.6286 | 5600.0 |
| 2004-09-16 09:29:00 | AAPL | Stock | 0.6289 | 0.6368 | 0.6257 | 0.6302 | 950936.0 |
| 2004-09-16 09:30:00 | AAPL | Stock | 0.6286 | 0.6339 | 0.6271 | 0.6314 | 3752280.0 |
| 2004-09-16 09:31:00 | AAPL | Stock | 0.6313 | 0.6341 | 0.6313 | 0.6339 | 1796928.0 |
| 2004-09-16 09:32:00 | AAPL | Stock | 0.6338 | 0.6339 | 0.6321 | 0.6332 | 1217328.0 |
| 2004-09-16 09:33:00 | AAPL | Stock | 0.6329 | 0.6338 | 0.6329 | 0.6336 | 652680.0 |
| 2004-09-16 09:34:00 | AAPL | Stock | 0.6336 | 0.6339 | 0.6329 | 0.6338 | 1263864.0 |
| 2004-09-16 09:35:00 | AAPL | Stock | 0.6338 | 0.6348 | 0.6338 | 0.6345 | 2124248.0 |
| 2004-09-16 09:36:00 | AAPL | Stock | 0.6346 | 0.635 | 0.6338 | 0.6341 | 633192.0 |
| 2004-09-16 09:37:00 | AAPL | Stock | 0.6339 | 0.6357 | 0.6334 | 0.6355 | 2145472.0 |
| 2004-09-16 09:38:00 | AAPL | Stock | 0.6354 | 0.6357 | 0.6352 | 0.6355 | 386400.0 |
| 2004-09-16 09:39:00 | AAPL | Stock | 0.6357 | 0.6361 | 0.6334 | 0.635 | 955416.0 |
| 2004-09-16 09:40:00 | AAPL | Stock | 0.6339 | 0.6357 | 0.6336 | 0.6357 | 790720.0 |
| 2004-09-16 09:41:00 | AAPL | Stock | 0.6357 | 0.6363 | 0.635 | 0.6354 | 918400.0 |
| 2004-09-16 09:42:00 | AAPL | Stock | 0.6355 | 0.6359 | 0.6354 | 0.6357 | 523600.0 |
| 2004-09-16 09:43:00 | AAPL | Stock | 0.6359 | 0.6359 | 0.6354 | 0.6354 | 486752.0 |
| 2004-09-16 09:44:00 | AAPL | Stock | 0.6354 | 0.6363 | 0.6354 | 0.6363 | 716800.0 |
| 2004-09-16 09:45:00 | AAPL | Stock | 0.6364 | 0.6386 | 0.6363 | 0.6384 | 2915416.0 |
| 2004-09-16 09:46:00 | AAPL | Stock | 0.6384 | 0.6402 | 0.6366 | 0.6391 | 3116400.0 |
| 2004-09-16 09:47:00 | AAPL | Stock | 0.6393 | 0.64 | 0.6388 | 0.6393 | 2560544.0 |
| 2004-09-16 09:48:00 | AAPL | Stock | 0.6393 | 0.6395 | 0.6384 | 0.6393 | 2307200.0 |
| 2004-09-16 09:49:00 | AAPL | Stock | 0.6389 | 0.6391 | 0.6384 | 0.6391 | 2429280.0 |
| 2004-09-16 09:50:00 | AAPL | Stock | 0.6389 | 0.6398 | 0.6386 | 0.6394 | 2225272.0 |
| 2004-09-16 09:51:00 | AAPL | Stock | 0.6389 | 0.6393 | 0.6388 | 0.6391 | 3278800.0 |
| 2004-09-16 09:52:00 | AAPL | Stock | 0.6391 | 0.6391 | 0.6388 | 0.6388 | 1380624.0 |
| 2004-09-16 09:53:00 | AAPL | Stock | 0.6389 | 0.6391 | 0.6386 | 0.6391 | 1623720.0 |
| 2004-09-16 09:54:00 | AAPL | Stock | 0.6391 | 0.6391 | 0.6384 | 0.6384 | 1129800.0 |
| 2004-09-16 09:55:00 | AAPL | Stock | 0.6382 | 0.6386 | 0.637 | 0.6373 | 2732800.0 |
| 2004-09-16 09:56:00 | AAPL | Stock | 0.6371 | 0.638 | 0.6371 | 0.638 | 578144.0 |
| 2004-09-16 09:57:00 | AAPL | Stock | 0.638 | 0.6391 | 0.638 | 0.6391 | 814744.0 |
| 2004-09-16 09:58:00 | AAPL | Stock | 0.6391 | 0.6393 | 0.6389 | 0.6391 | 1395408.0 |
| 2004-09-16 09:59:00 | AAPL | Stock | 0.6388 | 0.6393 | 0.6388 | 0.6391 | 1728832.0 |
| 2004-09-16 10:00:00 | AAPL | Stock | 0.6393 | 0.6398 | 0.6384 | 0.6398 | 3250072.0 |
| 2004-09-16 10:01:00 | AAPL | Stock | 0.6398 | 0.64 | 0.6396 | 0.64 | 578200.0 |
| 2004-09-16 10:02:00 | AAPL | Stock | 0.6398 | 0.6398 | 0.6391 | 0.6391 | 708400.0 |
| 2004-09-16 10:03:00 | AAPL | Stock | 0.6389 | 0.6393 | 0.6377 | 0.6377 | 3045280.0 |
| 2004-09-16 10:04:00 | AAPL | Stock | 0.6379 | 0.6382 | 0.6377 | 0.6382 | 2095072.0 |
| 2004-09-16 10:05:00 | AAPL | Stock | 0.6382 | 0.6393 | 0.6379 | 0.6393 | 1825992.0 |
| 2004-09-16 10:06:00 | AAPL | Stock | 0.6393 | 0.6393 | 0.6384 | 0.6393 | 1993600.0 |
| 2004-09-16 10:07:00 | AAPL | Stock | 0.6395 | 0.6402 | 0.6395 | 0.64 | 609112.0 |
| 2004-09-16 10:08:00 | AAPL | Stock | 0.64 | 0.64 | 0.6389 | 0.6389 | 373744.0 |
| 2004-09-16 10:09:00 | AAPL | Stock | 0.6391 | 0.6393 | 0.6389 | 0.6393 | 492800.0 |
| 2004-09-16 10:10:00 | AAPL | Stock | 0.6393 | 0.6395 | 0.6393 | 0.6395 | 688800.0 |
| 2004-09-16 10:11:00 | AAPL | Stock | 0.6395 | 0.6407 | 0.6395 | 0.6404 | 2079728.0 |
| 2004-09-16 10:12:00 | AAPL | Stock | 0.6407 | 0.6409 | 0.6405 | 0.6407 | 812168.0 |
| 2004-09-16 10:13:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6405 | 0.6411 | 394856.0 |
| 2004-09-16 10:14:00 | AAPL | Stock | 0.6409 | 0.6411 | 0.6409 | 0.6411 | 1528576.0 |
> showing 50 of 467,558 rows — these rows as CSV