PREVIEW / etf_5min / 2008-03-19
file: by_date/etf_5min/2008/2008-03-19.parquet size: 513 KB rows: 22,990
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-19 04:50:00 | SPY | ETF | 132.65 | 132.7 | 132.44 | 132.7 | 6500.0 |
| 2008-03-19 05:25:00 | SPY | ETF | 132.61 | 132.61 | 132.61 | 132.61 | 100.0 |
| 2008-03-19 05:50:00 | SPY | ETF | 132.9 | 132.9 | 132.9 | 132.9 | 100.0 |
| 2008-03-19 05:55:00 | SPY | ETF | 132.74 | 132.74 | 132.7 | 132.7 | 700.0 |
| 2008-03-19 06:00:00 | SPY | ETF | 132.65 | 132.65 | 132.65 | 132.65 | 700.0 |
| 2008-03-19 06:05:00 | SPY | ETF | 132.56 | 132.56 | 132.56 | 132.56 | 500.0 |
| 2008-03-19 06:10:00 | SPY | ETF | 132.72 | 132.72 | 132.65 | 132.65 | 200.0 |
| 2008-03-19 06:15:00 | SPY | ETF | 132.75 | 132.75 | 132.74 | 132.74 | 7100.0 |
| 2008-03-19 06:20:00 | SPY | ETF | 132.74 | 132.75 | 132.62 | 132.64 | 39600.0 |
| 2008-03-19 06:35:00 | SPY | ETF | 132.85 | 132.85 | 132.85 | 132.85 | 100.0 |
| 2008-03-19 06:40:00 | SPY | ETF | 132.92 | 132.96 | 132.89 | 132.96 | 14000.0 |
| 2008-03-19 06:45:00 | SPY | ETF | 132.87 | 132.87 | 132.8 | 132.8 | 2800.0 |
| 2008-03-19 06:50:00 | SPY | ETF | 132.73 | 132.84 | 132.71 | 132.84 | 7000.0 |
| 2008-03-19 06:55:00 | SPY | ETF | 132.84 | 132.88 | 132.8 | 132.8 | 1900.0 |
| 2008-03-19 07:00:00 | SPY | ETF | 132.76 | 132.84 | 132.51 | 132.6 | 134200.0 |
| 2008-03-19 07:05:00 | SPY | ETF | 132.57 | 132.64 | 132.4 | 132.61 | 164700.0 |
| 2008-03-19 07:10:00 | SPY | ETF | 132.61 | 132.71 | 132.58 | 132.71 | 53200.0 |
| 2008-03-19 07:15:00 | SPY | ETF | 132.66 | 132.8 | 132.62 | 132.8 | 302900.0 |
| 2008-03-19 07:20:00 | SPY | ETF | 132.78 | 132.9 | 132.72 | 132.9 | 250400.0 |
| 2008-03-19 07:25:00 | SPY | ETF | 132.81 | 133.1 | 132.81 | 133.1 | 517200.0 |
| 2008-03-19 07:30:00 | SPY | ETF | 133.1 | 133.31 | 133.04 | 133.21 | 275700.0 |
| 2008-03-19 07:35:00 | SPY | ETF | 133.2 | 133.24 | 133.17 | 133.2 | 179100.0 |
| 2008-03-19 07:40:00 | SPY | ETF | 133.21 | 133.44 | 133.18 | 133.24 | 179600.0 |
| 2008-03-19 07:45:00 | SPY | ETF | 133.24 | 133.32 | 133.16 | 133.25 | 281200.0 |
| 2008-03-19 07:50:00 | SPY | ETF | 133.28 | 133.3 | 133.19 | 133.2 | 115900.0 |
| 2008-03-19 07:55:00 | SPY | ETF | 133.19 | 133.19 | 133.04 | 133.06 | 173000.0 |
| 2008-03-19 08:00:00 | SPY | ETF | 133.06 | 133.11 | 132.95 | 133.08 | 906700.0 |
| 2008-03-19 08:05:00 | SPY | ETF | 133.08 | 133.11 | 132.88 | 132.89 | 199300.0 |
| 2008-03-19 08:10:00 | SPY | ETF | 132.9 | 133.06 | 132.88 | 133.0 | 164600.0 |
| 2008-03-19 08:15:00 | SPY | ETF | 132.98 | 133.04 | 132.94 | 132.97 | 367700.0 |
| 2008-03-19 08:20:00 | SPY | ETF | 132.97 | 133.03 | 132.9 | 132.99 | 732600.0 |
| 2008-03-19 08:25:00 | SPY | ETF | 132.97 | 133.15 | 132.93 | 133.15 | 573560.0 |
| 2008-03-19 08:30:00 | SPY | ETF | 133.12 | 133.36 | 133.06 | 133.26 | 779200.0 |
| 2008-03-19 08:35:00 | SPY | ETF | 133.28 | 133.34 | 133.19 | 133.26 | 817900.0 |
| 2008-03-19 08:40:00 | SPY | ETF | 133.26 | 133.32 | 133.25 | 133.3 | 219300.0 |
| 2008-03-19 08:45:00 | SPY | ETF | 133.32 | 133.56 | 133.31 | 133.54 | 510700.0 |
| 2008-03-19 08:50:00 | SPY | ETF | 133.55 | 133.62 | 132.95 | 133.61 | 567800.0 |
| 2008-03-19 08:55:00 | SPY | ETF | 133.61 | 133.67 | 133.56 | 133.6 | 740000.0 |
| 2008-03-19 09:00:00 | SPY | ETF | 133.61 | 133.85 | 133.59 | 133.64 | 1929683.0 |
| 2008-03-19 09:05:00 | SPY | ETF | 133.63 | 134.06 | 133.63 | 134.06 | 1419100.0 |
| 2008-03-19 09:10:00 | SPY | ETF | 134.05 | 134.4 | 134.0 | 134.4 | 3136800.0 |
| 2008-03-19 09:15:00 | SPY | ETF | 134.4 | 134.55 | 134.35 | 134.39 | 1199200.0 |
| 2008-03-19 09:20:00 | SPY | ETF | 134.38 | 134.47 | 134.35 | 134.36 | 791400.0 |
| 2008-03-19 09:25:00 | SPY | ETF | 134.36 | 134.38 | 134.1 | 134.14 | 588600.0 |
| 2008-03-19 09:30:00 | SPY | ETF | 134.14 | 134.45 | 134.03 | 134.31 | 7357003.0 |
| 2008-03-19 09:35:00 | SPY | ETF | 134.31 | 134.32 | 133.95 | 134.14 | 4525410.0 |
| 2008-03-19 09:40:00 | SPY | ETF | 134.15 | 134.49 | 134.01 | 134.48 | 5309105.0 |
| 2008-03-19 09:45:00 | SPY | ETF | 134.47 | 134.65 | 134.27 | 134.4 | 6181422.0 |
| 2008-03-19 09:50:00 | SPY | ETF | 134.39 | 134.6474 | 134.05 | 134.07 | 5162187.0 |
| 2008-03-19 09:55:00 | SPY | ETF | 134.07 | 134.55 | 133.68 | 133.76 | 6504455.0 |
> showing 50 of 22,990 rows — these rows as CSV