PREVIEW / etf_5min / 2008-10-06
file: by_date/etf_5min/2008/2008-10-06.parquet size: 630 KB rows: 29,902
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-10-06 04:15:00 | SPY | ETF | 107.72 | 107.75 | 107.72 | 107.75 | 700.0 |
| 2008-10-06 04:20:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 500.0 |
| 2008-10-06 04:25:00 | SPY | ETF | 107.67 | 107.67 | 107.67 | 107.67 | 100.0 |
| 2008-10-06 04:30:00 | SPY | ETF | 107.57 | 107.57 | 107.57 | 107.57 | 100.0 |
| 2008-10-06 04:35:00 | SPY | ETF | 107.57 | 107.57 | 107.57 | 107.57 | 100.0 |
| 2008-10-06 04:40:00 | SPY | ETF | 107.57 | 107.57 | 107.52 | 107.52 | 2600.0 |
| 2008-10-06 04:50:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 200.0 |
| 2008-10-06 04:55:00 | SPY | ETF | 107.31 | 107.31 | 107.31 | 107.31 | 100.0 |
| 2008-10-06 05:05:00 | SPY | ETF | 107.49 | 107.5 | 107.49 | 107.5 | 5000.0 |
| 2008-10-06 05:20:00 | SPY | ETF | 107.53 | 107.53 | 107.35 | 107.41 | 4600.0 |
| 2008-10-06 05:35:00 | SPY | ETF | 107.31 | 107.31 | 107.16 | 107.16 | 400.0 |
| 2008-10-06 05:40:00 | SPY | ETF | 107.12 | 107.14 | 107.12 | 107.14 | 1800.0 |
| 2008-10-06 05:45:00 | SPY | ETF | 107.01 | 107.01 | 106.86 | 106.86 | 600.0 |
| 2008-10-06 05:55:00 | SPY | ETF | 106.94 | 107.05 | 106.94 | 107.05 | 10000.0 |
| 2008-10-06 06:00:00 | SPY | ETF | 107.05 | 107.05 | 106.97 | 106.97 | 13000.0 |
| 2008-10-06 06:05:00 | SPY | ETF | 106.98 | 107.31 | 106.96 | 107.31 | 13100.0 |
| 2008-10-06 06:10:00 | SPY | ETF | 107.33 | 107.33 | 107.33 | 107.33 | 400.0 |
| 2008-10-06 06:15:00 | SPY | ETF | 107.57 | 107.7 | 107.57 | 107.7 | 10483.0 |
| 2008-10-06 06:20:00 | SPY | ETF | 107.6 | 107.6 | 107.51 | 107.52 | 8600.0 |
| 2008-10-06 06:25:00 | SPY | ETF | 107.6 | 107.61 | 107.5 | 107.5 | 30100.0 |
| 2008-10-06 06:30:00 | SPY | ETF | 107.58 | 107.6 | 107.58 | 107.6 | 7500.0 |
| 2008-10-06 06:35:00 | SPY | ETF | 107.6 | 107.6 | 107.6 | 107.6 | 1000.0 |
| 2008-10-06 06:40:00 | SPY | ETF | 107.65 | 107.99 | 107.65 | 107.99 | 57217.0 |
| 2008-10-06 06:45:00 | SPY | ETF | 108.04 | 108.28 | 107.92 | 107.96 | 89700.0 |
| 2008-10-06 06:50:00 | SPY | ETF | 107.98 | 107.98 | 107.69 | 107.79 | 18300.0 |
| 2008-10-06 06:55:00 | SPY | ETF | 107.67 | 107.67 | 107.56 | 107.66 | 28000.0 |
| 2008-10-06 07:00:00 | SPY | ETF | 107.75 | 107.88 | 107.6 | 107.7 | 177008.0 |
| 2008-10-06 07:05:00 | SPY | ETF | 107.7 | 107.8 | 107.62 | 107.62 | 174130.0 |
| 2008-10-06 07:10:00 | SPY | ETF | 107.65 | 107.8 | 107.6 | 107.65 | 130832.0 |
| 2008-10-06 07:15:00 | SPY | ETF | 107.65 | 107.73 | 107.34 | 107.6 | 133750.0 |
| 2008-10-06 07:20:00 | SPY | ETF | 107.57 | 107.74 | 107.52 | 107.74 | 125530.0 |
| 2008-10-06 07:25:00 | SPY | ETF | 107.72 | 107.77 | 107.67 | 107.67 | 139220.0 |
| 2008-10-06 07:30:00 | SPY | ETF | 107.68 | 107.68 | 107.62 | 107.62 | 144173.0 |
| 2008-10-06 07:35:00 | SPY | ETF | 107.65 | 107.69 | 107.38 | 107.38 | 228876.0 |
| 2008-10-06 07:40:00 | SPY | ETF | 107.45 | 107.56 | 107.24 | 107.55 | 411669.0 |
| 2008-10-06 07:45:00 | SPY | ETF | 107.58 | 107.95 | 107.5 | 107.75 | 212913.0 |
| 2008-10-06 07:50:00 | SPY | ETF | 107.68 | 108.09 | 107.68 | 107.95 | 239756.0 |
| 2008-10-06 07:55:00 | SPY | ETF | 107.97 | 108.03 | 107.77 | 107.78 | 209007.0 |
| 2008-10-06 08:00:00 | SPY | ETF | 107.78 | 108.4 | 107.08 | 107.58 | 623911.0 |
| 2008-10-06 08:05:00 | SPY | ETF | 107.64 | 108.475 | 107.5 | 107.65 | 167016.0 |
| 2008-10-06 08:10:00 | SPY | ETF | 107.67 | 108.17 | 107.65 | 108.14 | 1008711.0 |
| 2008-10-06 08:15:00 | SPY | ETF | 108.14 | 109.62 | 107.16 | 107.66 | 2533545.0 |
| 2008-10-06 08:20:00 | SPY | ETF | 107.66 | 107.93 | 107.61 | 107.81 | 365517.0 |
| 2008-10-06 08:25:00 | SPY | ETF | 107.79 | 107.9 | 107.68 | 107.79 | 166351.0 |
| 2008-10-06 08:30:00 | SPY | ETF | 107.79 | 107.87 | 107.57 | 107.72 | 507786.0 |
| 2008-10-06 08:35:00 | SPY | ETF | 107.71 | 107.89 | 107.61 | 107.83 | 369352.0 |
| 2008-10-06 08:40:00 | SPY | ETF | 107.82 | 107.85 | 107.75 | 107.83 | 463903.0 |
| 2008-10-06 08:45:00 | SPY | ETF | 107.82 | 108.05 | 107.81 | 107.84 | 568895.0 |
| 2008-10-06 08:50:00 | SPY | ETF | 107.85 | 107.86 | 107.6 | 107.6 | 140840.0 |
| 2008-10-06 08:55:00 | SPY | ETF | 107.59 | 107.69 | 107.5 | 107.69 | 406533.0 |
> showing 50 of 29,902 rows — these rows as CSV