PREVIEW / stock_5min / 2018-06-06
file: by_date/stock_5min/2018/2018-06-06.parquet size: 5.7 MB rows: 366,131 symbols: 2,841
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 |
|---|---|---|---|---|---|---|---|
| 2018-06-06 04:00:00 | AAPL | Stock | 48.375 | 48.375 | 48.375 | 48.375 | 440.0 |
| 2018-06-06 04:05:00 | AAPL | Stock | 48.4775 | 48.4775 | 48.4775 | 48.4775 | 1608.0 |
| 2018-06-06 04:10:00 | AAPL | Stock | 48.4725 | 48.4725 | 48.4725 | 48.4725 | 2400.0 |
| 2018-06-06 04:15:00 | AAPL | Stock | 48.475 | 48.475 | 48.4675 | 48.4675 | 3004.0 |
| 2018-06-06 04:20:00 | AAPL | Stock | 48.5325 | 48.5325 | 48.5325 | 48.5325 | 780.0 |
| 2018-06-06 04:25:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 800.0 |
| 2018-06-06 04:55:00 | AAPL | Stock | 48.455 | 48.455 | 48.455 | 48.455 | 504.0 |
| 2018-06-06 05:05:00 | AAPL | Stock | 48.445 | 48.445 | 48.445 | 48.445 | 1204.0 |
| 2018-06-06 05:10:00 | AAPL | Stock | 48.4425 | 48.45 | 48.4425 | 48.45 | 8568.0 |
| 2018-06-06 05:20:00 | AAPL | Stock | 48.45 | 48.45 | 48.45 | 48.45 | 3600.0 |
| 2018-06-06 05:25:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 1200.0 |
| 2018-06-06 05:30:00 | AAPL | Stock | 48.465 | 48.465 | 48.465 | 48.465 | 1452.0 |
| 2018-06-06 05:35:00 | AAPL | Stock | 48.4475 | 48.4475 | 48.4475 | 48.4475 | 1040.0 |
| 2018-06-06 05:45:00 | AAPL | Stock | 48.4375 | 48.4375 | 48.4375 | 48.4375 | 1692.0 |
| 2018-06-06 05:55:00 | AAPL | Stock | 48.45 | 48.45 | 48.45 | 48.45 | 1580.0 |
| 2018-06-06 06:00:00 | AAPL | Stock | 48.47 | 48.47 | 48.47 | 48.47 | 1200.0 |
| 2018-06-06 06:20:00 | AAPL | Stock | 48.47 | 48.475 | 48.4525 | 48.475 | 13704.0 |
| 2018-06-06 06:25:00 | AAPL | Stock | 48.4675 | 48.47 | 48.4375 | 48.4375 | 5600.0 |
| 2018-06-06 06:30:00 | AAPL | Stock | 48.4325 | 48.4325 | 48.4325 | 48.4325 | 800.0 |
| 2018-06-06 06:45:00 | AAPL | Stock | 48.445 | 48.445 | 48.445 | 48.445 | 400.0 |
| 2018-06-06 06:55:00 | AAPL | Stock | 48.4475 | 48.45 | 48.4475 | 48.45 | 800.0 |
| 2018-06-06 07:00:00 | AAPL | Stock | 48.4125 | 48.47 | 48.4025 | 48.415 | 16320.0 |
| 2018-06-06 07:05:00 | AAPL | Stock | 48.4125 | 48.4375 | 48.4125 | 48.4375 | 8412.0 |
| 2018-06-06 07:10:00 | AAPL | Stock | 48.435 | 48.4375 | 48.435 | 48.4375 | 8920.0 |
| 2018-06-06 07:15:00 | AAPL | Stock | 48.4375 | 48.44 | 48.425 | 48.4375 | 40976.0 |
| 2018-06-06 07:20:00 | AAPL | Stock | 48.4375 | 48.4775 | 48.4375 | 48.4775 | 27984.0 |
| 2018-06-06 07:25:00 | AAPL | Stock | 48.4775 | 48.485 | 48.475 | 48.48 | 11088.0 |
| 2018-06-06 07:30:00 | AAPL | Stock | 48.485 | 48.49 | 48.4775 | 48.4775 | 3900.0 |
| 2018-06-06 07:35:00 | AAPL | Stock | 48.48 | 48.485 | 48.48 | 48.48 | 6440.0 |
| 2018-06-06 07:40:00 | AAPL | Stock | 48.4775 | 48.485 | 48.4775 | 48.485 | 13952.0 |
| 2018-06-06 07:45:00 | AAPL | Stock | 48.4875 | 48.495 | 48.4875 | 48.49 | 4800.0 |
| 2018-06-06 07:50:00 | AAPL | Stock | 48.4975 | 48.4975 | 48.495 | 48.495 | 2400.0 |
| 2018-06-06 07:55:00 | AAPL | Stock | 48.4875 | 48.5 | 48.4875 | 48.4975 | 5744.0 |
| 2018-06-06 08:00:00 | AAPL | Stock | 48.45 | 48.5 | 48.4125 | 48.47 | 180804.0 |
| 2018-06-06 08:05:00 | AAPL | Stock | 48.46 | 48.475 | 48.46 | 48.47 | 17164.0 |
| 2018-06-06 08:10:00 | AAPL | Stock | 48.4775 | 48.4775 | 48.4575 | 48.4725 | 34848.0 |
| 2018-06-06 08:15:00 | AAPL | Stock | 48.4725 | 48.475 | 48.4675 | 48.475 | 15888.0 |
| 2018-06-06 08:20:00 | AAPL | Stock | 48.475 | 48.495 | 48.47 | 48.4825 | 69432.0 |
| 2018-06-06 08:25:00 | AAPL | Stock | 48.475 | 48.475 | 48.475 | 48.475 | 5692.0 |
| 2018-06-06 08:30:00 | AAPL | Stock | 48.465 | 48.4725 | 48.455 | 48.46 | 15880.0 |
| 2018-06-06 08:35:00 | AAPL | Stock | 48.47 | 48.475 | 48.455 | 48.455 | 10680.0 |
| 2018-06-06 08:40:00 | AAPL | Stock | 48.455 | 48.455 | 48.3275 | 48.45 | 310240.0 |
| 2018-06-06 08:45:00 | AAPL | Stock | 48.45 | 48.4625 | 48.4275 | 48.4275 | 25232.0 |
| 2018-06-06 08:50:00 | AAPL | Stock | 48.4125 | 48.4425 | 48.4125 | 48.4325 | 17616.0 |
| 2018-06-06 08:55:00 | AAPL | Stock | 48.4325 | 48.4375 | 48.415 | 48.4225 | 10044.0 |
| 2018-06-06 09:00:00 | AAPL | Stock | 48.4125 | 48.4225 | 48.38 | 48.385 | 56504.0 |
| 2018-06-06 09:05:00 | AAPL | Stock | 48.38 | 48.3875 | 48.345 | 48.365 | 69476.0 |
| 2018-06-06 09:10:00 | AAPL | Stock | 48.3625 | 48.375 | 48.3625 | 48.375 | 19828.0 |
| 2018-06-06 09:15:00 | AAPL | Stock | 48.375 | 48.3975 | 48.375 | 48.3975 | 6808.0 |
| 2018-06-06 09:20:00 | AAPL | Stock | 48.41 | 48.4125 | 48.3925 | 48.4125 | 22460.0 |
> showing 50 of 366,131 rows — these rows as CSV