PREVIEW / etf_5min / 2001-01-16
file: by_date/etf_5min/2001/2001-01-16.parquet size: 23 KB rows: 1,096
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-16 09:30:00 | SPY | ETF | 132.0 | 132.25 | 131.8125 | 131.8125 | 387100.0 |
| 2001-01-16 09:35:00 | SPY | ETF | 131.9688 | 131.9688 | 131.6562 | 131.6562 | 160200.0 |
| 2001-01-16 09:40:00 | SPY | ETF | 131.625 | 132.0 | 131.625 | 131.875 | 100700.0 |
| 2001-01-16 09:45:00 | SPY | ETF | 131.875 | 132.1562 | 131.8125 | 131.8125 | 42300.0 |
| 2001-01-16 09:50:00 | SPY | ETF | 131.875 | 132.0938 | 131.625 | 131.7188 | 185600.0 |
| 2001-01-16 09:55:00 | SPY | ETF | 131.6875 | 131.9688 | 131.5312 | 131.9062 | 49000.0 |
| 2001-01-16 10:00:00 | SPY | ETF | 131.9688 | 132.3125 | 131.9688 | 132.3125 | 63000.0 |
| 2001-01-16 10:05:00 | SPY | ETF | 132.3438 | 132.3438 | 132.0312 | 132.0312 | 163300.0 |
| 2001-01-16 10:10:00 | SPY | ETF | 132.0625 | 132.4688 | 132.0625 | 132.25 | 111400.0 |
| 2001-01-16 10:15:00 | SPY | ETF | 132.25 | 132.375 | 132.125 | 132.2188 | 9400.0 |
| 2001-01-16 10:20:00 | SPY | ETF | 132.0625 | 132.25 | 131.875 | 131.9688 | 59100.0 |
| 2001-01-16 10:25:00 | SPY | ETF | 131.9688 | 132.25 | 131.9688 | 132.0625 | 19300.0 |
| 2001-01-16 10:30:00 | SPY | ETF | 132.0 | 132.125 | 131.9688 | 132.0 | 14300.0 |
| 2001-01-16 10:35:00 | SPY | ETF | 131.9688 | 131.9688 | 131.75 | 131.8125 | 73600.0 |
| 2001-01-16 10:40:00 | SPY | ETF | 131.8125 | 132.125 | 131.8125 | 132.0625 | 20800.0 |
| 2001-01-16 10:45:00 | SPY | ETF | 132.0625 | 132.0938 | 131.9375 | 131.9688 | 22500.0 |
| 2001-01-16 10:50:00 | SPY | ETF | 131.9375 | 131.9688 | 131.6875 | 131.9375 | 124700.0 |
| 2001-01-16 10:55:00 | SPY | ETF | 131.9688 | 132.125 | 131.9062 | 131.9375 | 47500.0 |
| 2001-01-16 11:00:00 | SPY | ETF | 131.9375 | 132.1875 | 131.9375 | 132.0625 | 39100.0 |
| 2001-01-16 11:05:00 | SPY | ETF | 132.0938 | 132.25 | 131.8438 | 132.1875 | 16900.0 |
| 2001-01-16 11:10:00 | SPY | ETF | 132.125 | 132.2188 | 132.0 | 132.0 | 18900.0 |
| 2001-01-16 11:15:00 | SPY | ETF | 131.9375 | 132.0 | 131.8438 | 132.0 | 91200.0 |
| 2001-01-16 11:20:00 | SPY | ETF | 132.0 | 132.0 | 131.8125 | 131.8125 | 53200.0 |
| 2001-01-16 11:25:00 | SPY | ETF | 131.8125 | 132.125 | 131.8125 | 132.0625 | 51900.0 |
| 2001-01-16 11:30:00 | SPY | ETF | 132.0625 | 132.2188 | 131.9062 | 132.0938 | 12200.0 |
| 2001-01-16 11:35:00 | SPY | ETF | 131.9688 | 131.9688 | 131.7812 | 131.9688 | 67800.0 |
| 2001-01-16 11:40:00 | SPY | ETF | 131.8438 | 132.0 | 131.75 | 131.9688 | 30900.0 |
| 2001-01-16 11:45:00 | SPY | ETF | 131.875 | 132.0 | 131.875 | 132.0 | 12500.0 |
| 2001-01-16 11:50:00 | SPY | ETF | 132.0312 | 132.0938 | 132.0312 | 132.0625 | 10400.0 |
| 2001-01-16 11:55:00 | SPY | ETF | 131.9375 | 132.1562 | 131.9375 | 131.9375 | 48600.0 |
| 2001-01-16 12:00:00 | SPY | ETF | 131.875 | 132.1562 | 131.875 | 132.1562 | 10800.0 |
| 2001-01-16 12:05:00 | SPY | ETF | 132.125 | 132.125 | 131.9688 | 131.9688 | 51200.0 |
| 2001-01-16 12:10:00 | SPY | ETF | 131.875 | 131.9062 | 131.7812 | 131.8125 | 20600.0 |
| 2001-01-16 12:15:00 | SPY | ETF | 131.8125 | 131.9062 | 131.6875 | 131.875 | 60900.0 |
| 2001-01-16 12:20:00 | SPY | ETF | 131.7188 | 131.875 | 131.6562 | 131.75 | 14700.0 |
| 2001-01-16 12:25:00 | SPY | ETF | 131.7812 | 131.875 | 131.75 | 131.8125 | 6800.0 |
| 2001-01-16 12:30:00 | SPY | ETF | 131.7188 | 131.875 | 131.7188 | 131.8438 | 5200.0 |
| 2001-01-16 12:35:00 | SPY | ETF | 131.8438 | 131.9062 | 131.75 | 131.875 | 38300.0 |
| 2001-01-16 12:40:00 | SPY | ETF | 131.7812 | 131.8438 | 131.625 | 131.7188 | 17700.0 |
| 2001-01-16 12:45:00 | SPY | ETF | 131.8125 | 131.8125 | 131.6562 | 131.6875 | 16200.0 |
| 2001-01-16 12:50:00 | SPY | ETF | 131.7812 | 131.7812 | 131.5 | 131.625 | 123600.0 |
| 2001-01-16 12:55:00 | SPY | ETF | 131.5938 | 131.7188 | 131.5 | 131.6875 | 21400.0 |
| 2001-01-16 13:00:00 | SPY | ETF | 131.6875 | 131.8438 | 131.6875 | 131.8438 | 28800.0 |
| 2001-01-16 13:05:00 | SPY | ETF | 131.7812 | 131.8125 | 131.6875 | 131.8125 | 23600.0 |
| 2001-01-16 13:10:00 | SPY | ETF | 131.7812 | 132.0 | 131.75 | 132.0 | 50200.0 |
| 2001-01-16 13:15:00 | SPY | ETF | 131.9375 | 132.0 | 131.8125 | 131.875 | 130700.0 |
| 2001-01-16 13:20:00 | SPY | ETF | 131.875 | 131.9688 | 131.875 | 131.875 | 5700.0 |
| 2001-01-16 13:25:00 | SPY | ETF | 132.0 | 132.1562 | 131.9375 | 132.0 | 14500.0 |
| 2001-01-16 13:30:00 | SPY | ETF | 132.0938 | 132.3438 | 132.0938 | 132.3438 | 403400.0 |
| 2001-01-16 13:35:00 | SPY | ETF | 132.3438 | 132.3438 | 132.125 | 132.3438 | 19400.0 |
> showing 50 of 1,096 rows — these rows as CSV