PREVIEW / etf_5min / 2023-03-24
file: by_date/etf_5min/2023/2023-03-24.parquet size: 2.0 MB rows: 97,611
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-24 04:00:00 | SPY | ETF | 394.84 | 394.84 | 394.17 | 394.17 | 3477.0 |
| 2023-03-24 04:05:00 | SPY | ETF | 394.12 | 394.14 | 392.85 | 392.85 | 35862.0 |
| 2023-03-24 04:10:00 | SPY | ETF | 393.2 | 393.48 | 393.16 | 393.48 | 8201.0 |
| 2023-03-24 04:15:00 | SPY | ETF | 393.49 | 393.62 | 393.16 | 393.16 | 8135.0 |
| 2023-03-24 04:20:00 | SPY | ETF | 393.13 | 393.71 | 392.91 | 393.64 | 9308.0 |
| 2023-03-24 04:25:00 | SPY | ETF | 393.6 | 393.99 | 393.57 | 393.83 | 14877.0 |
| 2023-03-24 04:30:00 | SPY | ETF | 393.74 | 393.81 | 393.57 | 393.57 | 3100.0 |
| 2023-03-24 04:35:00 | SPY | ETF | 393.5 | 393.5 | 393.0 | 393.0 | 9100.0 |
| 2023-03-24 04:40:00 | SPY | ETF | 393.07 | 393.07 | 392.35 | 392.5 | 11661.0 |
| 2023-03-24 04:45:00 | SPY | ETF | 392.33 | 392.33 | 391.87 | 391.88 | 14833.0 |
| 2023-03-24 04:50:00 | SPY | ETF | 391.86 | 392.39 | 391.77 | 392.35 | 9834.0 |
| 2023-03-24 04:55:00 | SPY | ETF | 392.27 | 392.97 | 392.27 | 392.82 | 17818.0 |
| 2023-03-24 05:00:00 | SPY | ETF | 392.63 | 392.73 | 392.44 | 392.73 | 15333.0 |
| 2023-03-24 05:05:00 | SPY | ETF | 392.74 | 393.3 | 392.6 | 392.69 | 24086.0 |
| 2023-03-24 05:10:00 | SPY | ETF | 392.75 | 393.13 | 392.64 | 392.78 | 12000.0 |
| 2023-03-24 05:15:00 | SPY | ETF | 392.51 | 392.87 | 392.44 | 392.52 | 6950.0 |
| 2023-03-24 05:20:00 | SPY | ETF | 392.45 | 392.45 | 392.02 | 392.22 | 11914.0 |
| 2023-03-24 05:25:00 | SPY | ETF | 392.2 | 392.22 | 392.13 | 392.2 | 10325.0 |
| 2023-03-24 05:30:00 | SPY | ETF | 392.18 | 392.22 | 391.56 | 391.83 | 5444.0 |
| 2023-03-24 05:35:00 | SPY | ETF | 391.89 | 391.93 | 391.2 | 391.21 | 18819.0 |
| 2023-03-24 05:40:00 | SPY | ETF | 391.2 | 391.36 | 391.16 | 391.16 | 7287.0 |
| 2023-03-24 05:45:00 | SPY | ETF | 391.1 | 391.19 | 390.67 | 390.94 | 26411.0 |
| 2023-03-24 05:50:00 | SPY | ETF | 390.97 | 390.97 | 390.64 | 390.68 | 7639.0 |
| 2023-03-24 05:55:00 | SPY | ETF | 390.67 | 390.91 | 390.49 | 390.49 | 19761.0 |
| 2023-03-24 06:00:00 | SPY | ETF | 390.47 | 390.71 | 390.3 | 390.45 | 18835.0 |
| 2023-03-24 06:05:00 | SPY | ETF | 390.37 | 390.37 | 390.05 | 390.06 | 16813.0 |
| 2023-03-24 06:10:00 | SPY | ETF | 390.14 | 390.38 | 389.9 | 389.9 | 32560.0 |
| 2023-03-24 06:15:00 | SPY | ETF | 389.98 | 390.77 | 389.96 | 390.71 | 41665.0 |
| 2023-03-24 06:20:00 | SPY | ETF | 390.85 | 391.09 | 390.58 | 390.67 | 14324.0 |
| 2023-03-24 06:25:00 | SPY | ETF | 390.61 | 390.84 | 390.5 | 390.74 | 30652.0 |
| 2023-03-24 06:30:00 | SPY | ETF | 390.45 | 390.46 | 390.19 | 390.2 | 46762.0 |
| 2023-03-24 06:35:00 | SPY | ETF | 390.25 | 390.4 | 389.78 | 390.33 | 48430.0 |
| 2023-03-24 06:40:00 | SPY | ETF | 390.38 | 390.68 | 390.35 | 390.54 | 6566.0 |
| 2023-03-24 06:45:00 | SPY | ETF | 390.6 | 390.96 | 390.49 | 390.91 | 53231.0 |
| 2023-03-24 06:50:00 | SPY | ETF | 390.82 | 390.82 | 390.64 | 390.64 | 6816.0 |
| 2023-03-24 06:55:00 | SPY | ETF | 390.63 | 390.67 | 390.15 | 390.51 | 15787.0 |
| 2023-03-24 07:00:00 | SPY | ETF | 390.59 | 390.6 | 389.74 | 390.42 | 233428.0 |
| 2023-03-24 07:05:00 | SPY | ETF | 390.4 | 390.5 | 389.88 | 389.99 | 61737.0 |
| 2023-03-24 07:10:00 | SPY | ETF | 389.95 | 390.3 | 389.75 | 390.22 | 48623.0 |
| 2023-03-24 07:15:00 | SPY | ETF | 390.26 | 390.26 | 389.9 | 390.01 | 22187.0 |
| 2023-03-24 07:20:00 | SPY | ETF | 390.06 | 390.45 | 390.06 | 390.23 | 19966.0 |
| 2023-03-24 07:25:00 | SPY | ETF | 390.18 | 390.48 | 390.1 | 390.39 | 14543.0 |
| 2023-03-24 07:30:00 | SPY | ETF | 390.45 | 390.73 | 390.45 | 390.65 | 47747.0 |
| 2023-03-24 07:35:00 | SPY | ETF | 390.62 | 390.93 | 390.57 | 390.8 | 42504.0 |
| 2023-03-24 07:40:00 | SPY | ETF | 390.84 | 390.97 | 390.2 | 390.28 | 41368.0 |
| 2023-03-24 07:45:00 | SPY | ETF | 390.29 | 390.3 | 389.87 | 390.02 | 60544.0 |
| 2023-03-24 07:50:00 | SPY | ETF | 389.96 | 390.11 | 389.85 | 390.09 | 54835.0 |
| 2023-03-24 07:55:00 | SPY | ETF | 390.09 | 390.32 | 389.56 | 389.89 | 84863.0 |
| 2023-03-24 08:00:00 | SPY | ETF | 390.44 | 395.3 | 389.46 | 389.52 | 211439.0 |
| 2023-03-24 08:05:00 | SPY | ETF | 389.48 | 389.8 | 389.33 | 389.77 | 80926.0 |
> showing 50 of 97,611 rows — these rows as CSV