PREVIEW / etf_5min / 2024-06-10
file: by_date/etf_5min/2024/2024-06-10.parquet size: 2.1 MB rows: 104,967
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-06-10 04:00:00 | SPY | ETF | 533.49 | 533.49 | 533.28 | 533.28 | 1476.0 |
| 2024-06-10 04:05:00 | SPY | ETF | 533.24 | 533.4 | 533.23 | 533.34 | 1300.0 |
| 2024-06-10 04:10:00 | SPY | ETF | 533.34 | 533.54 | 533.34 | 533.54 | 1923.0 |
| 2024-06-10 04:15:00 | SPY | ETF | 533.32 | 533.32 | 533.18 | 533.18 | 221.0 |
| 2024-06-10 04:20:00 | SPY | ETF | 533.18 | 533.35 | 533.18 | 533.35 | 267.0 |
| 2024-06-10 04:25:00 | SPY | ETF | 533.3 | 533.3 | 533.13 | 533.13 | 1900.0 |
| 2024-06-10 04:30:00 | SPY | ETF | 533.22 | 533.26 | 533.22 | 533.26 | 300.0 |
| 2024-06-10 04:35:00 | SPY | ETF | 533.3 | 533.3 | 533.19 | 533.19 | 300.0 |
| 2024-06-10 04:40:00 | SPY | ETF | 533.24 | 533.24 | 533.14 | 533.14 | 1100.0 |
| 2024-06-10 04:50:00 | SPY | ETF | 533.02 | 533.13 | 532.95 | 532.95 | 900.0 |
| 2024-06-10 04:55:00 | SPY | ETF | 532.88 | 532.88 | 532.88 | 532.88 | 200.0 |
| 2024-06-10 05:00:00 | SPY | ETF | 532.83 | 532.83 | 532.81 | 532.81 | 500.0 |
| 2024-06-10 05:05:00 | SPY | ETF | 532.69 | 532.69 | 532.69 | 532.69 | 104.0 |
| 2024-06-10 05:10:00 | SPY | ETF | 532.76 | 532.76 | 532.71 | 532.71 | 1100.0 |
| 2024-06-10 05:20:00 | SPY | ETF | 532.5 | 532.5 | 532.5 | 532.5 | 200.0 |
| 2024-06-10 05:25:00 | SPY | ETF | 532.51 | 532.67 | 532.51 | 532.61 | 22700.0 |
| 2024-06-10 05:30:00 | SPY | ETF | 532.64 | 532.79 | 532.64 | 532.79 | 730.0 |
| 2024-06-10 05:35:00 | SPY | ETF | 532.73 | 532.73 | 532.73 | 532.73 | 200.0 |
| 2024-06-10 05:40:00 | SPY | ETF | 533.0 | 533.0 | 533.0 | 533.0 | 100.0 |
| 2024-06-10 05:45:00 | SPY | ETF | 532.74 | 532.74 | 532.74 | 532.74 | 200.0 |
| 2024-06-10 05:50:00 | SPY | ETF | 532.79 | 532.79 | 532.79 | 532.79 | 500.0 |
| 2024-06-10 05:55:00 | SPY | ETF | 532.82 | 532.82 | 532.8 | 532.8 | 1100.0 |
| 2024-06-10 06:00:00 | SPY | ETF | 532.85 | 532.91 | 532.85 | 532.91 | 2500.0 |
| 2024-06-10 06:05:00 | SPY | ETF | 532.99 | 532.99 | 532.99 | 532.99 | 500.0 |
| 2024-06-10 06:10:00 | SPY | ETF | 532.97 | 532.97 | 532.83 | 532.83 | 300.0 |
| 2024-06-10 06:20:00 | SPY | ETF | 532.98 | 533.05 | 532.98 | 533.02 | 4695.0 |
| 2024-06-10 06:25:00 | SPY | ETF | 533.04 | 533.09 | 533.04 | 533.09 | 800.0 |
| 2024-06-10 06:30:00 | SPY | ETF | 533.12 | 533.54 | 533.12 | 533.54 | 2044.0 |
| 2024-06-10 06:35:00 | SPY | ETF | 533.6 | 533.62 | 533.48 | 533.48 | 5400.0 |
| 2024-06-10 06:40:00 | SPY | ETF | 533.49 | 533.49 | 533.4 | 533.44 | 2000.0 |
| 2024-06-10 06:45:00 | SPY | ETF | 533.39 | 533.57 | 533.39 | 533.52 | 2322.0 |
| 2024-06-10 06:50:00 | SPY | ETF | 533.49 | 533.49 | 533.36 | 533.41 | 1000.0 |
| 2024-06-10 06:55:00 | SPY | ETF | 533.31 | 533.34 | 533.31 | 533.34 | 300.0 |
| 2024-06-10 07:00:00 | SPY | ETF | 533.33 | 533.43 | 533.26 | 533.36 | 12175.0 |
| 2024-06-10 07:05:00 | SPY | ETF | 533.36 | 533.46 | 533.36 | 533.45 | 7985.0 |
| 2024-06-10 07:10:00 | SPY | ETF | 533.44 | 533.47 | 533.4 | 533.47 | 2843.0 |
| 2024-06-10 07:15:00 | SPY | ETF | 533.52 | 533.62 | 533.52 | 533.62 | 2800.0 |
| 2024-06-10 07:20:00 | SPY | ETF | 533.59 | 533.61 | 533.59 | 533.61 | 1130.0 |
| 2024-06-10 07:25:00 | SPY | ETF | 533.62 | 533.64 | 533.62 | 533.64 | 780.0 |
| 2024-06-10 07:30:00 | SPY | ETF | 533.62 | 533.78 | 533.62 | 533.78 | 1290.0 |
| 2024-06-10 07:35:00 | SPY | ETF | 533.77 | 533.77 | 533.64 | 533.651 | 25549.0 |
| 2024-06-10 07:40:00 | SPY | ETF | 533.68 | 533.7 | 533.63 | 533.7 | 2667.0 |
| 2024-06-10 07:45:00 | SPY | ETF | 533.71 | 533.72 | 533.52 | 533.64 | 2546.0 |
| 2024-06-10 07:50:00 | SPY | ETF | 533.66 | 533.72 | 533.55 | 533.55 | 27140.0 |
| 2024-06-10 07:55:00 | SPY | ETF | 533.6 | 533.62 | 533.6 | 533.62 | 746.0 |
| 2024-06-10 08:00:00 | SPY | ETF | 533.3593 | 534.25 | 533.02 | 533.72 | 34919.0 |
| 2024-06-10 08:05:00 | SPY | ETF | 533.8 | 534.28 | 533.561 | 533.79 | 8495.0 |
| 2024-06-10 08:10:00 | SPY | ETF | 533.78 | 533.84 | 533.72 | 533.73 | 1237.0 |
| 2024-06-10 08:15:00 | SPY | ETF | 533.74 | 533.79 | 533.71 | 533.76 | 4454.0 |
| 2024-06-10 08:20:00 | SPY | ETF | 533.75 | 533.87 | 533.67 | 533.74 | 3642.0 |
> showing 50 of 104,967 rows — these rows as CSV