PREVIEW / etf_5min / 2005-09-16
file: by_date/etf_5min/2005/2005-09-16.parquet size: 121 KB rows: 6,893
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-09-16 07:00:00 | SPY | ETF | 123.1 | 123.1 | 123.1 | 123.1 | 100.0 |
| 2005-09-16 07:05:00 | SPY | ETF | 123.1 | 123.1 | 123.09 | 123.09 | 700.0 |
| 2005-09-16 07:10:00 | SPY | ETF | 123.05 | 123.09 | 123.05 | 123.09 | 139500.0 |
| 2005-09-16 07:15:00 | SPY | ETF | 123.1 | 123.11 | 123.07 | 123.07 | 9900.0 |
| 2005-09-16 07:20:00 | SPY | ETF | 123.06 | 123.1 | 123.06 | 123.08 | 131700.0 |
| 2005-09-16 07:30:00 | SPY | ETF | 123.13 | 123.15 | 123.13 | 123.15 | 300.0 |
| 2005-09-16 07:35:00 | SPY | ETF | 123.2 | 123.28 | 123.2 | 123.28 | 3100.0 |
| 2005-09-16 07:45:00 | SPY | ETF | 123.25 | 123.27 | 123.23 | 123.26 | 185800.0 |
| 2005-09-16 07:50:00 | SPY | ETF | 123.27 | 123.27 | 123.26 | 123.26 | 28200.0 |
| 2005-09-16 07:55:00 | SPY | ETF | 123.18 | 123.18 | 123.18 | 123.18 | 5200.0 |
| 2005-09-16 08:00:00 | SPY | ETF | 123.08 | 123.26 | 123.06 | 123.15 | 769700.0 |
| 2005-09-16 08:05:00 | SPY | ETF | 123.23 | 123.23 | 123.15 | 123.18 | 53500.0 |
| 2005-09-16 08:10:00 | SPY | ETF | 123.16 | 123.25 | 123.15 | 123.16 | 144200.0 |
| 2005-09-16 08:15:00 | SPY | ETF | 123.14 | 123.15 | 123.12 | 123.12 | 87200.0 |
| 2005-09-16 08:20:00 | SPY | ETF | 123.15 | 123.15 | 123.12 | 123.12 | 42200.0 |
| 2005-09-16 08:25:00 | SPY | ETF | 123.14 | 123.15 | 123.12 | 123.14 | 52700.0 |
| 2005-09-16 08:30:00 | SPY | ETF | 123.13 | 123.15 | 123.12 | 123.14 | 21000.0 |
| 2005-09-16 08:35:00 | SPY | ETF | 123.14 | 123.14 | 123.06 | 123.11 | 33800.0 |
| 2005-09-16 08:40:00 | SPY | ETF | 123.11 | 123.11 | 123.06 | 123.06 | 22200.0 |
| 2005-09-16 08:45:00 | SPY | ETF | 123.08 | 123.08 | 123.05 | 123.05 | 10500.0 |
| 2005-09-16 08:50:00 | SPY | ETF | 123.06 | 123.08 | 123.06 | 123.08 | 33400.0 |
| 2005-09-16 08:55:00 | SPY | ETF | 123.07 | 123.12 | 123.07 | 123.12 | 51300.0 |
| 2005-09-16 09:00:00 | SPY | ETF | 123.13 | 123.21 | 123.13 | 123.18 | 43700.0 |
| 2005-09-16 09:05:00 | SPY | ETF | 123.18 | 123.21 | 123.18 | 123.19 | 35700.0 |
| 2005-09-16 09:10:00 | SPY | ETF | 123.18 | 123.22 | 123.18 | 123.22 | 70100.0 |
| 2005-09-16 09:15:00 | SPY | ETF | 123.2 | 123.26 | 123.2 | 123.25 | 31800.0 |
| 2005-09-16 09:20:00 | SPY | ETF | 123.26 | 123.28 | 123.2 | 123.2 | 640000.0 |
| 2005-09-16 09:25:00 | SPY | ETF | 123.2 | 123.33 | 123.2 | 123.28 | 441300.0 |
| 2005-09-16 09:30:00 | SPY | ETF | 123.28 | 123.31 | 123.13 | 123.24 | 2734200.0 |
| 2005-09-16 09:35:00 | SPY | ETF | 123.23 | 123.31 | 123.16 | 123.17 | 1784100.0 |
| 2005-09-16 09:40:00 | SPY | ETF | 123.17 | 123.2 | 123.08 | 123.11 | 2995800.0 |
| 2005-09-16 09:45:00 | SPY | ETF | 123.11 | 123.15 | 123.03 | 123.06 | 3675900.0 |
| 2005-09-16 09:50:00 | SPY | ETF | 123.07 | 123.15 | 122.9 | 123.0 | 2636800.0 |
| 2005-09-16 09:55:00 | SPY | ETF | 123.0 | 123.12 | 122.95 | 123.06 | 1322000.0 |
| 2005-09-16 10:00:00 | SPY | ETF | 123.06 | 123.13 | 123.01 | 123.06 | 500100.0 |
| 2005-09-16 10:05:00 | SPY | ETF | 123.06 | 123.3 | 123.03 | 123.23 | 2239100.0 |
| 2005-09-16 10:10:00 | SPY | ETF | 123.24 | 123.37 | 123.22 | 123.31 | 3744400.0 |
| 2005-09-16 10:15:00 | SPY | ETF | 123.31 | 123.34 | 123.23 | 123.25 | 625400.0 |
| 2005-09-16 10:20:00 | SPY | ETF | 123.25 | 123.27 | 123.15 | 123.17 | 537800.0 |
| 2005-09-16 10:25:00 | SPY | ETF | 123.15 | 123.23 | 123.12 | 123.17 | 289400.0 |
| 2005-09-16 10:30:00 | SPY | ETF | 123.17 | 123.23 | 123.1 | 123.11 | 1058300.0 |
| 2005-09-16 10:35:00 | SPY | ETF | 123.11 | 123.23 | 123.08 | 123.21 | 870000.0 |
| 2005-09-16 10:40:00 | SPY | ETF | 123.21 | 123.26 | 123.13 | 123.22 | 915100.0 |
| 2005-09-16 10:45:00 | SPY | ETF | 123.22 | 123.24 | 123.17 | 123.21 | 348800.0 |
| 2005-09-16 10:50:00 | SPY | ETF | 123.21 | 123.26 | 123.18 | 123.23 | 1329900.0 |
| 2005-09-16 10:55:00 | SPY | ETF | 123.23 | 123.24 | 123.11 | 123.14 | 379700.0 |
| 2005-09-16 11:00:00 | SPY | ETF | 123.14 | 123.16 | 122.99 | 123.0 | 1460400.0 |
| 2005-09-16 11:05:00 | SPY | ETF | 123.0 | 123.09 | 122.99 | 123.08 | 891200.0 |
| 2005-09-16 11:10:00 | SPY | ETF | 123.08 | 123.11 | 123.03 | 123.1 | 309300.0 |
| 2005-09-16 11:15:00 | SPY | ETF | 123.1 | 123.18 | 123.07 | 123.14 | 1270000.0 |
> showing 50 of 6,893 rows — these rows as CSV