PREVIEW / stock_5min / 2005-06-28
file: by_date/stock_5min/2005/2005-06-28.parquet size: 2.8 MB rows: 203,185 symbols: 2,009
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-28 08:15:00 | AAPL | Stock | 1.3364 | 1.3364 | 1.3357 | 1.3357 | 117600.0 |
| 2005-06-28 08:20:00 | AAPL | Stock | 1.3357 | 1.3393 | 1.3357 | 1.3393 | 63840.0 |
| 2005-06-28 08:25:00 | AAPL | Stock | 1.3393 | 1.3407 | 1.3375 | 1.3375 | 58240.0 |
| 2005-06-28 08:30:00 | AAPL | Stock | 1.3357 | 1.3357 | 1.3357 | 1.3357 | 50400.0 |
| 2005-06-28 08:40:00 | AAPL | Stock | 1.3368 | 1.3393 | 1.3368 | 1.3389 | 148400.0 |
| 2005-06-28 08:45:00 | AAPL | Stock | 1.3361 | 1.3361 | 1.3357 | 1.3357 | 28000.0 |
| 2005-06-28 08:50:00 | AAPL | Stock | 1.3357 | 1.3364 | 1.3357 | 1.3357 | 37940.0 |
| 2005-06-28 08:55:00 | AAPL | Stock | 1.3357 | 1.3364 | 1.3339 | 1.3364 | 62440.0 |
| 2005-06-28 09:00:00 | AAPL | Stock | 1.3364 | 1.3379 | 1.3364 | 1.3379 | 12600.0 |
| 2005-06-28 09:05:00 | AAPL | Stock | 1.3379 | 1.3379 | 1.325 | 1.3375 | 1727600.0 |
| 2005-06-28 09:10:00 | AAPL | Stock | 1.3364 | 1.3371 | 1.3364 | 1.3371 | 30324.0 |
| 2005-06-28 09:15:00 | AAPL | Stock | 1.3371 | 1.3371 | 1.3371 | 1.3371 | 87136.0 |
| 2005-06-28 09:20:00 | AAPL | Stock | 1.3371 | 1.3393 | 1.3371 | 1.3393 | 76076.0 |
| 2005-06-28 09:25:00 | AAPL | Stock | 1.3368 | 1.3411 | 1.3368 | 1.3396 | 1793820.0 |
| 2005-06-28 09:30:00 | AAPL | Stock | 1.3391 | 1.3421 | 1.3325 | 1.3393 | 21568344.0 |
| 2005-06-28 09:35:00 | AAPL | Stock | 1.3393 | 1.3414 | 1.3304 | 1.3332 | 16892120.0 |
| 2005-06-28 09:40:00 | AAPL | Stock | 1.3339 | 1.3425 | 1.3332 | 1.3382 | 16220288.0 |
| 2005-06-28 09:45:00 | AAPL | Stock | 1.3379 | 1.3393 | 1.3339 | 1.3368 | 12967360.0 |
| 2005-06-28 09:50:00 | AAPL | Stock | 1.3368 | 1.3371 | 1.3311 | 1.3314 | 6671672.0 |
| 2005-06-28 09:55:00 | AAPL | Stock | 1.3318 | 1.335 | 1.3311 | 1.3329 | 5880560.0 |
| 2005-06-28 10:00:00 | AAPL | Stock | 1.3332 | 1.3364 | 1.3318 | 1.3332 | 10318308.0 |
| 2005-06-28 10:05:00 | AAPL | Stock | 1.3336 | 1.3361 | 1.3336 | 1.3357 | 5413800.0 |
| 2005-06-28 10:10:00 | AAPL | Stock | 1.3357 | 1.3364 | 1.3307 | 1.3329 | 6578572.0 |
| 2005-06-28 10:15:00 | AAPL | Stock | 1.3332 | 1.3332 | 1.3275 | 1.3314 | 9676576.0 |
| 2005-06-28 10:20:00 | AAPL | Stock | 1.3314 | 1.3325 | 1.3311 | 1.3318 | 6614104.0 |
| 2005-06-28 10:25:00 | AAPL | Stock | 1.3318 | 1.3357 | 1.3318 | 1.3346 | 5547052.0 |
| 2005-06-28 10:30:00 | AAPL | Stock | 1.335 | 1.3389 | 1.335 | 1.3386 | 9189460.0 |
| 2005-06-28 10:35:00 | AAPL | Stock | 1.3382 | 1.3386 | 1.3357 | 1.3375 | 6649496.0 |
| 2005-06-28 10:40:00 | AAPL | Stock | 1.3379 | 1.3386 | 1.3361 | 1.3364 | 4751460.0 |
| 2005-06-28 10:45:00 | AAPL | Stock | 1.3364 | 1.3364 | 1.3354 | 1.3364 | 3209948.0 |
| 2005-06-28 10:50:00 | AAPL | Stock | 1.3364 | 1.3368 | 1.3339 | 1.3339 | 3779580.0 |
| 2005-06-28 10:55:00 | AAPL | Stock | 1.3343 | 1.3343 | 1.3321 | 1.3336 | 5043752.0 |
| 2005-06-28 11:00:00 | AAPL | Stock | 1.3336 | 1.3346 | 1.3329 | 1.3339 | 2992612.0 |
| 2005-06-28 11:05:00 | AAPL | Stock | 1.3339 | 1.3357 | 1.3336 | 1.3354 | 3121356.0 |
| 2005-06-28 11:10:00 | AAPL | Stock | 1.3357 | 1.3361 | 1.3339 | 1.3343 | 1926848.0 |
| 2005-06-28 11:15:00 | AAPL | Stock | 1.3339 | 1.3343 | 1.3325 | 1.3329 | 1947848.0 |
| 2005-06-28 11:20:00 | AAPL | Stock | 1.3329 | 1.3346 | 1.3325 | 1.3346 | 3258920.0 |
| 2005-06-28 11:25:00 | AAPL | Stock | 1.3346 | 1.3354 | 1.3329 | 1.3332 | 3503332.0 |
| 2005-06-28 11:30:00 | AAPL | Stock | 1.3332 | 1.3375 | 1.3329 | 1.335 | 4029480.0 |
| 2005-06-28 11:35:00 | AAPL | Stock | 1.3354 | 1.3389 | 1.3354 | 1.3382 | 7163128.0 |
| 2005-06-28 11:40:00 | AAPL | Stock | 1.3382 | 1.3407 | 1.3379 | 1.34 | 5197836.0 |
| 2005-06-28 11:45:00 | AAPL | Stock | 1.34 | 1.3411 | 1.3375 | 1.3404 | 3789464.0 |
| 2005-06-28 11:50:00 | AAPL | Stock | 1.3404 | 1.3425 | 1.34 | 1.34 | 2870616.0 |
| 2005-06-28 11:55:00 | AAPL | Stock | 1.34 | 1.34 | 1.3382 | 1.3386 | 1866284.0 |
| 2005-06-28 12:00:00 | AAPL | Stock | 1.3382 | 1.3396 | 1.3368 | 1.3368 | 3473624.0 |
| 2005-06-28 12:05:00 | AAPL | Stock | 1.3368 | 1.3389 | 1.3368 | 1.3386 | 3641148.0 |
| 2005-06-28 12:10:00 | AAPL | Stock | 1.3386 | 1.3389 | 1.3382 | 1.3386 | 1197812.0 |
| 2005-06-28 12:15:00 | AAPL | Stock | 1.3382 | 1.3393 | 1.3379 | 1.3386 | 1992704.0 |
| 2005-06-28 12:20:00 | AAPL | Stock | 1.3382 | 1.3393 | 1.3379 | 1.3382 | 1558620.0 |
| 2005-06-28 12:25:00 | AAPL | Stock | 1.3382 | 1.3421 | 1.3357 | 1.3357 | 1760248.0 |
> showing 50 of 203,185 rows — these rows as CSV