PREVIEW / etf_5min / 2011-05-17
file: by_date/etf_5min/2011/2011-05-17.parquet size: 939 KB rows: 38,411
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-17 04:00:00 | SPY | ETF | 133.09 | 133.27 | 133.09 | 133.22 | 2100.0 |
| 2011-05-17 04:10:00 | SPY | ETF | 133.28 | 133.28 | 133.28 | 133.28 | 100.0 |
| 2011-05-17 04:20:00 | SPY | ETF | 133.27 | 133.27 | 133.27 | 133.27 | 100.0 |
| 2011-05-17 04:35:00 | SPY | ETF | 133.32 | 133.35 | 133.29 | 133.35 | 400.0 |
| 2011-05-17 04:40:00 | SPY | ETF | 133.43 | 133.5 | 133.43 | 133.5 | 950.0 |
| 2011-05-17 04:45:00 | SPY | ETF | 133.49 | 133.49 | 133.49 | 133.49 | 200.0 |
| 2011-05-17 04:50:00 | SPY | ETF | 133.41 | 133.41 | 133.41 | 133.41 | 200.0 |
| 2011-05-17 04:55:00 | SPY | ETF | 133.31 | 133.31 | 133.31 | 133.31 | 100.0 |
| 2011-05-17 05:00:00 | SPY | ETF | 133.31 | 133.31 | 133.31 | 133.31 | 100.0 |
| 2011-05-17 05:05:00 | SPY | ETF | 133.39 | 133.39 | 133.39 | 133.39 | 100.0 |
| 2011-05-17 05:15:00 | SPY | ETF | 133.59 | 133.61 | 133.59 | 133.6 | 25200.0 |
| 2011-05-17 05:30:00 | SPY | ETF | 133.59 | 133.59 | 133.59 | 133.59 | 2500.0 |
| 2011-05-17 05:35:00 | SPY | ETF | 133.52 | 133.52 | 133.52 | 133.52 | 200.0 |
| 2011-05-17 05:40:00 | SPY | ETF | 133.5 | 133.5 | 133.49 | 133.49 | 4100.0 |
| 2011-05-17 05:45:00 | SPY | ETF | 133.53 | 133.59 | 133.53 | 133.54 | 8300.0 |
| 2011-05-17 05:55:00 | SPY | ETF | 133.56 | 133.56 | 133.41 | 133.44 | 3850.0 |
| 2011-05-17 06:15:00 | SPY | ETF | 133.5 | 133.6 | 133.5 | 133.6 | 900.0 |
| 2011-05-17 06:35:00 | SPY | ETF | 133.53 | 133.53 | 133.51 | 133.52 | 618.0 |
| 2011-05-17 06:40:00 | SPY | ETF | 133.51 | 133.67 | 133.51 | 133.54 | 6500.0 |
| 2011-05-17 06:45:00 | SPY | ETF | 133.58 | 133.58 | 133.58 | 133.58 | 200.0 |
| 2011-05-17 06:50:00 | SPY | ETF | 133.51 | 133.52 | 133.5 | 133.5 | 7200.0 |
| 2011-05-17 06:55:00 | SPY | ETF | 133.49 | 133.58 | 133.46 | 133.46 | 12200.0 |
| 2011-05-17 07:00:00 | SPY | ETF | 133.5 | 133.5 | 133.43 | 133.46 | 30422.0 |
| 2011-05-17 07:05:00 | SPY | ETF | 133.46 | 133.46 | 133.37 | 133.39 | 2100.0 |
| 2011-05-17 07:10:00 | SPY | ETF | 133.36 | 133.42 | 133.33 | 133.37 | 65400.0 |
| 2011-05-17 07:15:00 | SPY | ETF | 133.36 | 133.37 | 133.32 | 133.37 | 22600.0 |
| 2011-05-17 07:20:00 | SPY | ETF | 133.36 | 133.38 | 133.36 | 133.37 | 7418.0 |
| 2011-05-17 07:25:00 | SPY | ETF | 133.36 | 133.4 | 133.35 | 133.35 | 7800.0 |
| 2011-05-17 07:30:00 | SPY | ETF | 133.33 | 133.33 | 133.26 | 133.3 | 50473.0 |
| 2011-05-17 07:35:00 | SPY | ETF | 133.29 | 133.32 | 133.21 | 133.23 | 18600.0 |
| 2011-05-17 07:40:00 | SPY | ETF | 133.21 | 133.23 | 133.18 | 133.21 | 68840.0 |
| 2011-05-17 07:45:00 | SPY | ETF | 133.22 | 133.36 | 133.15 | 133.21 | 107630.0 |
| 2011-05-17 07:50:00 | SPY | ETF | 133.22 | 133.25 | 133.15 | 133.21 | 155280.0 |
| 2011-05-17 07:55:00 | SPY | ETF | 133.26 | 133.27 | 133.18 | 133.2 | 8302.0 |
| 2011-05-17 08:00:00 | SPY | ETF | 133.16 | 133.37 | 133.16 | 133.18 | 146176.0 |
| 2011-05-17 08:05:00 | SPY | ETF | 133.16 | 133.22 | 133.14 | 133.18 | 21876.0 |
| 2011-05-17 08:10:00 | SPY | ETF | 133.16 | 133.22 | 133.07 | 133.09 | 154743.0 |
| 2011-05-17 08:15:00 | SPY | ETF | 133.06 | 133.14 | 133.04 | 133.11 | 97094.0 |
| 2011-05-17 08:20:00 | SPY | ETF | 133.11 | 133.11 | 133.05 | 133.08 | 35500.0 |
| 2011-05-17 08:25:00 | SPY | ETF | 133.08 | 133.24 | 133.07 | 133.2 | 61151.0 |
| 2011-05-17 08:30:00 | SPY | ETF | 133.16 | 133.16 | 132.86 | 132.9 | 416216.0 |
| 2011-05-17 08:35:00 | SPY | ETF | 132.92 | 132.98 | 132.84 | 132.97 | 198400.0 |
| 2011-05-17 08:40:00 | SPY | ETF | 132.96 | 133.08 | 132.95 | 133.03 | 407369.0 |
| 2011-05-17 08:45:00 | SPY | ETF | 133.03 | 133.05 | 132.95 | 132.97 | 90893.0 |
| 2011-05-17 08:50:00 | SPY | ETF | 132.95 | 132.95 | 132.63 | 132.75 | 444595.0 |
| 2011-05-17 08:55:00 | SPY | ETF | 132.74 | 132.76 | 132.67 | 132.75 | 237926.0 |
| 2011-05-17 09:00:00 | SPY | ETF | 132.75 | 132.85 | 132.75 | 132.76 | 304132.0 |
| 2011-05-17 09:05:00 | SPY | ETF | 132.75 | 132.88 | 132.74 | 132.86 | 80315.0 |
| 2011-05-17 09:10:00 | SPY | ETF | 132.86 | 132.86 | 132.7 | 132.7 | 232709.0 |
| 2011-05-17 09:15:00 | SPY | ETF | 132.69 | 132.72 | 132.45 | 132.65 | 973821.0 |
> showing 50 of 38,411 rows — these rows as CSV