PREVIEW / etf_5min / 2024-03-18
file: by_date/etf_5min/2024/2024-03-18.parquet size: 2.2 MB rows: 109,601
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-18 04:00:00 | SPY | ETF | 511.41 | 511.41 | 511.0 | 511.36 | 2158.0 |
| 2024-03-18 04:05:00 | SPY | ETF | 511.31 | 511.31 | 511.16 | 511.22 | 1219.0 |
| 2024-03-18 04:10:00 | SPY | ETF | 511.3 | 511.3 | 511.28 | 511.28 | 500.0 |
| 2024-03-18 04:15:00 | SPY | ETF | 511.27 | 511.27 | 511.27 | 511.27 | 180.0 |
| 2024-03-18 04:20:00 | SPY | ETF | 511.17 | 511.17 | 511.17 | 511.17 | 100.0 |
| 2024-03-18 04:30:00 | SPY | ETF | 510.76 | 510.99 | 510.76 | 510.99 | 790.0 |
| 2024-03-18 04:40:00 | SPY | ETF | 511.05 | 511.05 | 511.05 | 511.05 | 200.0 |
| 2024-03-18 04:45:00 | SPY | ETF | 511.16 | 511.29 | 511.16 | 511.29 | 307.0 |
| 2024-03-18 04:50:00 | SPY | ETF | 511.38 | 511.56 | 511.32 | 511.56 | 1272.0 |
| 2024-03-18 04:55:00 | SPY | ETF | 511.57 | 511.7 | 511.57 | 511.7 | 594.0 |
| 2024-03-18 05:00:00 | SPY | ETF | 511.81 | 511.89 | 511.8 | 511.8 | 1366.0 |
| 2024-03-18 05:05:00 | SPY | ETF | 511.82 | 511.82 | 511.72 | 511.72 | 1000.0 |
| 2024-03-18 05:10:00 | SPY | ETF | 511.63 | 511.7 | 511.63 | 511.7 | 500.0 |
| 2024-03-18 05:20:00 | SPY | ETF | 511.35 | 511.37 | 511.35 | 511.37 | 950.0 |
| 2024-03-18 05:25:00 | SPY | ETF | 511.55 | 511.55 | 511.55 | 511.55 | 100.0 |
| 2024-03-18 05:30:00 | SPY | ETF | 511.46 | 511.46 | 511.46 | 511.46 | 200.0 |
| 2024-03-18 05:40:00 | SPY | ETF | 511.63 | 511.73 | 511.63 | 511.7 | 496.0 |
| 2024-03-18 05:45:00 | SPY | ETF | 511.68 | 511.68 | 511.58 | 511.58 | 200.0 |
| 2024-03-18 06:00:00 | SPY | ETF | 511.56 | 511.6 | 511.56 | 511.6 | 450.0 |
| 2024-03-18 06:05:00 | SPY | ETF | 511.57 | 511.57 | 511.51 | 511.51 | 748.0 |
| 2024-03-18 06:10:00 | SPY | ETF | 511.45 | 511.6 | 511.45 | 511.6 | 300.0 |
| 2024-03-18 06:15:00 | SPY | ETF | 511.65 | 511.65 | 511.65 | 511.65 | 100.0 |
| 2024-03-18 06:20:00 | SPY | ETF | 511.62 | 511.62 | 511.6 | 511.61 | 400.0 |
| 2024-03-18 06:25:00 | SPY | ETF | 511.6 | 511.66 | 511.6 | 511.62 | 1300.0 |
| 2024-03-18 06:30:00 | SPY | ETF | 511.75 | 511.75 | 511.64 | 511.64 | 995.0 |
| 2024-03-18 06:35:00 | SPY | ETF | 511.65 | 511.68 | 511.62 | 511.62 | 2600.0 |
| 2024-03-18 06:40:00 | SPY | ETF | 511.74 | 511.91 | 511.74 | 511.87 | 1760.0 |
| 2024-03-18 06:45:00 | SPY | ETF | 511.9 | 511.9 | 511.9 | 511.9 | 200.0 |
| 2024-03-18 06:50:00 | SPY | ETF | 511.81 | 511.85 | 511.8 | 511.85 | 1200.0 |
| 2024-03-18 06:55:00 | SPY | ETF | 511.73 | 511.77 | 511.73 | 511.77 | 500.0 |
| 2024-03-18 07:00:00 | SPY | ETF | 511.77 | 511.8 | 511.47 | 511.77 | 29518.0 |
| 2024-03-18 07:05:00 | SPY | ETF | 511.771 | 511.92 | 511.771 | 511.92 | 9147.0 |
| 2024-03-18 07:10:00 | SPY | ETF | 511.9 | 512.15 | 511.9 | 512.15 | 11855.0 |
| 2024-03-18 07:15:00 | SPY | ETF | 512.19 | 512.34 | 512.15 | 512.25 | 31980.0 |
| 2024-03-18 07:20:00 | SPY | ETF | 512.29 | 512.63 | 512.29 | 512.57 | 18223.0 |
| 2024-03-18 07:25:00 | SPY | ETF | 512.63 | 512.91 | 512.62 | 512.87 | 28645.0 |
| 2024-03-18 07:30:00 | SPY | ETF | 512.87 | 513.24 | 512.87 | 513.17 | 42577.0 |
| 2024-03-18 07:35:00 | SPY | ETF | 513.14 | 513.19 | 513.0 | 513.011 | 33196.0 |
| 2024-03-18 07:40:00 | SPY | ETF | 513.02 | 513.26 | 513.02 | 513.26 | 5995.0 |
| 2024-03-18 07:45:00 | SPY | ETF | 513.32 | 513.52 | 513.32 | 513.37 | 17211.0 |
| 2024-03-18 07:50:00 | SPY | ETF | 513.4 | 513.54 | 513.23 | 513.31 | 17675.0 |
| 2024-03-18 07:55:00 | SPY | ETF | 513.26 | 513.36 | 513.251 | 513.34 | 3894.0 |
| 2024-03-18 08:00:00 | SPY | ETF | 512.07 | 513.91 | 510.92 | 511.1 | 82739.0 |
| 2024-03-18 08:05:00 | SPY | ETF | 513.7899 | 513.93 | 510.9 | 513.85 | 30701.0 |
| 2024-03-18 08:10:00 | SPY | ETF | 513.81 | 513.99 | 513.791 | 513.9 | 50034.0 |
| 2024-03-18 08:15:00 | SPY | ETF | 513.94 | 513.94 | 513.75 | 513.75 | 17655.0 |
| 2024-03-18 08:20:00 | SPY | ETF | 513.71 | 513.75 | 513.58 | 513.699 | 25861.0 |
| 2024-03-18 08:25:00 | SPY | ETF | 513.67 | 513.81 | 513.59 | 513.81 | 20662.0 |
| 2024-03-18 08:30:00 | SPY | ETF | 513.82 | 513.82 | 509.83 | 513.47 | 90398.0 |
| 2024-03-18 08:35:00 | SPY | ETF | 513.45 | 513.6 | 513.42 | 513.59 | 19756.0 |
> showing 50 of 109,601 rows — these rows as CSV