PREVIEW / etf_5min / 2010-05-19
file: by_date/etf_5min/2010/2010-05-19.parquet size: 904 KB rows: 37,668
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-19 04:15:00 | SPY | ETF | 111.43 | 111.61 | 111.43 | 111.61 | 3100.0 |
| 2010-05-19 04:25:00 | SPY | ETF | 111.46 | 111.46 | 111.31 | 111.31 | 2100.0 |
| 2010-05-19 04:30:00 | SPY | ETF | 111.32 | 111.32 | 111.28 | 111.28 | 300.0 |
| 2010-05-19 04:35:00 | SPY | ETF | 111.26 | 111.28 | 111.26 | 111.27 | 300.0 |
| 2010-05-19 04:40:00 | SPY | ETF | 111.22 | 111.22 | 111.15 | 111.15 | 1616.0 |
| 2010-05-19 04:45:00 | SPY | ETF | 111.15 | 111.15 | 111.12 | 111.15 | 10200.0 |
| 2010-05-19 04:55:00 | SPY | ETF | 111.23 | 111.23 | 111.23 | 111.23 | 100.0 |
| 2010-05-19 05:00:00 | SPY | ETF | 111.32 | 111.35 | 111.32 | 111.35 | 200.0 |
| 2010-05-19 05:05:00 | SPY | ETF | 111.38 | 111.38 | 111.38 | 111.38 | 160.0 |
| 2010-05-19 05:10:00 | SPY | ETF | 111.3 | 111.43 | 111.3 | 111.43 | 2600.0 |
| 2010-05-19 05:15:00 | SPY | ETF | 111.4 | 111.4 | 111.4 | 111.4 | 260.0 |
| 2010-05-19 05:20:00 | SPY | ETF | 111.36 | 111.36 | 111.28 | 111.28 | 300.0 |
| 2010-05-19 05:25:00 | SPY | ETF | 111.18 | 111.25 | 111.11 | 111.12 | 13200.0 |
| 2010-05-19 05:40:00 | SPY | ETF | 111.21 | 111.22 | 111.13 | 111.13 | 9700.0 |
| 2010-05-19 05:45:00 | SPY | ETF | 111.06 | 111.06 | 111.0 | 111.0 | 10255.0 |
| 2010-05-19 05:50:00 | SPY | ETF | 111.01 | 111.11 | 111.01 | 111.11 | 4257.0 |
| 2010-05-19 05:55:00 | SPY | ETF | 111.05 | 111.05 | 111.05 | 111.05 | 2000.0 |
| 2010-05-19 06:00:00 | SPY | ETF | 111.05 | 111.07 | 111.04 | 111.04 | 2100.0 |
| 2010-05-19 06:05:00 | SPY | ETF | 111.04 | 111.09 | 111.04 | 111.09 | 5625.0 |
| 2010-05-19 06:10:00 | SPY | ETF | 111.25 | 111.26 | 111.22 | 111.24 | 6500.0 |
| 2010-05-19 06:15:00 | SPY | ETF | 111.24 | 111.25 | 111.24 | 111.25 | 5000.0 |
| 2010-05-19 06:20:00 | SPY | ETF | 111.15 | 111.17 | 111.12 | 111.13 | 2700.0 |
| 2010-05-19 06:25:00 | SPY | ETF | 111.12 | 111.16 | 111.1 | 111.1 | 21300.0 |
| 2010-05-19 06:30:00 | SPY | ETF | 111.15 | 111.16 | 111.11 | 111.16 | 10300.0 |
| 2010-05-19 06:35:00 | SPY | ETF | 111.15 | 111.18 | 111.12 | 111.18 | 3400.0 |
| 2010-05-19 06:40:00 | SPY | ETF | 111.16 | 111.32 | 111.16 | 111.32 | 6140.0 |
| 2010-05-19 06:45:00 | SPY | ETF | 111.33 | 111.35 | 111.33 | 111.33 | 16200.0 |
| 2010-05-19 06:50:00 | SPY | ETF | 111.3 | 111.38 | 111.28 | 111.38 | 5200.0 |
| 2010-05-19 06:55:00 | SPY | ETF | 111.3 | 111.31 | 111.3 | 111.3 | 41700.0 |
| 2010-05-19 07:00:00 | SPY | ETF | 111.36 | 111.62 | 111.36 | 111.62 | 312049.0 |
| 2010-05-19 07:05:00 | SPY | ETF | 111.6 | 111.63 | 111.54 | 111.58 | 247811.0 |
| 2010-05-19 07:10:00 | SPY | ETF | 111.6 | 111.7 | 111.6 | 111.65 | 138875.0 |
| 2010-05-19 07:15:00 | SPY | ETF | 111.61 | 111.61 | 111.48 | 111.49 | 87930.0 |
| 2010-05-19 07:20:00 | SPY | ETF | 111.47 | 111.47 | 111.39 | 111.47 | 91650.0 |
| 2010-05-19 07:25:00 | SPY | ETF | 111.47 | 111.65 | 111.47 | 111.62 | 167387.0 |
| 2010-05-19 07:30:00 | SPY | ETF | 111.62 | 111.62 | 111.35 | 111.35 | 63237.0 |
| 2010-05-19 07:35:00 | SPY | ETF | 111.34 | 111.5 | 111.33 | 111.42 | 39090.0 |
| 2010-05-19 07:40:00 | SPY | ETF | 111.39 | 111.43 | 111.29 | 111.39 | 54450.0 |
| 2010-05-19 07:45:00 | SPY | ETF | 111.36 | 111.52 | 111.36 | 111.5 | 101270.0 |
| 2010-05-19 07:50:00 | SPY | ETF | 111.47 | 111.52 | 111.43 | 111.44 | 204294.0 |
| 2010-05-19 07:55:00 | SPY | ETF | 111.47 | 111.63 | 111.44 | 111.63 | 291843.0 |
| 2010-05-19 08:00:00 | SPY | ETF | 111.61 | 111.7 | 111.3667 | 111.63 | 1266781.0 |
| 2010-05-19 08:05:00 | SPY | ETF | 111.62 | 111.63 | 111.5 | 111.58 | 96726.0 |
| 2010-05-19 08:10:00 | SPY | ETF | 111.56 | 112.1 | 111.55 | 112.04 | 821922.0 |
| 2010-05-19 08:15:00 | SPY | ETF | 112.04 | 112.065 | 111.83 | 112.0 | 1494357.0 |
| 2010-05-19 08:20:00 | SPY | ETF | 111.99 | 112.09 | 111.87 | 111.89 | 662664.0 |
| 2010-05-19 08:25:00 | SPY | ETF | 111.9 | 111.9 | 111.66 | 111.68 | 692837.0 |
| 2010-05-19 08:30:00 | SPY | ETF | 111.8 | 111.95 | 111.6 | 111.76 | 652649.0 |
| 2010-05-19 08:35:00 | SPY | ETF | 111.77 | 111.87 | 111.62 | 111.66 | 560389.0 |
| 2010-05-19 08:40:00 | SPY | ETF | 111.69 | 111.97 | 111.68 | 111.94 | 407031.0 |
> showing 50 of 37,668 rows — these rows as CSV