PREVIEW / etf_5min / 2008-12-29
file: by_date/etf_5min/2008/2008-12-29.parquet size: 642 KB rows: 27,012
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-12-29 04:15:00 | SPY | ETF | 87.26 | 87.33 | 87.26 | 87.33 | 1420.0 |
| 2008-12-29 04:25:00 | SPY | ETF | 87.39 | 87.39 | 87.39 | 87.39 | 100.0 |
| 2008-12-29 04:40:00 | SPY | ETF | 87.4 | 87.4 | 87.4 | 87.4 | 100.0 |
| 2008-12-29 04:50:00 | SPY | ETF | 87.45 | 87.45 | 87.45 | 87.45 | 100.0 |
| 2008-12-29 05:20:00 | SPY | ETF | 87.5 | 87.5 | 87.5 | 87.5 | 2000.0 |
| 2008-12-29 05:25:00 | SPY | ETF | 87.47 | 87.47 | 87.47 | 87.47 | 200.0 |
| 2008-12-29 05:45:00 | SPY | ETF | 87.4 | 87.41 | 87.4 | 87.41 | 1141.0 |
| 2008-12-29 05:50:00 | SPY | ETF | 87.44 | 87.44 | 87.44 | 87.44 | 100.0 |
| 2008-12-29 05:55:00 | SPY | ETF | 87.44 | 87.44 | 87.44 | 87.44 | 100.0 |
| 2008-12-29 06:00:00 | SPY | ETF | 87.44 | 87.44 | 87.44 | 87.44 | 800.0 |
| 2008-12-29 06:20:00 | SPY | ETF | 87.5 | 87.5 | 87.5 | 87.5 | 100.0 |
| 2008-12-29 06:25:00 | SPY | ETF | 87.51 | 87.52 | 87.51 | 87.52 | 900.0 |
| 2008-12-29 06:30:00 | SPY | ETF | 87.48 | 87.53 | 87.48 | 87.53 | 485.0 |
| 2008-12-29 06:35:00 | SPY | ETF | 87.55 | 87.55 | 87.55 | 87.55 | 100.0 |
| 2008-12-29 06:45:00 | SPY | ETF | 87.52 | 87.52 | 87.52 | 87.52 | 1000.0 |
| 2008-12-29 06:50:00 | SPY | ETF | 87.5 | 87.5 | 87.45 | 87.45 | 2800.0 |
| 2008-12-29 06:55:00 | SPY | ETF | 87.44 | 87.44 | 87.39 | 87.39 | 2200.0 |
| 2008-12-29 07:00:00 | SPY | ETF | 87.38 | 87.4 | 87.34 | 87.34 | 7700.0 |
| 2008-12-29 07:05:00 | SPY | ETF | 87.34 | 87.39 | 87.34 | 87.39 | 850.0 |
| 2008-12-29 07:10:00 | SPY | ETF | 87.39 | 87.45 | 87.39 | 87.45 | 500.0 |
| 2008-12-29 07:15:00 | SPY | ETF | 87.42 | 87.42 | 87.42 | 87.42 | 1000.0 |
| 2008-12-29 07:25:00 | SPY | ETF | 87.4 | 87.41 | 87.39 | 87.39 | 6300.0 |
| 2008-12-29 07:30:00 | SPY | ETF | 87.38 | 87.4 | 87.36 | 87.36 | 19270.0 |
| 2008-12-29 07:35:00 | SPY | ETF | 87.33 | 87.33 | 87.3 | 87.3 | 3700.0 |
| 2008-12-29 07:40:00 | SPY | ETF | 87.19 | 87.27 | 87.17 | 87.27 | 7700.0 |
| 2008-12-29 07:45:00 | SPY | ETF | 87.31 | 87.31 | 87.27 | 87.31 | 23560.0 |
| 2008-12-29 07:50:00 | SPY | ETF | 87.32 | 87.33 | 87.24 | 87.24 | 1688.0 |
| 2008-12-29 07:55:00 | SPY | ETF | 87.3 | 87.32 | 87.3 | 87.31 | 11400.0 |
| 2008-12-29 08:00:00 | SPY | ETF | 87.29 | 87.58 | 87.19 | 87.19 | 127574.0 |
| 2008-12-29 08:05:00 | SPY | ETF | 87.18 | 87.21 | 87.14 | 87.18 | 167422.0 |
| 2008-12-29 08:10:00 | SPY | ETF | 87.17 | 87.29 | 87.17 | 87.29 | 124373.0 |
| 2008-12-29 08:15:00 | SPY | ETF | 87.27 | 87.27 | 87.09 | 87.19 | 206323.0 |
| 2008-12-29 08:20:00 | SPY | ETF | 87.16 | 87.24 | 87.11 | 87.2 | 117896.0 |
| 2008-12-29 08:25:00 | SPY | ETF | 87.21 | 87.27 | 87.21 | 87.26 | 99870.0 |
| 2008-12-29 08:30:00 | SPY | ETF | 87.26 | 87.28 | 87.24 | 87.25 | 63389.0 |
| 2008-12-29 08:35:00 | SPY | ETF | 87.26 | 87.27 | 87.25 | 87.26 | 10890.0 |
| 2008-12-29 08:40:00 | SPY | ETF | 87.26 | 87.31 | 87.25 | 87.28 | 132850.0 |
| 2008-12-29 08:45:00 | SPY | ETF | 87.25 | 87.25 | 87.15 | 87.19 | 71312.0 |
| 2008-12-29 08:50:00 | SPY | ETF | 87.19 | 87.26 | 87.18 | 87.25 | 93958.0 |
| 2008-12-29 08:55:00 | SPY | ETF | 87.24 | 87.26 | 87.1 | 87.1 | 61179.0 |
| 2008-12-29 09:00:00 | SPY | ETF | 87.11 | 87.17 | 87.08 | 87.11 | 32500.0 |
| 2008-12-29 09:05:00 | SPY | ETF | 87.11 | 87.23 | 87.11 | 87.21 | 107996.0 |
| 2008-12-29 09:10:00 | SPY | ETF | 87.22 | 87.25 | 87.16 | 87.18 | 83853.0 |
| 2008-12-29 09:15:00 | SPY | ETF | 87.19 | 87.26 | 87.18 | 87.21 | 54339.0 |
| 2008-12-29 09:20:00 | SPY | ETF | 87.2 | 87.27 | 87.19 | 87.27 | 99290.0 |
| 2008-12-29 09:25:00 | SPY | ETF | 87.27 | 87.27 | 87.21 | 87.23 | 85284.0 |
| 2008-12-29 09:30:00 | SPY | ETF | 87.24 | 87.33 | 87.08 | 87.08 | 1894892.0 |
| 2008-12-29 09:35:00 | SPY | ETF | 87.09 | 87.23 | 87.09 | 87.21 | 1067238.0 |
| 2008-12-29 09:40:00 | SPY | ETF | 87.22 | 87.32 | 87.11 | 87.24 | 1368120.0 |
| 2008-12-29 09:45:00 | SPY | ETF | 87.25 | 87.31 | 87.12 | 87.17 | 1570739.0 |
> showing 50 of 27,012 rows — these rows as CSV