PREVIEW / etf_5min / 2008-05-02
file: by_date/etf_5min/2008/2008-05-02.parquet size: 484 KB rows: 22,349
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-05-02 05:00:00 | SPY | ETF | 141.07 | 141.07 | 141.07 | 141.07 | 100.0 |
| 2008-05-02 05:10:00 | SPY | ETF | 141.05 | 141.05 | 141.05 | 141.05 | 100.0 |
| 2008-05-02 05:15:00 | SPY | ETF | 141.07 | 141.07 | 141.07 | 141.07 | 600.0 |
| 2008-05-02 05:20:00 | SPY | ETF | 141.08 | 141.08 | 141.08 | 141.08 | 100.0 |
| 2008-05-02 05:35:00 | SPY | ETF | 141.08 | 141.08 | 141.08 | 141.08 | 5100.0 |
| 2008-05-02 05:40:00 | SPY | ETF | 141.11 | 141.11 | 141.11 | 141.11 | 10100.0 |
| 2008-05-02 05:55:00 | SPY | ETF | 141.07 | 141.07 | 141.07 | 141.07 | 100.0 |
| 2008-05-02 06:00:00 | SPY | ETF | 141.12 | 141.12 | 141.12 | 141.12 | 15000.0 |
| 2008-05-02 06:10:00 | SPY | ETF | 141.22 | 141.24 | 141.22 | 141.24 | 50000.0 |
| 2008-05-02 06:35:00 | SPY | ETF | 141.09 | 141.09 | 141.08 | 141.08 | 25000.0 |
| 2008-05-02 06:40:00 | SPY | ETF | 141.11 | 141.11 | 141.05 | 141.05 | 25100.0 |
| 2008-05-02 06:45:00 | SPY | ETF | 141.16 | 141.16 | 141.16 | 141.16 | 15000.0 |
| 2008-05-02 07:00:00 | SPY | ETF | 141.17 | 141.2 | 141.13 | 141.13 | 7200.0 |
| 2008-05-02 07:05:00 | SPY | ETF | 141.2 | 141.28 | 141.2 | 141.25 | 275900.0 |
| 2008-05-02 07:10:00 | SPY | ETF | 141.24 | 141.26 | 141.24 | 141.26 | 8000.0 |
| 2008-05-02 07:20:00 | SPY | ETF | 141.23 | 141.29 | 141.23 | 141.24 | 52157.0 |
| 2008-05-02 07:25:00 | SPY | ETF | 141.24 | 141.34 | 141.23 | 141.34 | 227404.0 |
| 2008-05-02 07:30:00 | SPY | ETF | 141.33 | 141.39 | 141.3 | 141.36 | 117629.0 |
| 2008-05-02 07:35:00 | SPY | ETF | 141.37 | 141.4 | 141.37 | 141.4 | 159701.0 |
| 2008-05-02 07:40:00 | SPY | ETF | 141.36 | 141.38 | 141.33 | 141.35 | 5700.0 |
| 2008-05-02 07:45:00 | SPY | ETF | 141.35 | 141.35 | 141.3 | 141.31 | 111700.0 |
| 2008-05-02 07:50:00 | SPY | ETF | 141.3 | 141.34 | 141.28 | 141.34 | 31800.0 |
| 2008-05-02 07:55:00 | SPY | ETF | 141.32 | 141.34 | 141.23 | 141.26 | 40930.0 |
| 2008-05-02 08:00:00 | SPY | ETF | 141.26 | 141.34 | 141.25 | 141.34 | 308511.0 |
| 2008-05-02 08:05:00 | SPY | ETF | 141.33 | 141.39 | 141.3 | 141.34 | 186025.0 |
| 2008-05-02 08:10:00 | SPY | ETF | 141.34 | 141.5 | 141.34 | 141.5 | 284640.0 |
| 2008-05-02 08:15:00 | SPY | ETF | 141.5 | 141.74 | 141.36 | 141.4 | 1961042.0 |
| 2008-05-02 08:20:00 | SPY | ETF | 141.4 | 141.4 | 141.2 | 141.21 | 641764.0 |
| 2008-05-02 08:25:00 | SPY | ETF | 141.21 | 141.58 | 141.04 | 141.58 | 882667.0 |
| 2008-05-02 08:30:00 | SPY | ETF | 141.6 | 142.51 | 141.0 | 142.3 | 6027317.0 |
| 2008-05-02 08:35:00 | SPY | ETF | 142.29 | 142.6 | 142.29 | 142.52 | 3599587.0 |
| 2008-05-02 08:40:00 | SPY | ETF | 142.52 | 142.52 | 142.37 | 142.4 | 1636368.0 |
| 2008-05-02 08:45:00 | SPY | ETF | 142.4 | 142.46 | 142.29 | 142.31 | 573094.0 |
| 2008-05-02 08:50:00 | SPY | ETF | 142.3 | 142.34 | 142.21 | 142.28 | 523045.0 |
| 2008-05-02 08:55:00 | SPY | ETF | 142.27 | 142.33 | 142.22 | 142.29 | 1421899.0 |
| 2008-05-02 09:00:00 | SPY | ETF | 142.25 | 142.26 | 142.16 | 142.21 | 507977.0 |
| 2008-05-02 09:05:00 | SPY | ETF | 142.22 | 142.41 | 142.22 | 142.37 | 386597.0 |
| 2008-05-02 09:10:00 | SPY | ETF | 142.37 | 142.38 | 142.28 | 142.36 | 401046.0 |
| 2008-05-02 09:15:00 | SPY | ETF | 142.33 | 142.34 | 142.21 | 142.24 | 193238.0 |
| 2008-05-02 09:20:00 | SPY | ETF | 142.25 | 142.31 | 142.25 | 142.31 | 246607.0 |
| 2008-05-02 09:25:00 | SPY | ETF | 142.3 | 142.33 | 142.22 | 142.33 | 154218.0 |
| 2008-05-02 09:30:00 | SPY | ETF | 142.33 | 142.37 | 142.0 | 142.06 | 5392105.0 |
| 2008-05-02 09:35:00 | SPY | ETF | 142.06 | 142.092 | 141.68 | 141.799 | 4326276.0 |
| 2008-05-02 09:40:00 | SPY | ETF | 141.79 | 141.92 | 141.72 | 141.82 | 6553331.0 |
| 2008-05-02 09:45:00 | SPY | ETF | 141.81 | 141.88 | 141.67 | 141.84 | 2808215.0 |
| 2008-05-02 09:50:00 | SPY | ETF | 141.84 | 141.93 | 141.8 | 141.82 | 2208385.0 |
| 2008-05-02 09:55:00 | SPY | ETF | 141.83 | 142.01 | 141.83 | 142.01 | 2375580.0 |
| 2008-05-02 10:00:00 | SPY | ETF | 142.01 | 142.23 | 142.01 | 142.11 | 3308402.0 |
| 2008-05-02 10:05:00 | SPY | ETF | 142.11 | 142.3 | 142.08 | 142.183 | 2585239.0 |
| 2008-05-02 10:10:00 | SPY | ETF | 142.18 | 142.2 | 142.06 | 142.0899 | 1348839.0 |
> showing 50 of 22,349 rows — these rows as CSV