PREVIEW / etf_5min / 2007-10-05
file: by_date/etf_5min/2007/2007-10-05.parquet size: 375 KB rows: 18,741
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-05 05:55:00 | SPY | ETF | 154.38 | 154.38 | 154.38 | 154.38 | 10000.0 |
| 2007-10-05 06:05:00 | SPY | ETF | 154.5 | 154.5 | 154.5 | 154.5 | 100.0 |
| 2007-10-05 06:25:00 | SPY | ETF | 154.48 | 154.48 | 154.48 | 154.48 | 2500.0 |
| 2007-10-05 06:40:00 | SPY | ETF | 154.52 | 154.53 | 154.52 | 154.53 | 50000.0 |
| 2007-10-05 07:00:00 | SPY | ETF | 154.43 | 154.49 | 154.42 | 154.49 | 24000.0 |
| 2007-10-05 07:05:00 | SPY | ETF | 154.41 | 154.41 | 154.41 | 154.41 | 2500.0 |
| 2007-10-05 07:10:00 | SPY | ETF | 154.44 | 154.47 | 154.44 | 154.47 | 3100.0 |
| 2007-10-05 07:15:00 | SPY | ETF | 154.46 | 154.48 | 154.43 | 154.45 | 30300.0 |
| 2007-10-05 07:20:00 | SPY | ETF | 154.45 | 154.51 | 154.43 | 154.51 | 59800.0 |
| 2007-10-05 07:25:00 | SPY | ETF | 154.51 | 154.51 | 154.47 | 154.48 | 25100.0 |
| 2007-10-05 07:30:00 | SPY | ETF | 154.46 | 154.57 | 154.45 | 154.57 | 34600.0 |
| 2007-10-05 07:35:00 | SPY | ETF | 154.57 | 154.62 | 154.56 | 154.62 | 71700.0 |
| 2007-10-05 07:40:00 | SPY | ETF | 154.6 | 154.63 | 154.58 | 154.62 | 45500.0 |
| 2007-10-05 07:45:00 | SPY | ETF | 154.62 | 154.67 | 154.6 | 154.62 | 85800.0 |
| 2007-10-05 07:50:00 | SPY | ETF | 154.57 | 154.67 | 154.57 | 154.67 | 16300.0 |
| 2007-10-05 07:55:00 | SPY | ETF | 154.65 | 154.68 | 154.62 | 154.62 | 122900.0 |
| 2007-10-05 08:00:00 | SPY | ETF | 154.62 | 154.66 | 154.6 | 154.64 | 180900.0 |
| 2007-10-05 08:05:00 | SPY | ETF | 154.65 | 154.72 | 154.65 | 154.69 | 97600.0 |
| 2007-10-05 08:10:00 | SPY | ETF | 154.65 | 154.65 | 154.6 | 154.6 | 182100.0 |
| 2007-10-05 08:15:00 | SPY | ETF | 154.59 | 154.66 | 154.59 | 154.66 | 65100.0 |
| 2007-10-05 08:20:00 | SPY | ETF | 154.64 | 154.64 | 153.79 | 154.6 | 124900.0 |
| 2007-10-05 08:25:00 | SPY | ETF | 154.6 | 154.76 | 154.56 | 154.69 | 365200.0 |
| 2007-10-05 08:30:00 | SPY | ETF | 154.68 | 155.19 | 154.45 | 155.05 | 8666900.0 |
| 2007-10-05 08:35:00 | SPY | ETF | 155.05 | 155.25 | 154.97 | 155.13 | 3740600.0 |
| 2007-10-05 08:40:00 | SPY | ETF | 155.14 | 155.17 | 155.07 | 155.1 | 852900.0 |
| 2007-10-05 08:45:00 | SPY | ETF | 155.11 | 155.17 | 155.04 | 155.04 | 550300.0 |
| 2007-10-05 08:50:00 | SPY | ETF | 155.04 | 155.08 | 155.01 | 155.05 | 160500.0 |
| 2007-10-05 08:55:00 | SPY | ETF | 155.06 | 155.06 | 154.99 | 155.01 | 336000.0 |
| 2007-10-05 09:00:00 | SPY | ETF | 155.01 | 155.06 | 154.96 | 154.97 | 400300.0 |
| 2007-10-05 09:05:00 | SPY | ETF | 154.98 | 155.02 | 154.68 | 154.92 | 2385200.0 |
| 2007-10-05 09:10:00 | SPY | ETF | 154.95 | 154.98 | 154.83 | 154.97 | 693200.0 |
| 2007-10-05 09:15:00 | SPY | ETF | 154.99 | 155.01 | 154.88 | 154.98 | 418429.0 |
| 2007-10-05 09:20:00 | SPY | ETF | 154.98 | 155.06 | 154.95 | 155.06 | 259700.0 |
| 2007-10-05 09:25:00 | SPY | ETF | 155.05 | 155.08 | 155.0 | 155.02 | 208600.0 |
| 2007-10-05 09:30:00 | SPY | ETF | 155.03 | 155.14 | 154.96 | 155.07 | 2644860.0 |
| 2007-10-05 09:35:00 | SPY | ETF | 155.06 | 155.1283 | 154.95 | 155.07 | 2360717.0 |
| 2007-10-05 09:40:00 | SPY | ETF | 155.07 | 155.14 | 154.84 | 154.87 | 2125700.0 |
| 2007-10-05 09:45:00 | SPY | ETF | 154.87 | 154.89 | 154.76 | 154.82 | 1860900.0 |
| 2007-10-05 09:50:00 | SPY | ETF | 154.82 | 154.9 | 154.77 | 154.9 | 1874000.0 |
| 2007-10-05 09:55:00 | SPY | ETF | 154.9 | 154.95 | 154.81 | 154.93 | 1671800.0 |
| 2007-10-05 10:00:00 | SPY | ETF | 154.92 | 154.96 | 154.8 | 154.94 | 1408500.0 |
| 2007-10-05 10:05:00 | SPY | ETF | 154.93 | 155.06 | 154.84 | 155.05 | 1740200.0 |
| 2007-10-05 10:10:00 | SPY | ETF | 155.05 | 155.06 | 154.94 | 154.99 | 1414700.0 |
| 2007-10-05 10:15:00 | SPY | ETF | 154.99 | 155.01 | 154.9 | 154.93 | 1034400.0 |
| 2007-10-05 10:20:00 | SPY | ETF | 154.92 | 155.0 | 154.89 | 154.92 | 1397300.0 |
| 2007-10-05 10:25:00 | SPY | ETF | 154.92 | 154.925 | 154.72 | 154.74 | 970200.0 |
| 2007-10-05 10:30:00 | SPY | ETF | 154.73 | 154.77 | 154.63 | 154.74 | 2026400.0 |
| 2007-10-05 10:35:00 | SPY | ETF | 154.74 | 154.82 | 154.7 | 154.79 | 1457200.0 |
| 2007-10-05 10:40:00 | SPY | ETF | 154.79 | 154.82 | 154.7 | 154.78 | 1077600.0 |
| 2007-10-05 10:45:00 | SPY | ETF | 154.79 | 155.02 | 154.78 | 154.98 | 2510300.0 |
> showing 50 of 18,741 rows — these rows as CSV