PREVIEW / etf_5min / 2011-07-11
file: by_date/etf_5min/2011/2011-07-11.parquet size: 896 KB rows: 37,030
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-07-11 04:00:00 | SPY | ETF | 133.9 | 133.9 | 133.6 | 133.66 | 3054.0 |
| 2011-07-11 04:05:00 | SPY | ETF | 133.65 | 133.65 | 133.62 | 133.62 | 838.0 |
| 2011-07-11 04:15:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 2000.0 |
| 2011-07-11 04:20:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 1000.0 |
| 2011-07-11 04:25:00 | SPY | ETF | 133.6 | 133.6 | 133.45 | 133.45 | 14800.0 |
| 2011-07-11 04:30:00 | SPY | ETF | 133.46 | 133.46 | 133.46 | 133.46 | 1000.0 |
| 2011-07-11 04:40:00 | SPY | ETF | 133.57 | 133.57 | 133.4 | 133.4 | 4200.0 |
| 2011-07-11 04:55:00 | SPY | ETF | 133.61 | 133.61 | 133.61 | 133.61 | 400.0 |
| 2011-07-11 05:00:00 | SPY | ETF | 133.49 | 133.49 | 133.49 | 133.49 | 200.0 |
| 2011-07-11 05:05:00 | SPY | ETF | 133.49 | 133.49 | 133.4 | 133.4 | 7566.0 |
| 2011-07-11 05:10:00 | SPY | ETF | 133.4 | 133.4 | 133.33 | 133.33 | 2900.0 |
| 2011-07-11 05:15:00 | SPY | ETF | 133.32 | 133.32 | 133.3 | 133.3 | 2700.0 |
| 2011-07-11 05:25:00 | SPY | ETF | 133.49 | 133.5 | 133.49 | 133.5 | 10000.0 |
| 2011-07-11 05:30:00 | SPY | ETF | 133.4 | 133.4 | 133.4 | 133.4 | 200.0 |
| 2011-07-11 05:40:00 | SPY | ETF | 133.45 | 133.45 | 133.45 | 133.45 | 200.0 |
| 2011-07-11 05:45:00 | SPY | ETF | 133.39 | 133.4 | 133.39 | 133.4 | 400.0 |
| 2011-07-11 06:00:00 | SPY | ETF | 133.4 | 133.4 | 133.3 | 133.3 | 2940.0 |
| 2011-07-11 06:05:00 | SPY | ETF | 133.39 | 133.43 | 133.39 | 133.43 | 300.0 |
| 2011-07-11 06:15:00 | SPY | ETF | 133.45 | 133.45 | 133.41 | 133.41 | 5110.0 |
| 2011-07-11 06:25:00 | SPY | ETF | 133.45 | 133.45 | 133.45 | 133.45 | 300.0 |
| 2011-07-11 06:30:00 | SPY | ETF | 133.47 | 133.47 | 133.41 | 133.41 | 2705.0 |
| 2011-07-11 06:35:00 | SPY | ETF | 133.45 | 133.45 | 133.45 | 133.45 | 800.0 |
| 2011-07-11 06:40:00 | SPY | ETF | 133.45 | 133.45 | 133.45 | 133.45 | 500.0 |
| 2011-07-11 06:45:00 | SPY | ETF | 133.46 | 133.46 | 133.32 | 133.38 | 8800.0 |
| 2011-07-11 06:55:00 | SPY | ETF | 133.37 | 133.39 | 133.33 | 133.34 | 3200.0 |
| 2011-07-11 07:00:00 | SPY | ETF | 133.33 | 133.36 | 133.19 | 133.22 | 109567.0 |
| 2011-07-11 07:05:00 | SPY | ETF | 133.22 | 133.22 | 133.12 | 133.2 | 57393.0 |
| 2011-07-11 07:10:00 | SPY | ETF | 133.2 | 133.29 | 133.17 | 133.29 | 615075.0 |
| 2011-07-11 07:15:00 | SPY | ETF | 133.26 | 133.27 | 133.22 | 133.22 | 110700.0 |
| 2011-07-11 07:20:00 | SPY | ETF | 133.27 | 133.27 | 133.16 | 133.2 | 184760.0 |
| 2011-07-11 07:25:00 | SPY | ETF | 133.23 | 133.31 | 133.2 | 133.27 | 79250.0 |
| 2011-07-11 07:30:00 | SPY | ETF | 133.27 | 133.32 | 133.26 | 133.27 | 147790.0 |
| 2011-07-11 07:35:00 | SPY | ETF | 133.27 | 133.32 | 133.18 | 133.2 | 55718.0 |
| 2011-07-11 07:40:00 | SPY | ETF | 133.2 | 133.25 | 133.15 | 133.2 | 95208.0 |
| 2011-07-11 07:45:00 | SPY | ETF | 133.2 | 133.2 | 132.95 | 132.96 | 147794.0 |
| 2011-07-11 07:50:00 | SPY | ETF | 132.95 | 133.06 | 132.95 | 132.97 | 173388.0 |
| 2011-07-11 07:55:00 | SPY | ETF | 133.01 | 133.03 | 132.85 | 132.94 | 140930.0 |
| 2011-07-11 08:00:00 | SPY | ETF | 132.94 | 132.98 | 132.9 | 132.92 | 252145.0 |
| 2011-07-11 08:05:00 | SPY | ETF | 133.24 | 133.24 | 132.87 | 132.88 | 947950.0 |
| 2011-07-11 08:10:00 | SPY | ETF | 132.88 | 132.88 | 132.7 | 132.75 | 1286143.0 |
| 2011-07-11 08:15:00 | SPY | ETF | 132.75 | 132.85 | 132.7 | 132.83 | 290373.0 |
| 2011-07-11 08:20:00 | SPY | ETF | 132.83 | 132.91 | 132.83 | 132.86 | 609200.0 |
| 2011-07-11 08:25:00 | SPY | ETF | 132.87 | 132.9 | 132.69 | 132.73 | 907787.0 |
| 2011-07-11 08:30:00 | SPY | ETF | 132.73 | 132.87 | 132.72 | 132.86 | 333229.0 |
| 2011-07-11 08:35:00 | SPY | ETF | 132.86 | 133.01 | 132.84 | 132.95 | 324111.0 |
| 2011-07-11 08:40:00 | SPY | ETF | 132.97 | 133.01 | 132.6728 | 132.93 | 403504.0 |
| 2011-07-11 08:45:00 | SPY | ETF | 132.93 | 132.98 | 132.88 | 132.94 | 112805.0 |
| 2011-07-11 08:50:00 | SPY | ETF | 132.95 | 132.97 | 132.89 | 132.93 | 121228.0 |
| 2011-07-11 08:55:00 | SPY | ETF | 132.93 | 132.96 | 132.88 | 132.89 | 202285.0 |
| 2011-07-11 09:00:00 | SPY | ETF | 132.88 | 132.97 | 132.82 | 132.82 | 448776.0 |
> showing 50 of 37,030 rows — these rows as CSV