PREVIEW / etf_5min / 2008-04-07
file: by_date/etf_5min/2008/2008-04-07.parquet size: 464 KB rows: 22,496
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-07 04:15:00 | SPY | ETF | 137.97 | 138.1 | 137.97 | 138.1 | 1600.0 |
| 2008-04-07 04:20:00 | SPY | ETF | 138.15 | 138.15 | 138.15 | 138.15 | 100.0 |
| 2008-04-07 05:00:00 | SPY | ETF | 137.94 | 137.94 | 137.94 | 137.94 | 1000.0 |
| 2008-04-07 05:20:00 | SPY | ETF | 137.89 | 137.89 | 137.89 | 137.89 | 200.0 |
| 2008-04-07 05:30:00 | SPY | ETF | 137.9 | 137.9 | 137.9 | 137.9 | 500.0 |
| 2008-04-07 05:35:00 | SPY | ETF | 137.95 | 137.95 | 137.95 | 137.95 | 600.0 |
| 2008-04-07 05:40:00 | SPY | ETF | 138.07 | 138.07 | 138.07 | 138.07 | 1000.0 |
| 2008-04-07 05:50:00 | SPY | ETF | 138.08 | 138.1 | 138.08 | 138.1 | 7700.0 |
| 2008-04-07 05:55:00 | SPY | ETF | 138.09 | 138.14 | 138.09 | 138.14 | 3000.0 |
| 2008-04-07 06:00:00 | SPY | ETF | 138.08 | 138.15 | 138.08 | 138.15 | 5100.0 |
| 2008-04-07 06:20:00 | SPY | ETF | 138.08 | 138.08 | 138.08 | 138.08 | 7900.0 |
| 2008-04-07 06:25:00 | SPY | ETF | 138.02 | 138.02 | 138.0 | 138.0 | 12600.0 |
| 2008-04-07 06:50:00 | SPY | ETF | 137.9 | 137.9 | 137.9 | 137.9 | 1000.0 |
| 2008-04-07 06:55:00 | SPY | ETF | 137.93 | 137.95 | 137.93 | 137.95 | 1900.0 |
| 2008-04-07 07:00:00 | SPY | ETF | 137.95 | 138.0 | 137.92 | 137.92 | 33900.0 |
| 2008-04-07 07:05:00 | SPY | ETF | 137.92 | 137.92 | 137.83 | 137.89 | 38200.0 |
| 2008-04-07 07:10:00 | SPY | ETF | 137.86 | 137.89 | 137.85 | 137.87 | 2100.0 |
| 2008-04-07 07:15:00 | SPY | ETF | 137.92 | 138.0 | 137.89 | 137.99 | 61400.0 |
| 2008-04-07 07:20:00 | SPY | ETF | 137.9 | 137.92 | 137.87 | 137.92 | 8000.0 |
| 2008-04-07 07:25:00 | SPY | ETF | 137.95 | 137.95 | 137.89 | 137.92 | 16500.0 |
| 2008-04-07 07:30:00 | SPY | ETF | 137.92 | 137.94 | 137.92 | 137.94 | 3000.0 |
| 2008-04-07 07:35:00 | SPY | ETF | 137.99 | 138.01 | 137.97 | 138.01 | 51500.0 |
| 2008-04-07 07:40:00 | SPY | ETF | 137.97 | 137.97 | 137.94 | 137.94 | 37000.0 |
| 2008-04-07 07:45:00 | SPY | ETF | 137.9 | 137.9 | 137.85 | 137.85 | 53300.0 |
| 2008-04-07 07:50:00 | SPY | ETF | 137.85 | 137.92 | 137.85 | 137.87 | 31400.0 |
| 2008-04-07 07:55:00 | SPY | ETF | 137.87 | 138.02 | 137.87 | 138.0 | 36600.0 |
| 2008-04-07 08:00:00 | SPY | ETF | 137.99 | 138.01 | 137.71 | 137.99 | 226600.0 |
| 2008-04-07 08:05:00 | SPY | ETF | 137.98 | 138.04 | 137.97 | 138.02 | 336800.0 |
| 2008-04-07 08:10:00 | SPY | ETF | 138.02 | 138.02 | 137.98 | 137.98 | 115900.0 |
| 2008-04-07 08:15:00 | SPY | ETF | 137.99 | 138.0 | 137.97 | 137.97 | 260000.0 |
| 2008-04-07 08:20:00 | SPY | ETF | 137.98 | 138.0 | 137.97 | 137.99 | 332000.0 |
| 2008-04-07 08:25:00 | SPY | ETF | 138.0 | 138.05 | 138.0 | 138.02 | 84500.0 |
| 2008-04-07 08:30:00 | SPY | ETF | 138.02 | 138.03 | 138.0 | 138.0 | 87000.0 |
| 2008-04-07 08:35:00 | SPY | ETF | 138.0 | 138.01 | 137.91 | 137.93 | 71300.0 |
| 2008-04-07 08:40:00 | SPY | ETF | 137.94 | 138.0 | 137.93 | 137.99 | 171400.0 |
| 2008-04-07 08:45:00 | SPY | ETF | 137.99 | 138.0 | 137.98 | 137.99 | 101400.0 |
| 2008-04-07 08:50:00 | SPY | ETF | 137.98 | 137.98 | 137.35 | 137.87 | 643500.0 |
| 2008-04-07 08:55:00 | SPY | ETF | 137.87 | 137.88 | 137.83 | 137.84 | 161100.0 |
| 2008-04-07 09:00:00 | SPY | ETF | 137.84 | 137.84 | 137.72 | 137.76 | 150300.0 |
| 2008-04-07 09:05:00 | SPY | ETF | 137.77 | 137.83 | 137.75 | 137.83 | 123100.0 |
| 2008-04-07 09:10:00 | SPY | ETF | 137.84 | 137.84 | 137.82 | 137.83 | 49300.0 |
| 2008-04-07 09:15:00 | SPY | ETF | 137.83 | 137.84 | 137.82 | 137.83 | 129500.0 |
| 2008-04-07 09:20:00 | SPY | ETF | 137.85 | 137.88 | 137.82 | 137.85 | 522522.0 |
| 2008-04-07 09:25:00 | SPY | ETF | 137.85 | 137.93 | 137.85 | 137.87 | 42300.0 |
| 2008-04-07 09:30:00 | SPY | ETF | 137.87 | 138.05 | 137.74 | 137.82 | 2919152.0 |
| 2008-04-07 09:35:00 | SPY | ETF | 137.83 | 137.9601 | 137.54 | 137.67 | 3306699.0 |
| 2008-04-07 09:40:00 | SPY | ETF | 137.67 | 137.8099 | 137.56 | 137.64 | 1932885.0 |
| 2008-04-07 09:45:00 | SPY | ETF | 137.64 | 137.738 | 137.0 | 137.575 | 2582127.0 |
| 2008-04-07 09:50:00 | SPY | ETF | 137.57 | 137.81 | 137.54 | 137.76 | 2302400.0 |
| 2008-04-07 09:55:00 | SPY | ETF | 137.79 | 137.89 | 137.72 | 137.89 | 1870689.0 |
> showing 50 of 22,496 rows — these rows as CSV