PREVIEW / etf_5min / 2003-07-31
file: by_date/etf_5min/2003/2003-07-31.parquet size: 60 KB rows: 2,773
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-07-31 08:00:00 | SPY | ETF | 99.16 | 99.16 | 99.0 | 99.16 | 1300.0 |
| 2003-07-31 08:05:00 | SPY | ETF | 99.16 | 99.18 | 99.12 | 99.15 | 8300.0 |
| 2003-07-31 08:10:00 | SPY | ETF | 99.11 | 99.13 | 99.11 | 99.13 | 1100.0 |
| 2003-07-31 08:15:00 | SPY | ETF | 99.16 | 99.16 | 99.13 | 99.16 | 2400.0 |
| 2003-07-31 08:20:00 | SPY | ETF | 99.12 | 99.12 | 99.12 | 99.12 | 6000.0 |
| 2003-07-31 08:25:00 | SPY | ETF | 99.11 | 99.15 | 99.06 | 99.15 | 7600.0 |
| 2003-07-31 08:30:00 | SPY | ETF | 99.18 | 99.77 | 99.18 | 99.77 | 115200.0 |
| 2003-07-31 08:35:00 | SPY | ETF | 99.76 | 99.87 | 99.74 | 99.84 | 41500.0 |
| 2003-07-31 08:40:00 | SPY | ETF | 99.83 | 99.84 | 99.78 | 99.83 | 17900.0 |
| 2003-07-31 08:45:00 | SPY | ETF | 99.83 | 99.87 | 99.8 | 99.85 | 29000.0 |
| 2003-07-31 08:50:00 | SPY | ETF | 99.85 | 99.85 | 99.81 | 99.81 | 2800.0 |
| 2003-07-31 08:55:00 | SPY | ETF | 99.84 | 99.84 | 99.8 | 99.8 | 15400.0 |
| 2003-07-31 09:00:00 | SPY | ETF | 99.82 | 99.82 | 99.77 | 99.8 | 14300.0 |
| 2003-07-31 09:05:00 | SPY | ETF | 99.8 | 99.88 | 99.8 | 99.88 | 14300.0 |
| 2003-07-31 09:10:00 | SPY | ETF | 99.88 | 99.88 | 99.8 | 99.8 | 9500.0 |
| 2003-07-31 09:15:00 | SPY | ETF | 99.83 | 99.84 | 99.8 | 99.81 | 12800.0 |
| 2003-07-31 09:20:00 | SPY | ETF | 99.84 | 99.88 | 99.8 | 99.85 | 14800.0 |
| 2003-07-31 09:25:00 | SPY | ETF | 99.87 | 99.98 | 99.87 | 99.97 | 15100.0 |
| 2003-07-31 09:30:00 | SPY | ETF | 99.98 | 100.02 | 99.809 | 99.83 | 959900.0 |
| 2003-07-31 09:35:00 | SPY | ETF | 99.83 | 99.93 | 99.66 | 99.7 | 1092000.0 |
| 2003-07-31 09:40:00 | SPY | ETF | 99.72 | 99.88 | 99.68 | 99.83 | 600600.0 |
| 2003-07-31 09:45:00 | SPY | ETF | 99.8 | 99.85 | 99.59 | 99.61 | 1131500.0 |
| 2003-07-31 09:50:00 | SPY | ETF | 99.65 | 99.66 | 99.48 | 99.506 | 645300.0 |
| 2003-07-31 09:55:00 | SPY | ETF | 99.52 | 100.214 | 99.38 | 99.89 | 677700.0 |
| 2003-07-31 10:00:00 | SPY | ETF | 99.857 | 100.11 | 99.64 | 99.93 | 1376700.0 |
| 2003-07-31 10:05:00 | SPY | ETF | 99.91 | 99.95 | 99.172 | 99.37 | 2196900.0 |
| 2003-07-31 10:10:00 | SPY | ETF | 99.37 | 99.59 | 99.3 | 99.5 | 1101000.0 |
| 2003-07-31 10:15:00 | SPY | ETF | 99.48 | 99.53 | 99.28 | 99.37 | 745900.0 |
| 2003-07-31 10:20:00 | SPY | ETF | 99.39 | 99.56 | 99.33 | 99.49 | 885200.0 |
| 2003-07-31 10:25:00 | SPY | ETF | 99.49 | 99.69 | 99.43 | 99.64 | 1899100.0 |
| 2003-07-31 10:30:00 | SPY | ETF | 99.51 | 99.955 | 99.51 | 99.89 | 671400.0 |
| 2003-07-31 10:35:00 | SPY | ETF | 99.92 | 100.3 | 99.84 | 100.14 | 1688100.0 |
| 2003-07-31 10:40:00 | SPY | ETF | 100.14 | 100.42 | 100.12 | 100.351 | 904600.0 |
| 2003-07-31 10:45:00 | SPY | ETF | 100.36 | 100.6 | 100.35 | 100.51 | 1740300.0 |
| 2003-07-31 10:50:00 | SPY | ETF | 100.52 | 100.56 | 100.41 | 100.47 | 1141800.0 |
| 2003-07-31 10:55:00 | SPY | ETF | 100.5 | 100.74 | 100.45 | 100.74 | 889400.0 |
| 2003-07-31 11:00:00 | SPY | ETF | 100.74 | 100.75 | 100.61 | 100.63 | 667400.0 |
| 2003-07-31 11:05:00 | SPY | ETF | 100.65 | 100.77 | 100.63 | 100.77 | 457900.0 |
| 2003-07-31 11:10:00 | SPY | ETF | 100.7 | 100.94 | 100.66 | 100.87 | 628600.0 |
| 2003-07-31 11:15:00 | SPY | ETF | 100.86 | 100.88 | 100.72 | 100.78 | 446400.0 |
| 2003-07-31 11:20:00 | SPY | ETF | 100.78 | 100.9 | 100.75 | 100.85 | 731900.0 |
| 2003-07-31 11:25:00 | SPY | ETF | 100.81 | 100.85 | 100.72 | 100.76 | 601800.0 |
| 2003-07-31 11:30:00 | SPY | ETF | 100.73 | 100.789 | 100.67 | 100.69 | 318200.0 |
| 2003-07-31 11:35:00 | SPY | ETF | 100.73 | 100.8 | 100.671 | 100.73 | 146200.0 |
| 2003-07-31 11:40:00 | SPY | ETF | 100.756 | 100.8 | 100.69 | 100.73 | 80100.0 |
| 2003-07-31 11:45:00 | SPY | ETF | 100.72 | 100.75 | 100.68 | 100.7 | 262500.0 |
| 2003-07-31 11:50:00 | SPY | ETF | 100.696 | 100.74 | 100.64 | 100.65 | 147700.0 |
| 2003-07-31 11:55:00 | SPY | ETF | 100.66 | 100.67 | 100.58 | 100.64 | 371600.0 |
| 2003-07-31 12:00:00 | SPY | ETF | 100.59 | 100.66 | 100.55 | 100.64 | 159200.0 |
| 2003-07-31 12:05:00 | SPY | ETF | 100.65 | 100.7 | 100.63 | 100.68 | 97800.0 |
> showing 50 of 2,773 rows — these rows as CSV