PREVIEW / etf_5min / 2010-05-10
file: by_date/etf_5min/2010/2010-05-10.parquet size: 929 KB rows: 38,448
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-10 04:00:00 | SPY | ETF | 115.75 | 115.75 | 115.75 | 115.75 | 1000.0 |
| 2010-05-10 04:05:00 | SPY | ETF | 115.76 | 115.76 | 115.76 | 115.76 | 300.0 |
| 2010-05-10 04:15:00 | SPY | ETF | 115.74 | 115.98 | 115.72 | 115.84 | 42958.0 |
| 2010-05-10 04:20:00 | SPY | ETF | 115.84 | 115.86 | 115.8 | 115.8 | 11350.0 |
| 2010-05-10 04:25:00 | SPY | ETF | 115.87 | 116.01 | 115.8 | 116.01 | 7951.0 |
| 2010-05-10 04:30:00 | SPY | ETF | 115.94 | 115.94 | 115.94 | 115.94 | 600.0 |
| 2010-05-10 04:35:00 | SPY | ETF | 115.84 | 115.9 | 115.84 | 115.9 | 1400.0 |
| 2010-05-10 04:40:00 | SPY | ETF | 115.85 | 115.85 | 115.84 | 115.84 | 2850.0 |
| 2010-05-10 04:45:00 | SPY | ETF | 115.82 | 115.84 | 115.82 | 115.84 | 8000.0 |
| 2010-05-10 04:50:00 | SPY | ETF | 116.0 | 116.1 | 116.0 | 116.1 | 2100.0 |
| 2010-05-10 04:55:00 | SPY | ETF | 116.29 | 116.33 | 116.21 | 116.25 | 35550.0 |
| 2010-05-10 05:00:00 | SPY | ETF | 116.23 | 116.42 | 116.23 | 116.41 | 3416.0 |
| 2010-05-10 05:05:00 | SPY | ETF | 116.35 | 116.39 | 116.3 | 116.3 | 21000.0 |
| 2010-05-10 05:10:00 | SPY | ETF | 116.3 | 116.3 | 116.3 | 116.3 | 200.0 |
| 2010-05-10 05:15:00 | SPY | ETF | 116.27 | 116.4 | 116.27 | 116.34 | 12529.0 |
| 2010-05-10 05:20:00 | SPY | ETF | 116.5 | 116.55 | 116.47 | 116.5 | 3450.0 |
| 2010-05-10 05:25:00 | SPY | ETF | 116.5 | 116.64 | 116.39 | 116.64 | 16700.0 |
| 2010-05-10 05:30:00 | SPY | ETF | 116.52 | 116.57 | 116.52 | 116.57 | 4853.0 |
| 2010-05-10 05:35:00 | SPY | ETF | 116.52 | 116.56 | 116.41 | 116.41 | 493.0 |
| 2010-05-10 05:40:00 | SPY | ETF | 116.47 | 116.47 | 116.2 | 116.2 | 22482.0 |
| 2010-05-10 05:45:00 | SPY | ETF | 116.22 | 116.29 | 116.22 | 116.27 | 7350.0 |
| 2010-05-10 05:50:00 | SPY | ETF | 116.2 | 116.2 | 116.11 | 116.11 | 6650.0 |
| 2010-05-10 05:55:00 | SPY | ETF | 116.15 | 116.24 | 116.15 | 116.23 | 20200.0 |
| 2010-05-10 06:00:00 | SPY | ETF | 116.22 | 116.23 | 116.13 | 116.15 | 86050.0 |
| 2010-05-10 06:05:00 | SPY | ETF | 116.06 | 116.06 | 115.95 | 115.98 | 15400.0 |
| 2010-05-10 06:10:00 | SPY | ETF | 115.95 | 115.99 | 115.91 | 115.96 | 4000.0 |
| 2010-05-10 06:15:00 | SPY | ETF | 115.99 | 116.05 | 115.92 | 115.92 | 18736.0 |
| 2010-05-10 06:20:00 | SPY | ETF | 115.87 | 116.0 | 115.85 | 115.97 | 104183.0 |
| 2010-05-10 06:25:00 | SPY | ETF | 115.94 | 115.98 | 115.82 | 115.89 | 114522.0 |
| 2010-05-10 06:30:00 | SPY | ETF | 115.94 | 116.1 | 115.93 | 116.01 | 27700.0 |
| 2010-05-10 06:35:00 | SPY | ETF | 115.96 | 116.03 | 115.96 | 115.96 | 20818.0 |
| 2010-05-10 06:40:00 | SPY | ETF | 116.0 | 116.2 | 116.0 | 116.19 | 68245.0 |
| 2010-05-10 06:45:00 | SPY | ETF | 116.21 | 116.21 | 116.09 | 116.11 | 49649.0 |
| 2010-05-10 06:50:00 | SPY | ETF | 116.11 | 116.11 | 115.96 | 116.05 | 176784.0 |
| 2010-05-10 06:55:00 | SPY | ETF | 116.09 | 116.19 | 115.99 | 116.06 | 84375.0 |
| 2010-05-10 07:00:00 | SPY | ETF | 116.0 | 116.15 | 115.95 | 116.15 | 294940.0 |
| 2010-05-10 07:05:00 | SPY | ETF | 116.16 | 116.32 | 116.16 | 116.32 | 261318.0 |
| 2010-05-10 07:10:00 | SPY | ETF | 116.31 | 116.44 | 116.3 | 116.36 | 285832.0 |
| 2010-05-10 07:15:00 | SPY | ETF | 116.34 | 116.45 | 116.33 | 116.44 | 401288.0 |
| 2010-05-10 07:20:00 | SPY | ETF | 116.46 | 116.49 | 116.36 | 116.41 | 142205.0 |
| 2010-05-10 07:25:00 | SPY | ETF | 116.42 | 116.66 | 116.4 | 116.56 | 745574.0 |
| 2010-05-10 07:30:00 | SPY | ETF | 116.56 | 116.69 | 116.45 | 116.65 | 484994.0 |
| 2010-05-10 07:35:00 | SPY | ETF | 116.6 | 116.6 | 116.22 | 116.32 | 294353.0 |
| 2010-05-10 07:40:00 | SPY | ETF | 116.31 | 116.42 | 116.29 | 116.33 | 240213.0 |
| 2010-05-10 07:45:00 | SPY | ETF | 116.32 | 116.35 | 116.17 | 116.25 | 358188.0 |
| 2010-05-10 07:50:00 | SPY | ETF | 116.22 | 116.27 | 116.18 | 116.22 | 249424.0 |
| 2010-05-10 07:55:00 | SPY | ETF | 116.25 | 116.27 | 116.11 | 116.21 | 564177.0 |
| 2010-05-10 08:00:00 | SPY | ETF | 116.2 | 116.5407 | 112.6 | 116.45 | 5516475.0 |
| 2010-05-10 08:05:00 | SPY | ETF | 116.27 | 116.37 | 114.17 | 116.26 | 1220447.0 |
| 2010-05-10 08:10:00 | SPY | ETF | 116.26 | 116.3 | 115.96 | 115.99 | 535976.0 |
> showing 50 of 38,448 rows — these rows as CSV