PREVIEW / stock_1min / 2009-07-08
file: by_date/stock_1min/2009/2009-07-08.parquet size: 13.0 MB rows: 985,242 symbols: 2,692
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-07-08 07:12:00 | AAPL | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 11200.0 |
| 2009-07-08 07:16:00 | AAPL | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 2800.0 |
| 2009-07-08 07:20:00 | AAPL | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 16800.0 |
| 2009-07-08 07:27:00 | AAPL | Stock | 4.8568 | 4.8571 | 4.8568 | 4.8571 | 43036.0 |
| 2009-07-08 07:33:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8571 | 4.8571 | 8400.0 |
| 2009-07-08 07:37:00 | AAPL | Stock | 4.8475 | 4.8475 | 4.8475 | 4.8475 | 2800.0 |
| 2009-07-08 07:38:00 | AAPL | Stock | 4.8657 | 4.8661 | 4.8657 | 4.8661 | 5600.0 |
| 2009-07-08 07:45:00 | AAPL | Stock | 4.8482 | 4.8482 | 4.8482 | 4.8482 | 2800.0 |
| 2009-07-08 07:50:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8571 | 4.8571 | 7392.0 |
| 2009-07-08 08:00:00 | AAPL | Stock | 4.8489 | 4.8571 | 4.8482 | 4.8571 | 44380.0 |
| 2009-07-08 08:01:00 | AAPL | Stock | 4.8571 | 4.8571 | 4.8568 | 4.8568 | 5600.0 |
| 2009-07-08 08:05:00 | AAPL | Stock | 4.8493 | 4.8571 | 4.8493 | 4.8571 | 7280.0 |
| 2009-07-08 08:06:00 | AAPL | Stock | 4.8539 | 4.8539 | 4.8493 | 4.8493 | 15092.0 |
| 2009-07-08 08:07:00 | AAPL | Stock | 4.8493 | 4.8493 | 4.8482 | 4.8482 | 38080.0 |
| 2009-07-08 08:09:00 | AAPL | Stock | 4.8468 | 4.8471 | 4.8454 | 4.8454 | 28336.0 |
| 2009-07-08 08:10:00 | AAPL | Stock | 4.84 | 4.84 | 4.8393 | 4.8393 | 8400.0 |
| 2009-07-08 08:11:00 | AAPL | Stock | 4.8393 | 4.8393 | 4.8393 | 4.8393 | 2800.0 |
| 2009-07-08 08:12:00 | AAPL | Stock | 4.8393 | 4.8393 | 4.8393 | 4.8393 | 2800.0 |
| 2009-07-08 08:14:00 | AAPL | Stock | 4.8393 | 4.8393 | 4.8393 | 4.8393 | 4200.0 |
| 2009-07-08 08:16:00 | AAPL | Stock | 4.8421 | 4.8429 | 4.8421 | 4.8429 | 25480.0 |
| 2009-07-08 08:27:00 | AAPL | Stock | 4.8461 | 4.8464 | 4.8461 | 4.8464 | 26320.0 |
| 2009-07-08 08:28:00 | AAPL | Stock | 4.85 | 4.8518 | 4.85 | 4.8518 | 22400.0 |
| 2009-07-08 08:29:00 | AAPL | Stock | 4.8521 | 4.8525 | 4.8521 | 4.8525 | 12600.0 |
| 2009-07-08 08:30:00 | AAPL | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 2800.0 |
| 2009-07-08 08:32:00 | AAPL | Stock | 4.8464 | 4.8464 | 4.8464 | 4.8464 | 23800.0 |
| 2009-07-08 08:34:00 | AAPL | Stock | 4.8454 | 4.8454 | 4.8454 | 4.8454 | 28000.0 |
| 2009-07-08 08:42:00 | AAPL | Stock | 4.8464 | 4.8464 | 4.8464 | 4.8464 | 2800.0 |
| 2009-07-08 08:45:00 | AAPL | Stock | 4.85 | 4.85 | 4.85 | 4.85 | 2800.0 |
| 2009-07-08 08:48:00 | AAPL | Stock | 4.8457 | 4.8457 | 4.8457 | 4.8457 | 2800.0 |
| 2009-07-08 08:51:00 | AAPL | Stock | 4.8454 | 4.8454 | 4.8396 | 4.8396 | 20608.0 |
| 2009-07-08 08:52:00 | AAPL | Stock | 4.8361 | 4.8361 | 4.8357 | 4.8357 | 9800.0 |
| 2009-07-08 08:53:00 | AAPL | Stock | 4.835 | 4.8375 | 4.8346 | 4.8375 | 32200.0 |
| 2009-07-08 08:54:00 | AAPL | Stock | 4.8332 | 4.8339 | 4.8304 | 4.8339 | 81256.0 |
| 2009-07-08 08:56:00 | AAPL | Stock | 4.8304 | 4.8332 | 4.8304 | 4.8318 | 32760.0 |
| 2009-07-08 08:57:00 | AAPL | Stock | 4.8289 | 4.8289 | 4.8286 | 4.8289 | 10500.0 |
| 2009-07-08 08:58:00 | AAPL | Stock | 4.8314 | 4.835 | 4.8314 | 4.835 | 34048.0 |
| 2009-07-08 08:59:00 | AAPL | Stock | 4.8346 | 4.8371 | 4.8329 | 4.8329 | 36400.0 |
| 2009-07-08 09:00:00 | AAPL | Stock | 4.8375 | 4.8393 | 4.8375 | 4.8393 | 145208.0 |
| 2009-07-08 09:01:00 | AAPL | Stock | 4.8361 | 4.8443 | 4.8357 | 4.8361 | 39200.0 |
| 2009-07-08 09:03:00 | AAPL | Stock | 4.8386 | 4.8443 | 4.8386 | 4.8443 | 8400.0 |
| 2009-07-08 09:04:00 | AAPL | Stock | 4.8379 | 4.8379 | 4.8379 | 4.8379 | 2800.0 |
| 2009-07-08 09:07:00 | AAPL | Stock | 4.8446 | 4.8482 | 4.8446 | 4.8482 | 44744.0 |
| 2009-07-08 09:10:00 | AAPL | Stock | 4.8479 | 4.8479 | 4.8446 | 4.8479 | 14000.0 |
| 2009-07-08 09:13:00 | AAPL | Stock | 4.8464 | 4.8482 | 4.8464 | 4.8482 | 19880.0 |
| 2009-07-08 09:15:00 | AAPL | Stock | 4.8446 | 4.8482 | 4.8429 | 4.8429 | 44800.0 |
| 2009-07-08 09:25:00 | AAPL | Stock | 4.8411 | 4.8411 | 4.8411 | 4.8411 | 2800.0 |
| 2009-07-08 09:26:00 | AAPL | Stock | 4.8489 | 4.8489 | 4.8489 | 4.8489 | 2800.0 |
| 2009-07-08 09:27:00 | AAPL | Stock | 4.8339 | 4.8339 | 4.8339 | 4.8339 | 5600.0 |
| 2009-07-08 09:28:00 | AAPL | Stock | 4.8493 | 4.8493 | 4.8429 | 4.8486 | 50400.0 |
| 2009-07-08 09:29:00 | AAPL | Stock | 4.8446 | 4.8446 | 4.8446 | 4.8446 | 14000.0 |
> showing 50 of 985,242 rows — these rows as CSV