PREVIEW / etf_5min / 2008-03-18
file: by_date/etf_5min/2008/2008-03-18.parquet size: 494 KB rows: 23,088
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-18 04:05:00 | SPY | ETF | 129.26 | 129.26 | 129.26 | 129.26 | 3000.0 |
| 2008-03-18 04:10:00 | SPY | ETF | 129.28 | 129.28 | 129.28 | 129.28 | 3000.0 |
| 2008-03-18 04:15:00 | SPY | ETF | 129.24 | 129.29 | 129.24 | 129.29 | 400.0 |
| 2008-03-18 04:20:00 | SPY | ETF | 129.28 | 129.28 | 129.19 | 129.19 | 300.0 |
| 2008-03-18 04:40:00 | SPY | ETF | 129.3 | 129.31 | 129.3 | 129.31 | 1100.0 |
| 2008-03-18 04:45:00 | SPY | ETF | 129.12 | 129.12 | 129.12 | 129.12 | 1000.0 |
| 2008-03-18 04:50:00 | SPY | ETF | 129.19 | 129.24 | 129.19 | 129.24 | 200.0 |
| 2008-03-18 04:55:00 | SPY | ETF | 129.24 | 129.26 | 129.24 | 129.26 | 1100.0 |
| 2008-03-18 05:00:00 | SPY | ETF | 129.28 | 129.4 | 129.28 | 129.4 | 500.0 |
| 2008-03-18 05:05:00 | SPY | ETF | 129.48 | 129.48 | 129.48 | 129.48 | 100.0 |
| 2008-03-18 05:15:00 | SPY | ETF | 129.56 | 129.56 | 129.56 | 129.56 | 300.0 |
| 2008-03-18 05:20:00 | SPY | ETF | 129.59 | 129.59 | 129.59 | 129.59 | 300.0 |
| 2008-03-18 05:40:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 100.0 |
| 2008-03-18 05:45:00 | SPY | ETF | 129.41 | 129.41 | 129.41 | 129.41 | 200.0 |
| 2008-03-18 05:50:00 | SPY | ETF | 129.54 | 129.54 | 129.54 | 129.54 | 3000.0 |
| 2008-03-18 06:00:00 | SPY | ETF | 129.5 | 129.5 | 129.5 | 129.5 | 3000.0 |
| 2008-03-18 06:15:00 | SPY | ETF | 129.5 | 129.51 | 129.5 | 129.51 | 7600.0 |
| 2008-03-18 06:25:00 | SPY | ETF | 129.35 | 129.44 | 129.35 | 129.44 | 11500.0 |
| 2008-03-18 06:30:00 | SPY | ETF | 129.5 | 129.6 | 129.5 | 129.6 | 49000.0 |
| 2008-03-18 06:35:00 | SPY | ETF | 129.67 | 129.73 | 129.66 | 129.7 | 20700.0 |
| 2008-03-18 06:40:00 | SPY | ETF | 129.71 | 129.71 | 129.71 | 129.71 | 1500.0 |
| 2008-03-18 06:45:00 | SPY | ETF | 129.78 | 129.78 | 129.72 | 129.72 | 500.0 |
| 2008-03-18 06:50:00 | SPY | ETF | 129.67 | 129.75 | 129.67 | 129.7 | 22500.0 |
| 2008-03-18 06:55:00 | SPY | ETF | 129.65 | 129.75 | 129.65 | 129.75 | 86500.0 |
| 2008-03-18 07:00:00 | SPY | ETF | 129.81 | 129.81 | 129.73 | 129.75 | 23200.0 |
| 2008-03-18 07:05:00 | SPY | ETF | 129.71 | 129.74 | 129.7 | 129.72 | 59300.0 |
| 2008-03-18 07:10:00 | SPY | ETF | 129.75 | 129.75 | 129.7 | 129.72 | 18600.0 |
| 2008-03-18 07:15:00 | SPY | ETF | 129.7 | 129.84 | 129.7 | 129.82 | 106700.0 |
| 2008-03-18 07:20:00 | SPY | ETF | 129.82 | 129.85 | 129.8 | 129.83 | 71600.0 |
| 2008-03-18 07:25:00 | SPY | ETF | 129.85 | 129.91 | 129.8 | 129.8 | 46400.0 |
| 2008-03-18 07:30:00 | SPY | ETF | 129.8 | 129.81 | 129.63 | 129.63 | 75400.0 |
| 2008-03-18 07:35:00 | SPY | ETF | 129.7 | 129.77 | 129.65 | 129.77 | 52800.0 |
| 2008-03-18 07:40:00 | SPY | ETF | 129.79 | 129.96 | 129.79 | 129.94 | 86600.0 |
| 2008-03-18 07:45:00 | SPY | ETF | 129.92 | 130.05 | 129.92 | 130.05 | 141900.0 |
| 2008-03-18 07:50:00 | SPY | ETF | 130.04 | 130.14 | 130.0 | 130.0 | 465500.0 |
| 2008-03-18 07:55:00 | SPY | ETF | 130.0 | 130.05 | 129.83 | 130.04 | 178500.0 |
| 2008-03-18 08:00:00 | SPY | ETF | 130.03 | 130.46 | 129.35 | 130.27 | 4100800.0 |
| 2008-03-18 08:05:00 | SPY | ETF | 130.28 | 130.28 | 129.97 | 129.98 | 418000.0 |
| 2008-03-18 08:10:00 | SPY | ETF | 129.99 | 130.38 | 129.97 | 130.25 | 717200.0 |
| 2008-03-18 08:15:00 | SPY | ETF | 130.25 | 130.49 | 130.15 | 130.43 | 1201900.0 |
| 2008-03-18 08:20:00 | SPY | ETF | 130.4 | 130.4 | 130.25 | 130.3 | 1006700.0 |
| 2008-03-18 08:25:00 | SPY | ETF | 130.3 | 130.35 | 130.19 | 130.21 | 619500.0 |
| 2008-03-18 08:30:00 | SPY | ETF | 130.2 | 130.3 | 129.77 | 130.06 | 1194000.0 |
| 2008-03-18 08:35:00 | SPY | ETF | 130.07 | 130.18 | 130.03 | 130.17 | 297600.0 |
| 2008-03-18 08:40:00 | SPY | ETF | 130.17 | 130.3 | 130.08 | 130.19 | 343300.0 |
| 2008-03-18 08:45:00 | SPY | ETF | 130.19 | 130.32 | 130.15 | 130.32 | 353000.0 |
| 2008-03-18 08:50:00 | SPY | ETF | 130.32 | 130.4 | 130.28 | 130.4 | 387900.0 |
| 2008-03-18 08:55:00 | SPY | ETF | 130.38 | 130.4 | 130.32 | 130.37 | 330000.0 |
| 2008-03-18 09:00:00 | SPY | ETF | 130.37 | 130.5 | 130.37 | 130.48 | 368500.0 |
| 2008-03-18 09:05:00 | SPY | ETF | 130.47 | 130.5 | 128.37 | 130.48 | 632700.0 |
> showing 50 of 23,088 rows — these rows as CSV