PREVIEW / etf_5min / 2010-02-16
file: by_date/etf_5min/2010/2010-02-16.parquet size: 767 KB rows: 32,384
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-02-16 04:15:00 | SPY | ETF | 108.94 | 108.98 | 108.93 | 108.96 | 8041.0 |
| 2010-02-16 04:20:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 400.0 |
| 2010-02-16 04:25:00 | SPY | ETF | 108.96 | 108.96 | 108.96 | 108.96 | 100.0 |
| 2010-02-16 04:30:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 166.0 |
| 2010-02-16 04:40:00 | SPY | ETF | 108.9 | 108.9 | 108.9 | 108.9 | 100.0 |
| 2010-02-16 04:50:00 | SPY | ETF | 108.86 | 108.86 | 108.86 | 108.86 | 100.0 |
| 2010-02-16 05:00:00 | SPY | ETF | 108.92 | 108.97 | 108.92 | 108.97 | 950.0 |
| 2010-02-16 05:05:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 500.0 |
| 2010-02-16 05:10:00 | SPY | ETF | 108.94 | 108.94 | 108.94 | 108.94 | 3100.0 |
| 2010-02-16 05:20:00 | SPY | ETF | 108.92 | 108.92 | 108.91 | 108.91 | 4200.0 |
| 2010-02-16 05:25:00 | SPY | ETF | 108.86 | 108.86 | 108.86 | 108.86 | 100.0 |
| 2010-02-16 05:35:00 | SPY | ETF | 108.92 | 108.92 | 108.92 | 108.92 | 100.0 |
| 2010-02-16 05:40:00 | SPY | ETF | 108.89 | 108.89 | 108.89 | 108.89 | 3000.0 |
| 2010-02-16 05:45:00 | SPY | ETF | 108.84 | 108.84 | 108.84 | 108.84 | 1000.0 |
| 2010-02-16 05:50:00 | SPY | ETF | 108.82 | 108.83 | 108.82 | 108.83 | 2900.0 |
| 2010-02-16 05:55:00 | SPY | ETF | 108.87 | 108.87 | 108.87 | 108.87 | 2900.0 |
| 2010-02-16 06:05:00 | SPY | ETF | 108.82 | 108.83 | 108.8 | 108.82 | 17000.0 |
| 2010-02-16 06:10:00 | SPY | ETF | 108.82 | 108.82 | 108.82 | 108.82 | 460.0 |
| 2010-02-16 06:25:00 | SPY | ETF | 108.81 | 108.83 | 108.78 | 108.83 | 24200.0 |
| 2010-02-16 06:35:00 | SPY | ETF | 108.89 | 108.89 | 108.84 | 108.84 | 200.0 |
| 2010-02-16 06:45:00 | SPY | ETF | 108.86 | 108.86 | 108.82 | 108.82 | 11000.0 |
| 2010-02-16 06:50:00 | SPY | ETF | 108.82 | 108.82 | 108.82 | 108.82 | 14100.0 |
| 2010-02-16 06:55:00 | SPY | ETF | 108.85 | 108.85 | 108.82 | 108.83 | 15500.0 |
| 2010-02-16 07:00:00 | SPY | ETF | 108.81 | 108.89 | 108.81 | 108.83 | 271900.0 |
| 2010-02-16 07:05:00 | SPY | ETF | 108.83 | 108.84 | 108.74 | 108.75 | 87250.0 |
| 2010-02-16 07:10:00 | SPY | ETF | 108.71 | 108.71 | 108.61 | 108.62 | 51535.0 |
| 2010-02-16 07:15:00 | SPY | ETF | 108.63 | 108.64 | 108.54 | 108.61 | 134110.0 |
| 2010-02-16 07:20:00 | SPY | ETF | 108.61 | 108.62 | 108.59 | 108.6 | 333850.0 |
| 2010-02-16 07:25:00 | SPY | ETF | 108.58 | 108.62 | 108.55 | 108.62 | 124500.0 |
| 2010-02-16 07:30:00 | SPY | ETF | 108.62 | 108.63 | 108.53 | 108.57 | 87675.0 |
| 2010-02-16 07:35:00 | SPY | ETF | 108.58 | 108.6 | 108.45 | 108.5 | 114420.0 |
| 2010-02-16 07:40:00 | SPY | ETF | 108.52 | 108.6 | 108.5 | 108.5 | 62500.0 |
| 2010-02-16 07:45:00 | SPY | ETF | 108.51 | 108.59 | 108.51 | 108.57 | 15900.0 |
| 2010-02-16 07:50:00 | SPY | ETF | 108.58 | 108.64 | 108.57 | 108.64 | 11800.0 |
| 2010-02-16 07:55:00 | SPY | ETF | 108.64 | 108.65 | 108.59 | 108.59 | 20111.0 |
| 2010-02-16 08:00:00 | SPY | ETF | 108.572 | 108.72 | 108.56 | 108.67 | 1054708.0 |
| 2010-02-16 08:05:00 | SPY | ETF | 108.55 | 108.71 | 108.4424 | 108.7 | 184150.0 |
| 2010-02-16 08:10:00 | SPY | ETF | 108.7 | 109.0 | 108.65 | 108.69 | 46010.0 |
| 2010-02-16 08:15:00 | SPY | ETF | 108.69 | 108.73 | 108.68 | 108.7 | 166354.0 |
| 2010-02-16 08:20:00 | SPY | ETF | 108.69 | 108.76 | 108.69 | 108.75 | 44394.0 |
| 2010-02-16 08:25:00 | SPY | ETF | 108.74 | 108.91 | 108.74 | 108.88 | 970736.0 |
| 2010-02-16 08:30:00 | SPY | ETF | 108.89 | 108.89 | 108.76 | 108.77 | 390440.0 |
| 2010-02-16 08:35:00 | SPY | ETF | 108.78 | 108.83 | 108.74 | 108.74 | 308799.0 |
| 2010-02-16 08:40:00 | SPY | ETF | 108.73 | 108.79 | 107.87 | 108.75 | 190232.0 |
| 2010-02-16 08:45:00 | SPY | ETF | 108.74 | 108.89 | 108.74 | 108.87 | 574140.0 |
| 2010-02-16 08:50:00 | SPY | ETF | 108.85 | 108.91 | 108.25 | 108.9 | 231204.0 |
| 2010-02-16 08:55:00 | SPY | ETF | 108.89 | 108.95 | 108.86 | 108.86 | 124471.0 |
| 2010-02-16 09:00:00 | SPY | ETF | 108.87 | 109.05 | 108.87 | 109.04 | 731972.0 |
| 2010-02-16 09:05:00 | SPY | ETF | 109.03 | 109.1 | 109.0 | 109.0 | 493384.0 |
| 2010-02-16 09:10:00 | SPY | ETF | 109.0 | 109.04 | 108.95 | 108.95 | 242995.0 |
> showing 50 of 32,384 rows — these rows as CSV