PREVIEW / etf_5min / 2024-03-12
file: by_date/etf_5min/2024/2024-03-12.parquet size: 2.2 MB rows: 111,322
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-12 04:00:00 | SPY | ETF | 513.39 | 513.55 | 512.92 | 513.54 | 6792.0 |
| 2024-03-12 04:05:00 | SPY | ETF | 513.56 | 513.61 | 513.25 | 513.25 | 1267.0 |
| 2024-03-12 04:10:00 | SPY | ETF | 513.08 | 513.08 | 512.96 | 512.96 | 438.0 |
| 2024-03-12 04:15:00 | SPY | ETF | 512.96 | 512.96 | 512.93 | 512.93 | 243.0 |
| 2024-03-12 04:20:00 | SPY | ETF | 512.9 | 512.9 | 512.9 | 512.9 | 377.0 |
| 2024-03-12 04:25:00 | SPY | ETF | 512.89 | 512.89 | 512.79 | 512.79 | 617.0 |
| 2024-03-12 04:30:00 | SPY | ETF | 512.22 | 512.22 | 512.22 | 512.22 | 700.0 |
| 2024-03-12 04:35:00 | SPY | ETF | 512.69 | 512.69 | 512.69 | 512.69 | 730.0 |
| 2024-03-12 04:45:00 | SPY | ETF | 512.49 | 512.58 | 512.49 | 512.58 | 1995.0 |
| 2024-03-12 04:50:00 | SPY | ETF | 512.56 | 512.56 | 512.31 | 512.31 | 325.0 |
| 2024-03-12 04:55:00 | SPY | ETF | 512.36 | 512.54 | 512.36 | 512.54 | 525.0 |
| 2024-03-12 05:00:00 | SPY | ETF | 512.53 | 512.53 | 512.35 | 512.35 | 1174.0 |
| 2024-03-12 05:05:00 | SPY | ETF | 512.41 | 512.44 | 512.34 | 512.34 | 2774.0 |
| 2024-03-12 05:10:00 | SPY | ETF | 512.43 | 512.43 | 512.28 | 512.4 | 700.0 |
| 2024-03-12 05:20:00 | SPY | ETF | 512.4 | 512.4 | 512.4 | 512.4 | 100.0 |
| 2024-03-12 05:25:00 | SPY | ETF | 512.6 | 512.6 | 512.6 | 512.6 | 300.0 |
| 2024-03-12 05:30:00 | SPY | ETF | 512.58 | 512.71 | 512.58 | 512.7 | 650.0 |
| 2024-03-12 05:35:00 | SPY | ETF | 512.67 | 512.67 | 512.67 | 512.67 | 100.0 |
| 2024-03-12 05:40:00 | SPY | ETF | 512.63 | 512.63 | 512.5 | 512.5 | 943.0 |
| 2024-03-12 05:45:00 | SPY | ETF | 512.58 | 512.63 | 512.54 | 512.58 | 2838.0 |
| 2024-03-12 05:50:00 | SPY | ETF | 512.5 | 512.5 | 512.5 | 512.5 | 125.0 |
| 2024-03-12 05:55:00 | SPY | ETF | 512.51 | 512.51 | 512.19 | 512.23 | 937.0 |
| 2024-03-12 06:00:00 | SPY | ETF | 512.22 | 512.56 | 512.22 | 512.56 | 400.0 |
| 2024-03-12 06:05:00 | SPY | ETF | 512.52 | 512.54 | 512.5 | 512.5 | 343.0 |
| 2024-03-12 06:10:00 | SPY | ETF | 512.42 | 512.51 | 512.42 | 512.51 | 450.0 |
| 2024-03-12 06:15:00 | SPY | ETF | 512.41 | 512.42 | 512.4 | 512.4 | 600.0 |
| 2024-03-12 06:20:00 | SPY | ETF | 512.63 | 512.63 | 512.59 | 512.59 | 1050.0 |
| 2024-03-12 06:25:00 | SPY | ETF | 512.69 | 512.69 | 512.6 | 512.65 | 822.0 |
| 2024-03-12 06:30:00 | SPY | ETF | 512.61 | 512.61 | 512.61 | 512.61 | 230.0 |
| 2024-03-12 06:35:00 | SPY | ETF | 512.58 | 512.58 | 512.54 | 512.58 | 700.0 |
| 2024-03-12 06:40:00 | SPY | ETF | 512.75 | 512.92 | 512.75 | 512.92 | 3300.0 |
| 2024-03-12 06:50:00 | SPY | ETF | 512.58 | 512.58 | 512.58 | 512.58 | 159.0 |
| 2024-03-12 06:55:00 | SPY | ETF | 512.75 | 512.81 | 512.75 | 512.81 | 1941.0 |
| 2024-03-12 07:00:00 | SPY | ETF | 512.65 | 512.7 | 512.44 | 512.55 | 53727.0 |
| 2024-03-12 07:05:00 | SPY | ETF | 512.44 | 512.44 | 512.2 | 512.2 | 7900.0 |
| 2024-03-12 07:10:00 | SPY | ETF | 512.26 | 512.36 | 512.26 | 512.36 | 2435.0 |
| 2024-03-12 07:15:00 | SPY | ETF | 512.39 | 512.4 | 512.3 | 512.32 | 2300.0 |
| 2024-03-12 07:20:00 | SPY | ETF | 512.28 | 512.33 | 512.21 | 512.33 | 3447.0 |
| 2024-03-12 07:25:00 | SPY | ETF | 512.43 | 512.51 | 512.41 | 512.47 | 4652.0 |
| 2024-03-12 07:30:00 | SPY | ETF | 512.47 | 512.61 | 512.47 | 512.52 | 4977.0 |
| 2024-03-12 07:35:00 | SPY | ETF | 512.52 | 512.65 | 512.52 | 512.6 | 3200.0 |
| 2024-03-12 07:40:00 | SPY | ETF | 512.68 | 512.68 | 512.68 | 512.68 | 100.0 |
| 2024-03-12 07:45:00 | SPY | ETF | 512.67 | 512.67 | 512.45 | 512.49 | 2730.0 |
| 2024-03-12 07:50:00 | SPY | ETF | 512.42 | 512.55 | 512.42 | 512.48 | 1451.0 |
| 2024-03-12 07:55:00 | SPY | ETF | 512.44 | 512.48 | 512.41 | 512.48 | 23915.0 |
| 2024-03-12 08:00:00 | SPY | ETF | 512.46 | 513.64 | 512.19 | 512.54 | 27099.0 |
| 2024-03-12 08:05:00 | SPY | ETF | 512.521 | 512.6 | 512.46 | 512.6 | 6550.0 |
| 2024-03-12 08:10:00 | SPY | ETF | 512.55 | 512.61 | 512.51 | 512.52 | 14265.0 |
| 2024-03-12 08:15:00 | SPY | ETF | 512.53 | 512.85 | 512.49 | 512.64 | 5500.0 |
| 2024-03-12 08:20:00 | SPY | ETF | 512.69 | 512.94 | 512.61 | 512.68 | 142174.0 |
> showing 50 of 111,322 rows — these rows as CSV