PREVIEW / etf_5min / 2011-05-18
file: by_date/etf_5min/2011/2011-05-18.parquet size: 872 KB rows: 35,601
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-18 04:00:00 | SPY | ETF | 133.3 | 133.62 | 133.3 | 133.62 | 800.0 |
| 2011-05-18 04:05:00 | SPY | ETF | 133.59 | 133.59 | 133.59 | 133.59 | 300.0 |
| 2011-05-18 04:10:00 | SPY | ETF | 133.59 | 133.59 | 133.59 | 133.59 | 100.0 |
| 2011-05-18 04:25:00 | SPY | ETF | 133.52 | 133.52 | 133.52 | 133.52 | 100.0 |
| 2011-05-18 04:35:00 | SPY | ETF | 133.57 | 133.58 | 133.57 | 133.58 | 300.0 |
| 2011-05-18 04:55:00 | SPY | ETF | 133.61 | 133.63 | 133.61 | 133.63 | 200.0 |
| 2011-05-18 05:15:00 | SPY | ETF | 133.45 | 133.45 | 133.41 | 133.41 | 4250.0 |
| 2011-05-18 05:25:00 | SPY | ETF | 133.37 | 133.45 | 133.37 | 133.45 | 700.0 |
| 2011-05-18 05:30:00 | SPY | ETF | 133.42 | 133.42 | 133.42 | 133.42 | 500.0 |
| 2011-05-18 05:55:00 | SPY | ETF | 133.39 | 133.42 | 133.39 | 133.42 | 3100.0 |
| 2011-05-18 06:00:00 | SPY | ETF | 133.37 | 133.37 | 133.36 | 133.36 | 1950.0 |
| 2011-05-18 06:15:00 | SPY | ETF | 133.42 | 133.42 | 133.42 | 133.42 | 300.0 |
| 2011-05-18 06:30:00 | SPY | ETF | 133.48 | 133.5 | 133.48 | 133.5 | 400.0 |
| 2011-05-18 06:35:00 | SPY | ETF | 133.5 | 133.5 | 133.5 | 133.5 | 100.0 |
| 2011-05-18 06:50:00 | SPY | ETF | 133.4 | 133.4 | 133.34 | 133.35 | 86050.0 |
| 2011-05-18 06:55:00 | SPY | ETF | 133.35 | 133.42 | 133.35 | 133.4 | 100700.0 |
| 2011-05-18 07:00:00 | SPY | ETF | 133.35 | 133.35 | 133.31 | 133.34 | 5300.0 |
| 2011-05-18 07:05:00 | SPY | ETF | 133.39 | 133.42 | 133.31 | 133.31 | 14300.0 |
| 2011-05-18 07:10:00 | SPY | ETF | 133.35 | 133.35 | 133.35 | 133.35 | 21800.0 |
| 2011-05-18 07:15:00 | SPY | ETF | 133.4 | 133.4 | 133.35 | 133.35 | 51500.0 |
| 2011-05-18 07:20:00 | SPY | ETF | 133.35 | 133.35 | 133.31 | 133.31 | 3000.0 |
| 2011-05-18 07:25:00 | SPY | ETF | 133.33 | 133.35 | 133.28 | 133.35 | 9250.0 |
| 2011-05-18 07:30:00 | SPY | ETF | 133.35 | 133.36 | 133.32 | 133.32 | 1000.0 |
| 2011-05-18 07:35:00 | SPY | ETF | 133.31 | 133.32 | 133.18 | 133.18 | 67550.0 |
| 2011-05-18 07:40:00 | SPY | ETF | 133.21 | 133.22 | 133.19 | 133.21 | 28265.0 |
| 2011-05-18 07:45:00 | SPY | ETF | 133.22 | 133.22 | 133.11 | 133.11 | 67850.0 |
| 2011-05-18 07:50:00 | SPY | ETF | 133.12 | 133.2 | 133.12 | 133.13 | 23750.0 |
| 2011-05-18 07:55:00 | SPY | ETF | 133.17 | 133.23 | 133.17 | 133.23 | 9050.0 |
| 2011-05-18 08:00:00 | SPY | ETF | 133.22 | 133.35 | 133.11 | 133.35 | 113853.0 |
| 2011-05-18 08:05:00 | SPY | ETF | 133.17 | 133.17 | 132.96 | 133.02 | 105165.0 |
| 2011-05-18 08:10:00 | SPY | ETF | 133.03 | 133.07 | 132.99 | 133.03 | 255500.0 |
| 2011-05-18 08:15:00 | SPY | ETF | 133.07 | 133.12 | 132.98 | 133.08 | 332467.0 |
| 2011-05-18 08:20:00 | SPY | ETF | 133.07 | 133.11 | 133.03 | 133.1 | 246883.0 |
| 2011-05-18 08:25:00 | SPY | ETF | 133.09 | 133.11 | 133.04 | 133.07 | 235350.0 |
| 2011-05-18 08:30:00 | SPY | ETF | 133.05 | 133.16 | 133.04 | 133.15 | 379277.0 |
| 2011-05-18 08:35:00 | SPY | ETF | 133.15 | 133.16 | 133.09 | 133.09 | 46920.0 |
| 2011-05-18 08:40:00 | SPY | ETF | 133.09 | 133.12 | 133.03 | 133.05 | 99700.0 |
| 2011-05-18 08:45:00 | SPY | ETF | 133.05 | 133.08 | 132.99 | 133.04 | 258668.0 |
| 2011-05-18 08:50:00 | SPY | ETF | 133.05 | 133.07 | 133.01 | 133.05 | 194495.0 |
| 2011-05-18 08:55:00 | SPY | ETF | 133.05 | 133.25 | 133.05 | 133.23 | 381133.0 |
| 2011-05-18 09:00:00 | SPY | ETF | 133.22 | 133.28 | 133.19 | 133.24 | 98203.0 |
| 2011-05-18 09:05:00 | SPY | ETF | 133.22 | 133.22 | 133.14 | 133.2 | 101395.0 |
| 2011-05-18 09:10:00 | SPY | ETF | 133.21 | 133.22 | 133.16 | 133.22 | 52159.0 |
| 2011-05-18 09:15:00 | SPY | ETF | 133.23 | 133.27 | 133.22 | 133.26 | 101332.0 |
| 2011-05-18 09:20:00 | SPY | ETF | 133.24 | 133.31 | 133.22 | 133.26 | 190363.0 |
| 2011-05-18 09:25:00 | SPY | ETF | 133.28 | 133.3 | 133.24 | 133.24 | 145983.0 |
| 2011-05-18 09:30:00 | SPY | ETF | 133.24 | 133.27 | 133.01 | 133.09 | 4467192.0 |
| 2011-05-18 09:35:00 | SPY | ETF | 133.1 | 133.13 | 132.95 | 133.07 | 2610398.0 |
| 2011-05-18 09:40:00 | SPY | ETF | 133.07 | 133.32 | 133.07 | 133.3 | 2249013.0 |
| 2011-05-18 09:45:00 | SPY | ETF | 133.3 | 133.49 | 133.24 | 133.435 | 3377094.0 |
> showing 50 of 35,601 rows — these rows as CSV