PREVIEW / etf_5min / 2007-03-30
file: by_date/etf_5min/2007/2007-03-30.parquet size: 297 KB rows: 13,402
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 |
|---|---|---|---|---|---|---|---|
| 2007-03-30 06:30:00 | SPY | ETF | 141.98 | 141.98 | 141.98 | 141.98 | 4000.0 |
| 2007-03-30 06:35:00 | SPY | ETF | 141.99 | 141.99 | 141.99 | 141.99 | 1000.0 |
| 2007-03-30 06:55:00 | SPY | ETF | 142.04 | 142.04 | 142.04 | 142.04 | 1000.0 |
| 2007-03-30 07:05:00 | SPY | ETF | 142.01 | 142.01 | 142.01 | 142.01 | 400.0 |
| 2007-03-30 07:10:00 | SPY | ETF | 142.06 | 142.06 | 142.01 | 142.01 | 2700.0 |
| 2007-03-30 07:15:00 | SPY | ETF | 142.06 | 142.06 | 142.06 | 142.06 | 13300.0 |
| 2007-03-30 07:20:00 | SPY | ETF | 142.06 | 142.06 | 142.06 | 142.06 | 1000.0 |
| 2007-03-30 07:25:00 | SPY | ETF | 142.06 | 142.06 | 142.04 | 142.04 | 9000.0 |
| 2007-03-30 07:30:00 | SPY | ETF | 142.08 | 142.08 | 142.04 | 142.04 | 1600.0 |
| 2007-03-30 07:35:00 | SPY | ETF | 142.08 | 142.11 | 142.08 | 142.11 | 20700.0 |
| 2007-03-30 07:40:00 | SPY | ETF | 142.15 | 142.17 | 142.14 | 142.17 | 48500.0 |
| 2007-03-30 07:45:00 | SPY | ETF | 142.15 | 142.24 | 142.15 | 142.24 | 153100.0 |
| 2007-03-30 07:50:00 | SPY | ETF | 142.2 | 142.2 | 142.19 | 142.19 | 4000.0 |
| 2007-03-30 07:55:00 | SPY | ETF | 142.15 | 142.2 | 142.14 | 142.2 | 38500.0 |
| 2007-03-30 08:00:00 | SPY | ETF | 142.04 | 142.29 | 142.04 | 142.29 | 285900.0 |
| 2007-03-30 08:05:00 | SPY | ETF | 142.28 | 142.29 | 142.05 | 142.26 | 42100.0 |
| 2007-03-30 08:10:00 | SPY | ETF | 142.27 | 142.31 | 142.27 | 142.28 | 40800.0 |
| 2007-03-30 08:15:00 | SPY | ETF | 142.23 | 142.28 | 142.05 | 142.17 | 333000.0 |
| 2007-03-30 08:20:00 | SPY | ETF | 142.11 | 142.15 | 142.09 | 142.15 | 34200.0 |
| 2007-03-30 08:25:00 | SPY | ETF | 142.18 | 142.18 | 142.13 | 142.17 | 11100.0 |
| 2007-03-30 08:30:00 | SPY | ETF | 142.17 | 142.49 | 141.91 | 142.27 | 1943500.0 |
| 2007-03-30 08:35:00 | SPY | ETF | 142.26 | 142.42 | 142.26 | 142.37 | 105900.0 |
| 2007-03-30 08:40:00 | SPY | ETF | 142.36 | 142.43 | 142.3 | 142.33 | 244000.0 |
| 2007-03-30 08:45:00 | SPY | ETF | 142.32 | 142.33 | 142.31 | 142.33 | 65800.0 |
| 2007-03-30 08:50:00 | SPY | ETF | 142.34 | 142.36 | 142.31 | 142.34 | 39700.0 |
| 2007-03-30 08:55:00 | SPY | ETF | 142.32 | 142.32 | 142.26 | 142.31 | 20400.0 |
| 2007-03-30 09:00:00 | SPY | ETF | 142.33 | 142.34 | 142.32 | 142.34 | 64100.0 |
| 2007-03-30 09:05:00 | SPY | ETF | 142.35 | 142.42 | 142.35 | 142.4 | 146100.0 |
| 2007-03-30 09:10:00 | SPY | ETF | 142.4 | 142.41 | 142.27 | 142.3 | 83700.0 |
| 2007-03-30 09:15:00 | SPY | ETF | 142.29 | 142.34 | 142.19 | 142.24 | 204000.0 |
| 2007-03-30 09:20:00 | SPY | ETF | 142.24 | 142.3 | 142.24 | 142.3 | 1032000.0 |
| 2007-03-30 09:25:00 | SPY | ETF | 142.29 | 142.29 | 142.15 | 142.17 | 155980.0 |
| 2007-03-30 09:30:00 | SPY | ETF | 142.17 | 142.25 | 142.15 | 142.19 | 1031000.0 |
| 2007-03-30 09:35:00 | SPY | ETF | 142.19 | 142.22 | 142.12 | 142.22 | 876000.0 |
| 2007-03-30 09:40:00 | SPY | ETF | 142.22 | 142.51 | 142.17 | 142.49 | 3333039.0 |
| 2007-03-30 09:45:00 | SPY | ETF | 142.4825 | 142.84 | 142.43 | 142.6 | 6076655.0 |
| 2007-03-30 09:50:00 | SPY | ETF | 142.6 | 142.67 | 142.54 | 142.55 | 1355001.0 |
| 2007-03-30 09:55:00 | SPY | ETF | 142.54 | 142.59 | 142.4 | 142.56 | 1460900.0 |
| 2007-03-30 10:00:00 | SPY | ETF | 142.57 | 142.77 | 142.56 | 142.64 | 2974137.0 |
| 2007-03-30 10:05:00 | SPY | ETF | 142.64 | 142.7 | 142.4 | 142.49 | 2587163.0 |
| 2007-03-30 10:10:00 | SPY | ETF | 142.49 | 142.59 | 142.41 | 142.47 | 1129793.0 |
| 2007-03-30 10:15:00 | SPY | ETF | 142.5 | 142.55 | 142.4 | 142.4 | 676400.0 |
| 2007-03-30 10:20:00 | SPY | ETF | 142.4 | 142.41 | 142.33 | 142.34 | 762600.0 |
| 2007-03-30 10:25:00 | SPY | ETF | 142.35 | 142.43 | 142.34 | 142.4 | 778300.0 |
| 2007-03-30 10:30:00 | SPY | ETF | 142.4 | 142.4 | 142.19 | 142.36 | 916900.0 |
| 2007-03-30 10:35:00 | SPY | ETF | 142.36 | 142.47 | 142.33 | 142.34 | 765600.0 |
| 2007-03-30 10:40:00 | SPY | ETF | 142.34 | 142.39 | 142.3 | 142.31 | 1427502.0 |
| 2007-03-30 10:45:00 | SPY | ETF | 142.3 | 142.35 | 142.23 | 142.33 | 885600.0 |
| 2007-03-30 10:50:00 | SPY | ETF | 142.33 | 142.35 | 142.27 | 142.31 | 534800.0 |
| 2007-03-30 10:55:00 | SPY | ETF | 142.31 | 142.4 | 142.25 | 142.37 | 824100.0 |
> showing 50 of 13,402 rows — these rows as CSV