PREVIEW / etf_5min / 2007-08-24
file: by_date/etf_5min/2007/2007-08-24.parquet size: 356 KB rows: 17,393
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-08-24 05:10:00 | SPY | ETF | 146.11 | 146.11 | 146.11 | 146.11 | 100.0 |
| 2007-08-24 06:15:00 | SPY | ETF | 146.26 | 146.26 | 146.26 | 146.26 | 7000.0 |
| 2007-08-24 06:30:00 | SPY | ETF | 146.14 | 146.14 | 146.14 | 146.14 | 3000.0 |
| 2007-08-24 06:35:00 | SPY | ETF | 146.24 | 146.28 | 146.24 | 146.28 | 4000.0 |
| 2007-08-24 07:00:00 | SPY | ETF | 146.25 | 146.33 | 146.25 | 146.3 | 106000.0 |
| 2007-08-24 07:05:00 | SPY | ETF | 146.3 | 146.31 | 146.28 | 146.31 | 51800.0 |
| 2007-08-24 07:10:00 | SPY | ETF | 146.35 | 146.35 | 146.35 | 146.35 | 5700.0 |
| 2007-08-24 07:15:00 | SPY | ETF | 146.38 | 146.49 | 146.38 | 146.49 | 11200.0 |
| 2007-08-24 07:20:00 | SPY | ETF | 146.49 | 146.5 | 146.41 | 146.45 | 3600.0 |
| 2007-08-24 07:30:00 | SPY | ETF | 146.44 | 146.44 | 146.43 | 146.43 | 1800.0 |
| 2007-08-24 07:35:00 | SPY | ETF | 146.4 | 146.4 | 146.38 | 146.39 | 101000.0 |
| 2007-08-24 07:40:00 | SPY | ETF | 146.37 | 146.39 | 146.37 | 146.39 | 6300.0 |
| 2007-08-24 07:45:00 | SPY | ETF | 146.4 | 146.43 | 146.4 | 146.41 | 6700.0 |
| 2007-08-24 07:50:00 | SPY | ETF | 146.41 | 146.41 | 146.37 | 146.37 | 1600.0 |
| 2007-08-24 07:55:00 | SPY | ETF | 146.34 | 146.35 | 146.3 | 146.32 | 34700.0 |
| 2007-08-24 08:00:00 | SPY | ETF | 146.32 | 146.42 | 146.3 | 146.38 | 248100.0 |
| 2007-08-24 08:05:00 | SPY | ETF | 146.39 | 146.47 | 146.39 | 146.47 | 72600.0 |
| 2007-08-24 08:10:00 | SPY | ETF | 146.47 | 146.54 | 146.47 | 146.52 | 23500.0 |
| 2007-08-24 08:15:00 | SPY | ETF | 146.48 | 146.49 | 146.43 | 146.44 | 43300.0 |
| 2007-08-24 08:20:00 | SPY | ETF | 146.41 | 146.44 | 146.36 | 146.4 | 232000.0 |
| 2007-08-24 08:25:00 | SPY | ETF | 146.38 | 146.4 | 146.31 | 146.37 | 138700.0 |
| 2007-08-24 08:30:00 | SPY | ETF | 146.39 | 146.74 | 146.39 | 146.71 | 1149600.0 |
| 2007-08-24 08:35:00 | SPY | ETF | 146.73 | 146.73 | 146.57 | 146.58 | 249500.0 |
| 2007-08-24 08:40:00 | SPY | ETF | 146.59 | 146.61 | 146.49 | 146.53 | 106000.0 |
| 2007-08-24 08:45:00 | SPY | ETF | 146.54 | 146.56 | 146.51 | 146.55 | 54400.0 |
| 2007-08-24 08:50:00 | SPY | ETF | 146.54 | 146.72 | 146.52 | 146.6 | 241100.0 |
| 2007-08-24 08:55:00 | SPY | ETF | 146.59 | 146.6 | 146.5 | 146.55 | 202400.0 |
| 2007-08-24 09:00:00 | SPY | ETF | 146.55 | 146.71 | 146.48 | 146.54 | 986300.0 |
| 2007-08-24 09:05:00 | SPY | ETF | 146.53 | 146.56 | 146.5 | 146.54 | 148000.0 |
| 2007-08-24 09:10:00 | SPY | ETF | 146.57 | 146.57 | 146.44 | 146.49 | 59700.0 |
| 2007-08-24 09:15:00 | SPY | ETF | 146.48 | 146.49 | 145.95 | 146.46 | 67000.0 |
| 2007-08-24 09:20:00 | SPY | ETF | 146.47 | 146.51 | 146.4 | 146.44 | 136417.0 |
| 2007-08-24 09:25:00 | SPY | ETF | 146.44 | 146.49 | 146.44 | 146.47 | 75500.0 |
| 2007-08-24 09:30:00 | SPY | ETF | 146.48 | 146.68 | 146.45 | 146.5 | 2022101.0 |
| 2007-08-24 09:35:00 | SPY | ETF | 146.5 | 146.57 | 146.28 | 146.38 | 2120928.0 |
| 2007-08-24 09:40:00 | SPY | ETF | 146.38 | 146.53 | 146.36 | 146.37 | 1963700.0 |
| 2007-08-24 09:45:00 | SPY | ETF | 146.37 | 146.69 | 146.36 | 146.56 | 2271500.0 |
| 2007-08-24 09:50:00 | SPY | ETF | 146.56 | 146.76 | 146.545 | 146.64 | 1614100.0 |
| 2007-08-24 09:55:00 | SPY | ETF | 146.63 | 146.7 | 146.52 | 146.53 | 2955000.0 |
| 2007-08-24 10:00:00 | SPY | ETF | 146.53 | 147.19 | 146.52 | 146.8605 | 7179200.0 |
| 2007-08-24 10:05:00 | SPY | ETF | 146.87 | 147.16 | 146.76 | 147.02 | 3221000.0 |
| 2007-08-24 10:10:00 | SPY | ETF | 147.02 | 147.1 | 146.78 | 146.78 | 2618800.0 |
| 2007-08-24 10:15:00 | SPY | ETF | 146.78 | 146.97 | 146.77 | 146.82 | 1234900.0 |
| 2007-08-24 10:20:00 | SPY | ETF | 146.82 | 146.91 | 146.71 | 146.8 | 1743800.0 |
| 2007-08-24 10:25:00 | SPY | ETF | 146.8 | 146.91 | 146.73 | 146.75 | 949600.0 |
| 2007-08-24 10:30:00 | SPY | ETF | 146.75 | 146.89 | 146.63 | 146.68 | 1226500.0 |
| 2007-08-24 10:35:00 | SPY | ETF | 146.68 | 146.8 | 146.59 | 146.65 | 1864300.0 |
| 2007-08-24 10:40:00 | SPY | ETF | 146.65 | 146.76 | 146.62 | 146.71 | 781400.0 |
| 2007-08-24 10:45:00 | SPY | ETF | 146.72 | 146.72 | 146.51 | 146.54 | 1256400.0 |
| 2007-08-24 10:50:00 | SPY | ETF | 146.53 | 146.64 | 146.44 | 146.62 | 1409800.0 |
> showing 50 of 17,393 rows — these rows as CSV