PREVIEW / etf_5min / 2002-09-18
file: by_date/etf_5min/2002/2002-09-18.parquet size: 48 KB rows: 2,067
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-09-18 09:30:00 | SPY | ETF | 87.01 | 87.19 | 86.81 | 86.87 | 1305800.0 |
| 2002-09-18 09:35:00 | SPY | ETF | 86.88 | 87.13 | 86.83 | 87.04 | 854300.0 |
| 2002-09-18 09:40:00 | SPY | ETF | 87.02 | 87.1 | 86.82 | 87.02 | 1465600.0 |
| 2002-09-18 09:45:00 | SPY | ETF | 86.99 | 87.23 | 86.94 | 87.1 | 682800.0 |
| 2002-09-18 09:50:00 | SPY | ETF | 87.08 | 87.51 | 87.05 | 87.41 | 1349000.0 |
| 2002-09-18 09:55:00 | SPY | ETF | 87.41 | 87.42 | 87.2 | 87.29 | 1021400.0 |
| 2002-09-18 10:00:00 | SPY | ETF | 87.3 | 87.31 | 87.08 | 87.15 | 313800.0 |
| 2002-09-18 10:05:00 | SPY | ETF | 87.16 | 87.29 | 87.09 | 87.22 | 666600.0 |
| 2002-09-18 10:10:00 | SPY | ETF | 87.25 | 87.25 | 87.0 | 87.07 | 429300.0 |
| 2002-09-18 10:15:00 | SPY | ETF | 87.01 | 87.19 | 86.96 | 87.12 | 905600.0 |
| 2002-09-18 10:20:00 | SPY | ETF | 87.12 | 87.31 | 87.05 | 87.2 | 483000.0 |
| 2002-09-18 10:25:00 | SPY | ETF | 87.3 | 87.31 | 87.05 | 87.07 | 310800.0 |
| 2002-09-18 10:30:00 | SPY | ETF | 87.05 | 87.12 | 86.78 | 86.87 | 818900.0 |
| 2002-09-18 10:35:00 | SPY | ETF | 86.9 | 86.92 | 86.7 | 86.75 | 631700.0 |
| 2002-09-18 10:40:00 | SPY | ETF | 86.76 | 86.85 | 86.63 | 86.75 | 384000.0 |
| 2002-09-18 10:45:00 | SPY | ETF | 86.8 | 86.83 | 86.61 | 86.61 | 501900.0 |
| 2002-09-18 10:50:00 | SPY | ETF | 86.6 | 86.64 | 86.44 | 86.56 | 1144900.0 |
| 2002-09-18 10:55:00 | SPY | ETF | 86.58 | 86.64 | 86.47 | 86.5 | 372400.0 |
| 2002-09-18 11:00:00 | SPY | ETF | 86.5 | 86.71 | 86.49 | 86.7 | 374200.0 |
| 2002-09-18 11:05:00 | SPY | ETF | 86.7 | 86.71 | 86.57 | 86.68 | 328500.0 |
| 2002-09-18 11:10:00 | SPY | ETF | 86.66 | 86.8 | 86.66 | 86.74 | 241200.0 |
| 2002-09-18 11:15:00 | SPY | ETF | 86.73 | 86.8 | 86.7 | 86.75 | 407300.0 |
| 2002-09-18 11:20:00 | SPY | ETF | 86.74 | 86.77 | 86.56 | 86.63 | 339200.0 |
| 2002-09-18 11:25:00 | SPY | ETF | 86.65 | 86.7 | 86.59 | 86.7 | 149200.0 |
| 2002-09-18 11:30:00 | SPY | ETF | 86.68 | 86.73 | 86.3 | 86.38 | 302200.0 |
| 2002-09-18 11:35:00 | SPY | ETF | 86.38 | 86.45 | 86.31 | 86.4 | 264100.0 |
| 2002-09-18 11:40:00 | SPY | ETF | 86.4 | 86.45 | 86.28 | 86.32 | 424600.0 |
| 2002-09-18 11:45:00 | SPY | ETF | 86.35 | 86.47 | 86.33 | 86.46 | 520900.0 |
| 2002-09-18 11:50:00 | SPY | ETF | 86.45 | 86.48 | 86.37 | 86.44 | 243100.0 |
| 2002-09-18 11:55:00 | SPY | ETF | 86.45 | 86.55 | 86.41 | 86.53 | 296200.0 |
| 2002-09-18 12:00:00 | SPY | ETF | 86.53 | 86.63 | 86.46 | 86.58 | 423200.0 |
| 2002-09-18 12:05:00 | SPY | ETF | 86.55 | 86.68 | 86.51 | 86.6 | 383200.0 |
| 2002-09-18 12:10:00 | SPY | ETF | 86.59 | 86.8 | 86.57 | 86.78 | 316800.0 |
| 2002-09-18 12:15:00 | SPY | ETF | 86.79 | 86.98 | 86.74 | 86.94 | 628700.0 |
| 2002-09-18 12:20:00 | SPY | ETF | 86.94 | 86.98 | 86.8 | 86.84 | 692000.0 |
| 2002-09-18 12:25:00 | SPY | ETF | 86.85 | 86.9 | 86.76 | 86.88 | 110100.0 |
| 2002-09-18 12:30:00 | SPY | ETF | 86.85 | 86.89 | 86.7 | 86.73 | 243700.0 |
| 2002-09-18 12:35:00 | SPY | ETF | 86.71 | 86.8 | 86.68 | 86.75 | 162800.0 |
| 2002-09-18 12:40:00 | SPY | ETF | 86.75 | 86.77 | 86.62 | 86.7 | 99400.0 |
| 2002-09-18 12:45:00 | SPY | ETF | 86.72 | 86.76 | 86.56 | 86.62 | 224700.0 |
| 2002-09-18 12:50:00 | SPY | ETF | 86.61 | 86.65 | 86.51 | 86.56 | 145500.0 |
| 2002-09-18 12:55:00 | SPY | ETF | 86.57 | 86.69 | 86.53 | 86.54 | 234000.0 |
| 2002-09-18 13:00:00 | SPY | ETF | 86.57 | 86.73 | 86.47 | 86.73 | 132800.0 |
| 2002-09-18 13:05:00 | SPY | ETF | 86.7 | 86.9 | 86.67 | 86.83 | 455100.0 |
| 2002-09-18 13:10:00 | SPY | ETF | 86.84 | 86.9 | 86.75 | 86.78 | 587400.0 |
| 2002-09-18 13:15:00 | SPY | ETF | 86.81 | 86.85 | 86.71 | 86.71 | 170700.0 |
| 2002-09-18 13:20:00 | SPY | ETF | 86.71 | 86.82 | 86.66 | 86.74 | 691100.0 |
| 2002-09-18 13:25:00 | SPY | ETF | 86.74 | 86.83 | 86.65 | 86.79 | 292400.0 |
| 2002-09-18 13:30:00 | SPY | ETF | 86.78 | 87.2 | 86.74 | 87.15 | 934700.0 |
| 2002-09-18 13:35:00 | SPY | ETF | 87.12 | 87.25 | 87.03 | 87.1 | 439900.0 |
> showing 50 of 2,067 rows — these rows as CSV