PREVIEW / etf_5min / 2002-08-07
file: by_date/etf_5min/2002/2002-08-07.parquet size: 49 KB rows: 1,957
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-07 09:30:00 | SPY | ETF | 87.87 | 88.5 | 87.68 | 88.39 | 1690700.0 |
| 2002-08-07 09:35:00 | SPY | ETF | 88.32 | 88.5 | 87.97 | 88.0 | 1107300.0 |
| 2002-08-07 09:40:00 | SPY | ETF | 88.02 | 88.2 | 87.7 | 87.76 | 1259500.0 |
| 2002-08-07 09:45:00 | SPY | ETF | 87.76 | 87.89 | 87.32 | 87.35 | 786300.0 |
| 2002-08-07 09:50:00 | SPY | ETF | 87.45 | 87.54 | 87.15 | 87.24 | 695700.0 |
| 2002-08-07 09:55:00 | SPY | ETF | 87.24 | 87.32 | 86.6 | 86.95 | 971700.0 |
| 2002-08-07 10:00:00 | SPY | ETF | 86.88 | 87.14 | 86.68 | 87.05 | 1093900.0 |
| 2002-08-07 10:05:00 | SPY | ETF | 87.07 | 87.28 | 86.9 | 87.08 | 681500.0 |
| 2002-08-07 10:10:00 | SPY | ETF | 87.08 | 87.26 | 86.9 | 87.26 | 394100.0 |
| 2002-08-07 10:15:00 | SPY | ETF | 87.25 | 87.35 | 86.95 | 86.95 | 562500.0 |
| 2002-08-07 10:20:00 | SPY | ETF | 86.99 | 87.0 | 86.67 | 86.9 | 425400.0 |
| 2002-08-07 10:25:00 | SPY | ETF | 86.92 | 87.13 | 86.85 | 86.89 | 247200.0 |
| 2002-08-07 10:30:00 | SPY | ETF | 86.99 | 87.3 | 86.79 | 87.19 | 415100.0 |
| 2002-08-07 10:35:00 | SPY | ETF | 87.17 | 87.25 | 86.93 | 87.14 | 464500.0 |
| 2002-08-07 10:40:00 | SPY | ETF | 87.16 | 87.22 | 86.86 | 87.11 | 377100.0 |
| 2002-08-07 10:45:00 | SPY | ETF | 87.1 | 87.19 | 86.91 | 87.15 | 297500.0 |
| 2002-08-07 10:50:00 | SPY | ETF | 87.15 | 87.22 | 86.95 | 87.02 | 203400.0 |
| 2002-08-07 10:55:00 | SPY | ETF | 87.04 | 87.04 | 86.7 | 86.85 | 552600.0 |
| 2002-08-07 11:00:00 | SPY | ETF | 86.83 | 86.87 | 86.58 | 86.61 | 489700.0 |
| 2002-08-07 11:05:00 | SPY | ETF | 86.63 | 86.64 | 86.31 | 86.39 | 875100.0 |
| 2002-08-07 11:10:00 | SPY | ETF | 86.39 | 86.55 | 86.27 | 86.35 | 318800.0 |
| 2002-08-07 11:15:00 | SPY | ETF | 86.27 | 86.36 | 86.2 | 86.21 | 347600.0 |
| 2002-08-07 11:20:00 | SPY | ETF | 86.21 | 86.38 | 86.18 | 86.32 | 384100.0 |
| 2002-08-07 11:25:00 | SPY | ETF | 86.3 | 86.4 | 86.19 | 86.35 | 233100.0 |
| 2002-08-07 11:30:00 | SPY | ETF | 86.37 | 86.47 | 86.26 | 86.35 | 243100.0 |
| 2002-08-07 11:35:00 | SPY | ETF | 86.31 | 86.75 | 86.24 | 86.67 | 435200.0 |
| 2002-08-07 11:40:00 | SPY | ETF | 86.67 | 86.83 | 86.55 | 86.58 | 951900.0 |
| 2002-08-07 11:45:00 | SPY | ETF | 86.63 | 86.89 | 86.57 | 86.85 | 825600.0 |
| 2002-08-07 11:50:00 | SPY | ETF | 86.87 | 86.95 | 86.68 | 86.68 | 256500.0 |
| 2002-08-07 11:55:00 | SPY | ETF | 86.67 | 86.75 | 86.56 | 86.64 | 223600.0 |
| 2002-08-07 12:00:00 | SPY | ETF | 86.64 | 86.7 | 86.3 | 86.43 | 247200.0 |
| 2002-08-07 12:05:00 | SPY | ETF | 86.48 | 86.58 | 86.34 | 86.43 | 222100.0 |
| 2002-08-07 12:10:00 | SPY | ETF | 86.38 | 86.57 | 86.38 | 86.42 | 88700.0 |
| 2002-08-07 12:15:00 | SPY | ETF | 86.45 | 86.7 | 86.37 | 86.62 | 215900.0 |
| 2002-08-07 12:20:00 | SPY | ETF | 86.61 | 86.75 | 86.54 | 86.74 | 259000.0 |
| 2002-08-07 12:25:00 | SPY | ETF | 86.73 | 86.78 | 86.62 | 86.69 | 203000.0 |
| 2002-08-07 12:30:00 | SPY | ETF | 86.65 | 86.71 | 86.51 | 86.58 | 224100.0 |
| 2002-08-07 12:35:00 | SPY | ETF | 86.57 | 86.57 | 86.39 | 86.42 | 121300.0 |
| 2002-08-07 12:40:00 | SPY | ETF | 86.49 | 86.77 | 86.42 | 86.74 | 113000.0 |
| 2002-08-07 12:45:00 | SPY | ETF | 86.72 | 86.74 | 86.56 | 86.67 | 122000.0 |
| 2002-08-07 12:50:00 | SPY | ETF | 86.69 | 86.79 | 86.66 | 86.66 | 264000.0 |
| 2002-08-07 12:55:00 | SPY | ETF | 86.75 | 86.75 | 86.53 | 86.68 | 120700.0 |
| 2002-08-07 13:00:00 | SPY | ETF | 86.62 | 86.7 | 86.47 | 86.48 | 90200.0 |
| 2002-08-07 13:05:00 | SPY | ETF | 86.47 | 86.53 | 86.36 | 86.5 | 404200.0 |
| 2002-08-07 13:10:00 | SPY | ETF | 86.5 | 86.54 | 86.26 | 86.33 | 90700.0 |
| 2002-08-07 13:15:00 | SPY | ETF | 86.34 | 86.37 | 86.14 | 86.25 | 638700.0 |
| 2002-08-07 13:20:00 | SPY | ETF | 86.25 | 86.4 | 86.2 | 86.31 | 183600.0 |
| 2002-08-07 13:25:00 | SPY | ETF | 86.34 | 86.35 | 86.2 | 86.25 | 105900.0 |
| 2002-08-07 13:30:00 | SPY | ETF | 86.25 | 86.28 | 85.9 | 86.0 | 536200.0 |
| 2002-08-07 13:35:00 | SPY | ETF | 86.0 | 86.11 | 85.9 | 86.01 | 161900.0 |
> showing 50 of 1,957 rows — these rows as CSV