PREVIEW / etf_5min / 2010-11-18
file: by_date/etf_5min/2010/2010-11-18.parquet size: 829 KB rows: 35,079
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-11-18 04:00:00 | SPY | ETF | 118.75 | 119.51 | 118.75 | 119.5 | 21908.0 |
| 2010-11-18 04:05:00 | SPY | ETF | 119.43 | 119.43 | 119.43 | 119.43 | 130.0 |
| 2010-11-18 04:10:00 | SPY | ETF | 119.46 | 119.47 | 119.46 | 119.47 | 7400.0 |
| 2010-11-18 04:15:00 | SPY | ETF | 119.44 | 119.44 | 119.44 | 119.44 | 100.0 |
| 2010-11-18 04:25:00 | SPY | ETF | 119.43 | 119.43 | 119.4 | 119.4 | 19870.0 |
| 2010-11-18 04:35:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 250.0 |
| 2010-11-18 04:50:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 100.0 |
| 2010-11-18 04:55:00 | SPY | ETF | 119.48 | 119.48 | 119.48 | 119.48 | 1500.0 |
| 2010-11-18 05:00:00 | SPY | ETF | 119.5 | 119.5 | 119.42 | 119.42 | 1400.0 |
| 2010-11-18 05:20:00 | SPY | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 2000.0 |
| 2010-11-18 05:30:00 | SPY | ETF | 119.45 | 119.45 | 119.44 | 119.44 | 1250.0 |
| 2010-11-18 05:35:00 | SPY | ETF | 119.47 | 119.51 | 119.47 | 119.51 | 1000.0 |
| 2010-11-18 05:45:00 | SPY | ETF | 119.48 | 119.48 | 119.48 | 119.48 | 300.0 |
| 2010-11-18 05:50:00 | SPY | ETF | 119.5 | 119.5 | 119.5 | 119.5 | 200.0 |
| 2010-11-18 06:00:00 | SPY | ETF | 119.45 | 119.53 | 119.45 | 119.53 | 1900.0 |
| 2010-11-18 06:05:00 | SPY | ETF | 119.53 | 119.53 | 119.53 | 119.53 | 4300.0 |
| 2010-11-18 06:10:00 | SPY | ETF | 119.49 | 119.52 | 119.49 | 119.52 | 600.0 |
| 2010-11-18 06:15:00 | SPY | ETF | 119.5 | 119.5 | 119.5 | 119.5 | 1000.0 |
| 2010-11-18 06:30:00 | SPY | ETF | 119.49 | 119.49 | 119.49 | 119.49 | 200.0 |
| 2010-11-18 06:35:00 | SPY | ETF | 119.52 | 119.59 | 119.52 | 119.59 | 2900.0 |
| 2010-11-18 06:40:00 | SPY | ETF | 119.58 | 119.63 | 119.58 | 119.62 | 4700.0 |
| 2010-11-18 06:45:00 | SPY | ETF | 119.56 | 119.6 | 119.56 | 119.6 | 12600.0 |
| 2010-11-18 06:50:00 | SPY | ETF | 119.6 | 119.61 | 119.58 | 119.61 | 62500.0 |
| 2010-11-18 06:55:00 | SPY | ETF | 119.61 | 119.63 | 119.56 | 119.58 | 37044.0 |
| 2010-11-18 07:00:00 | SPY | ETF | 119.58 | 119.61 | 119.55 | 119.57 | 70800.0 |
| 2010-11-18 07:05:00 | SPY | ETF | 119.55 | 119.57 | 119.54 | 119.56 | 26085.0 |
| 2010-11-18 07:10:00 | SPY | ETF | 119.56 | 119.58 | 119.54 | 119.54 | 54960.0 |
| 2010-11-18 07:15:00 | SPY | ETF | 119.54 | 119.54 | 119.51 | 119.51 | 56250.0 |
| 2010-11-18 07:20:00 | SPY | ETF | 119.52 | 119.53 | 119.5 | 119.5 | 37500.0 |
| 2010-11-18 07:25:00 | SPY | ETF | 119.49 | 119.52 | 119.46 | 119.52 | 106115.0 |
| 2010-11-18 07:30:00 | SPY | ETF | 119.51 | 119.55 | 119.51 | 119.53 | 39800.0 |
| 2010-11-18 07:35:00 | SPY | ETF | 119.51 | 119.53 | 119.48 | 119.51 | 63800.0 |
| 2010-11-18 07:40:00 | SPY | ETF | 119.49 | 119.5 | 119.44 | 119.44 | 34000.0 |
| 2010-11-18 07:45:00 | SPY | ETF | 119.44 | 119.44 | 119.4 | 119.42 | 112875.0 |
| 2010-11-18 07:50:00 | SPY | ETF | 119.42 | 119.44 | 119.42 | 119.42 | 25454.0 |
| 2010-11-18 07:55:00 | SPY | ETF | 119.42 | 119.42 | 119.4 | 119.41 | 31300.0 |
| 2010-11-18 08:00:00 | SPY | ETF | 119.4 | 119.43 | 119.35 | 119.43 | 48097.0 |
| 2010-11-18 08:05:00 | SPY | ETF | 119.55 | 119.55 | 119.43 | 119.45 | 82170.0 |
| 2010-11-18 08:10:00 | SPY | ETF | 119.46 | 119.49 | 119.44 | 119.48 | 71918.0 |
| 2010-11-18 08:15:00 | SPY | ETF | 119.47 | 119.49 | 119.42 | 119.49 | 92656.0 |
| 2010-11-18 08:20:00 | SPY | ETF | 119.49 | 119.5 | 119.47 | 119.49 | 114446.0 |
| 2010-11-18 08:25:00 | SPY | ETF | 119.49 | 119.5 | 119.41 | 119.48 | 99833.0 |
| 2010-11-18 08:30:00 | SPY | ETF | 119.5 | 119.53 | 119.43 | 119.53 | 706109.0 |
| 2010-11-18 08:35:00 | SPY | ETF | 119.53 | 119.6 | 119.52 | 119.58 | 230252.0 |
| 2010-11-18 08:40:00 | SPY | ETF | 119.58 | 119.59 | 119.49 | 119.49 | 239233.0 |
| 2010-11-18 08:45:00 | SPY | ETF | 119.49 | 119.58 | 119.49 | 119.57 | 312834.0 |
| 2010-11-18 08:50:00 | SPY | ETF | 119.56 | 119.57 | 119.4 | 119.44 | 176574.0 |
| 2010-11-18 08:55:00 | SPY | ETF | 119.42 | 119.46 | 119.39 | 119.4 | 279581.0 |
| 2010-11-18 09:00:00 | SPY | ETF | 119.4 | 119.44 | 119.39 | 119.42 | 257706.0 |
| 2010-11-18 09:05:00 | SPY | ETF | 119.42 | 119.48 | 119.37 | 119.46 | 233147.0 |
> showing 50 of 35,079 rows — these rows as CSV