PREVIEW / etf_5min / 2003-03-18
file: by_date/etf_5min/2003/2003-03-18.parquet size: 55 KB rows: 2,628
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-18 08:00:00 | SPY | ETF | 87.8 | 87.84 | 87.77 | 87.84 | 19000.0 |
| 2003-03-18 08:05:00 | SPY | ETF | 87.8 | 87.81 | 87.75 | 87.75 | 18100.0 |
| 2003-03-18 08:10:00 | SPY | ETF | 87.74 | 87.74 | 87.7 | 87.71 | 17600.0 |
| 2003-03-18 08:15:00 | SPY | ETF | 87.74 | 87.76 | 87.74 | 87.76 | 4000.0 |
| 2003-03-18 08:20:00 | SPY | ETF | 87.78 | 87.82 | 87.77 | 87.77 | 2800.0 |
| 2003-03-18 08:25:00 | SPY | ETF | 87.78 | 87.78 | 87.61 | 87.64 | 7000.0 |
| 2003-03-18 08:30:00 | SPY | ETF | 87.62 | 87.62 | 87.43 | 87.53 | 14700.0 |
| 2003-03-18 08:35:00 | SPY | ETF | 87.54 | 87.56 | 87.45 | 87.46 | 83400.0 |
| 2003-03-18 08:40:00 | SPY | ETF | 87.44 | 87.5 | 87.41 | 87.49 | 20100.0 |
| 2003-03-18 08:45:00 | SPY | ETF | 87.41 | 87.46 | 87.35 | 87.4 | 21000.0 |
| 2003-03-18 08:50:00 | SPY | ETF | 87.42 | 87.42 | 87.34 | 87.36 | 16700.0 |
| 2003-03-18 08:55:00 | SPY | ETF | 87.38 | 87.39 | 87.31 | 87.35 | 5400.0 |
| 2003-03-18 09:00:00 | SPY | ETF | 87.36 | 87.36 | 87.21 | 87.21 | 11100.0 |
| 2003-03-18 09:05:00 | SPY | ETF | 87.3 | 87.3 | 87.21 | 87.21 | 13400.0 |
| 2003-03-18 09:10:00 | SPY | ETF | 87.23 | 87.26 | 87.21 | 87.26 | 17000.0 |
| 2003-03-18 09:15:00 | SPY | ETF | 87.26 | 87.26 | 87.26 | 87.26 | 7200.0 |
| 2003-03-18 09:20:00 | SPY | ETF | 87.26 | 87.26 | 87.25 | 87.25 | 1100.0 |
| 2003-03-18 09:25:00 | SPY | ETF | 87.25 | 87.25 | 87.09 | 87.19 | 5600.0 |
| 2003-03-18 09:30:00 | SPY | ETF | 87.15 | 87.25 | 86.92 | 87.14 | 2703400.0 |
| 2003-03-18 09:35:00 | SPY | ETF | 87.14 | 87.25 | 86.9 | 87.01 | 1345100.0 |
| 2003-03-18 09:40:00 | SPY | ETF | 87.0 | 87.05 | 86.63 | 86.75 | 1361000.0 |
| 2003-03-18 09:45:00 | SPY | ETF | 86.75 | 86.79 | 86.56 | 86.66 | 1296200.0 |
| 2003-03-18 09:50:00 | SPY | ETF | 86.73 | 86.78 | 86.45 | 86.55 | 1336600.0 |
| 2003-03-18 09:55:00 | SPY | ETF | 86.53 | 86.65 | 86.28 | 86.33 | 1074200.0 |
| 2003-03-18 10:00:00 | SPY | ETF | 86.3 | 86.47 | 86.29 | 86.39 | 789100.0 |
| 2003-03-18 10:05:00 | SPY | ETF | 86.4 | 86.82 | 86.32 | 86.69 | 1193700.0 |
| 2003-03-18 10:10:00 | SPY | ETF | 86.74 | 86.75 | 86.41 | 86.55 | 649100.0 |
| 2003-03-18 10:15:00 | SPY | ETF | 86.56 | 86.97 | 86.54 | 86.96 | 884200.0 |
| 2003-03-18 10:20:00 | SPY | ETF | 86.97 | 87.1 | 86.8 | 86.97 | 1169000.0 |
| 2003-03-18 10:25:00 | SPY | ETF | 86.96 | 87.24 | 86.85 | 87.13 | 963500.0 |
| 2003-03-18 10:30:00 | SPY | ETF | 87.12 | 87.18 | 86.91 | 86.95 | 1223200.0 |
| 2003-03-18 10:35:00 | SPY | ETF | 86.96 | 87.08 | 86.84 | 86.97 | 609700.0 |
| 2003-03-18 10:40:00 | SPY | ETF | 86.98 | 87.13 | 86.84 | 86.92 | 555200.0 |
| 2003-03-18 10:45:00 | SPY | ETF | 86.91 | 87.09 | 86.88 | 86.94 | 557000.0 |
| 2003-03-18 10:50:00 | SPY | ETF | 86.91 | 86.99 | 86.56 | 86.7 | 562000.0 |
| 2003-03-18 10:55:00 | SPY | ETF | 86.7 | 86.76 | 86.57 | 86.71 | 630300.0 |
| 2003-03-18 11:00:00 | SPY | ETF | 86.73 | 86.82 | 86.57 | 86.8 | 509100.0 |
| 2003-03-18 11:05:00 | SPY | ETF | 86.78 | 86.93 | 86.73 | 86.76 | 249000.0 |
| 2003-03-18 11:10:00 | SPY | ETF | 86.76 | 86.8 | 86.61 | 86.74 | 232900.0 |
| 2003-03-18 11:15:00 | SPY | ETF | 86.7 | 86.74 | 86.54 | 86.64 | 244700.0 |
| 2003-03-18 11:20:00 | SPY | ETF | 86.64 | 86.82 | 86.58 | 86.71 | 264600.0 |
| 2003-03-18 11:25:00 | SPY | ETF | 86.72 | 86.87 | 86.7 | 86.76 | 443500.0 |
| 2003-03-18 11:30:00 | SPY | ETF | 86.76 | 87.03 | 86.74 | 86.97 | 433300.0 |
| 2003-03-18 11:35:00 | SPY | ETF | 86.97 | 87.02 | 86.88 | 86.98 | 226400.0 |
| 2003-03-18 11:40:00 | SPY | ETF | 86.99 | 87.05 | 86.91 | 86.98 | 216500.0 |
| 2003-03-18 11:45:00 | SPY | ETF | 87.0 | 87.0 | 86.85 | 86.95 | 244400.0 |
| 2003-03-18 11:50:00 | SPY | ETF | 86.9 | 86.98 | 86.72 | 86.8 | 203500.0 |
| 2003-03-18 11:55:00 | SPY | ETF | 86.77 | 86.82 | 86.6 | 86.64 | 267400.0 |
| 2003-03-18 12:00:00 | SPY | ETF | 86.63 | 86.69 | 86.52 | 86.61 | 483300.0 |
| 2003-03-18 12:05:00 | SPY | ETF | 86.61 | 86.68 | 86.58 | 86.66 | 305500.0 |
> showing 50 of 2,628 rows — these rows as CSV