PREVIEW / etf_5min / 2006-08-04
file: by_date/etf_5min/2006/2006-08-04.parquet size: 236 KB rows: 10,869
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-04 05:35:00 | SPY | ETF | 128.24 | 128.24 | 128.24 | 128.24 | 1500.0 |
| 2006-08-04 06:20:00 | SPY | ETF | 128.27 | 128.27 | 128.27 | 128.27 | 1000.0 |
| 2006-08-04 07:10:00 | SPY | ETF | 128.37 | 128.37 | 128.35 | 128.35 | 46900.0 |
| 2006-08-04 07:20:00 | SPY | ETF | 128.37 | 128.37 | 128.37 | 128.37 | 18300.0 |
| 2006-08-04 07:25:00 | SPY | ETF | 128.37 | 128.37 | 128.37 | 128.37 | 9400.0 |
| 2006-08-04 07:30:00 | SPY | ETF | 128.33 | 128.33 | 128.33 | 128.33 | 3200.0 |
| 2006-08-04 07:35:00 | SPY | ETF | 128.33 | 128.33 | 128.28 | 128.28 | 25700.0 |
| 2006-08-04 07:45:00 | SPY | ETF | 128.3 | 128.3 | 128.3 | 128.3 | 2500.0 |
| 2006-08-04 07:55:00 | SPY | ETF | 128.34 | 128.35 | 128.34 | 128.34 | 30000.0 |
| 2006-08-04 08:00:00 | SPY | ETF | 128.37 | 128.44 | 128.24 | 128.4 | 1238500.0 |
| 2006-08-04 08:05:00 | SPY | ETF | 128.39 | 128.4 | 128.35 | 128.36 | 6200.0 |
| 2006-08-04 08:10:00 | SPY | ETF | 128.35 | 128.362 | 128.29 | 128.3 | 550500.0 |
| 2006-08-04 08:15:00 | SPY | ETF | 128.3 | 128.31 | 128.27 | 128.3 | 557500.0 |
| 2006-08-04 08:20:00 | SPY | ETF | 128.28 | 128.52 | 128.27 | 128.48 | 201300.0 |
| 2006-08-04 08:25:00 | SPY | ETF | 128.49 | 128.54 | 128.39 | 128.52 | 236900.0 |
| 2006-08-04 08:30:00 | SPY | ETF | 128.53 | 129.12 | 128.5 | 129.09 | 3859000.0 |
| 2006-08-04 08:35:00 | SPY | ETF | 129.09 | 129.21 | 128.85 | 129.14 | 2377900.0 |
| 2006-08-04 08:40:00 | SPY | ETF | 129.14 | 129.44 | 129.1 | 129.44 | 2178500.0 |
| 2006-08-04 08:45:00 | SPY | ETF | 129.39 | 129.43 | 129.17 | 129.21 | 1487200.0 |
| 2006-08-04 08:50:00 | SPY | ETF | 129.21 | 129.28 | 128.94 | 129.19 | 731600.0 |
| 2006-08-04 08:55:00 | SPY | ETF | 129.19 | 129.27 | 129.17 | 129.27 | 100700.0 |
| 2006-08-04 09:00:00 | SPY | ETF | 129.27 | 129.3 | 129.17 | 129.18 | 1484500.0 |
| 2006-08-04 09:05:00 | SPY | ETF | 129.18 | 129.27 | 129.18 | 129.22 | 570800.0 |
| 2006-08-04 09:10:00 | SPY | ETF | 129.24 | 129.24 | 129.14 | 129.15 | 134100.0 |
| 2006-08-04 09:15:00 | SPY | ETF | 129.14 | 129.18 | 129.1 | 129.13 | 354300.0 |
| 2006-08-04 09:20:00 | SPY | ETF | 129.14 | 129.22 | 129.09 | 129.1 | 468900.0 |
| 2006-08-04 09:25:00 | SPY | ETF | 129.1 | 129.1 | 129.05 | 129.06 | 229200.0 |
| 2006-08-04 09:30:00 | SPY | ETF | 129.06 | 129.08 | 128.9 | 129.02 | 2795200.0 |
| 2006-08-04 09:35:00 | SPY | ETF | 129.03 | 129.19 | 128.95 | 129.17 | 1280200.0 |
| 2006-08-04 09:40:00 | SPY | ETF | 129.17 | 129.43 | 129.15 | 129.4 | 1703800.0 |
| 2006-08-04 09:45:00 | SPY | ETF | 129.4 | 129.42 | 129.18 | 129.24 | 2285700.0 |
| 2006-08-04 09:50:00 | SPY | ETF | 129.25 | 129.25 | 128.9 | 128.95 | 2118600.0 |
| 2006-08-04 09:55:00 | SPY | ETF | 128.94 | 129.0 | 128.77 | 128.95 | 2339100.0 |
| 2006-08-04 10:00:00 | SPY | ETF | 128.94 | 129.11 | 128.92 | 128.96 | 1157800.0 |
| 2006-08-04 10:05:00 | SPY | ETF | 128.97 | 129.02 | 128.74 | 128.8 | 1383100.0 |
| 2006-08-04 10:10:00 | SPY | ETF | 128.81 | 128.87 | 128.66 | 128.82 | 1818600.0 |
| 2006-08-04 10:15:00 | SPY | ETF | 128.84 | 128.88 | 128.67 | 128.8 | 1516300.0 |
| 2006-08-04 10:20:00 | SPY | ETF | 128.78 | 128.92 | 128.66 | 128.78 | 1448800.0 |
| 2006-08-04 10:25:00 | SPY | ETF | 128.79 | 128.91 | 128.75 | 128.89 | 703500.0 |
| 2006-08-04 10:30:00 | SPY | ETF | 128.87 | 129.05 | 128.84 | 129.0 | 1016700.0 |
| 2006-08-04 10:35:00 | SPY | ETF | 129.03 | 129.1 | 128.98 | 128.99 | 1325400.0 |
| 2006-08-04 10:40:00 | SPY | ETF | 128.99 | 129.0 | 128.77 | 128.83 | 580300.0 |
| 2006-08-04 10:45:00 | SPY | ETF | 128.84 | 128.95 | 128.82 | 128.88 | 884100.0 |
| 2006-08-04 10:50:00 | SPY | ETF | 128.87 | 129.0 | 128.79 | 128.92 | 430100.0 |
| 2006-08-04 10:55:00 | SPY | ETF | 128.93 | 128.97 | 128.83 | 128.87 | 756200.0 |
| 2006-08-04 11:00:00 | SPY | ETF | 128.87 | 128.92 | 128.77 | 128.79 | 805500.0 |
| 2006-08-04 11:05:00 | SPY | ETF | 128.78 | 128.92 | 128.78 | 128.8 | 360300.0 |
| 2006-08-04 11:10:00 | SPY | ETF | 128.8 | 128.81 | 128.7 | 128.8 | 491800.0 |
| 2006-08-04 11:15:00 | SPY | ETF | 128.81 | 128.88 | 128.8 | 128.85 | 398900.0 |
| 2006-08-04 11:20:00 | SPY | ETF | 128.85 | 129.03 | 128.83 | 128.99 | 835500.0 |
> showing 50 of 10,869 rows — these rows as CSV