PREVIEW / etf_5min / 2022-10-11
file: by_date/etf_5min/2022/2022-10-11.parquet size: 2.0 MB rows: 98,697
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-11 04:00:00 | SPY | ETF | 357.49 | 358.0 | 357.15 | 358.0 | 31270.0 |
| 2022-10-11 04:05:00 | SPY | ETF | 357.81 | 358.57 | 357.8 | 358.57 | 10882.0 |
| 2022-10-11 04:10:00 | SPY | ETF | 358.46 | 358.63 | 358.25 | 358.61 | 5699.0 |
| 2022-10-11 04:15:00 | SPY | ETF | 358.4 | 358.58 | 358.01 | 358.06 | 3334.0 |
| 2022-10-11 04:20:00 | SPY | ETF | 358.23 | 358.34 | 357.93 | 358.0 | 4471.0 |
| 2022-10-11 04:25:00 | SPY | ETF | 358.05 | 358.29 | 357.84 | 357.84 | 9329.0 |
| 2022-10-11 04:30:00 | SPY | ETF | 357.84 | 357.84 | 357.48 | 357.63 | 14200.0 |
| 2022-10-11 04:35:00 | SPY | ETF | 357.58 | 357.62 | 357.22 | 357.22 | 13017.0 |
| 2022-10-11 04:40:00 | SPY | ETF | 357.27 | 357.6 | 357.15 | 357.6 | 2035.0 |
| 2022-10-11 04:45:00 | SPY | ETF | 357.47 | 357.52 | 357.28 | 357.34 | 2181.0 |
| 2022-10-11 04:50:00 | SPY | ETF | 357.01 | 357.4 | 356.59 | 356.6 | 17930.0 |
| 2022-10-11 04:55:00 | SPY | ETF | 356.71 | 356.91 | 356.71 | 356.9 | 6750.0 |
| 2022-10-11 05:00:00 | SPY | ETF | 356.97 | 357.4 | 356.88 | 357.4 | 3600.0 |
| 2022-10-11 05:05:00 | SPY | ETF | 357.32 | 357.47 | 356.9 | 357.44 | 1851.0 |
| 2022-10-11 05:10:00 | SPY | ETF | 357.38 | 357.43 | 357.38 | 357.43 | 2850.0 |
| 2022-10-11 05:15:00 | SPY | ETF | 357.53 | 357.54 | 357.35 | 357.54 | 610.0 |
| 2022-10-11 05:20:00 | SPY | ETF | 357.37 | 357.37 | 357.19 | 357.19 | 600.0 |
| 2022-10-11 05:25:00 | SPY | ETF | 357.12 | 357.31 | 357.12 | 357.31 | 1579.0 |
| 2022-10-11 05:30:00 | SPY | ETF | 357.12 | 357.13 | 356.73 | 356.75 | 10256.0 |
| 2022-10-11 05:35:00 | SPY | ETF | 356.87 | 356.87 | 356.8 | 356.81 | 1000.0 |
| 2022-10-11 05:40:00 | SPY | ETF | 356.94 | 356.98 | 356.83 | 356.94 | 2677.0 |
| 2022-10-11 05:45:00 | SPY | ETF | 356.78 | 356.83 | 356.61 | 356.77 | 11050.0 |
| 2022-10-11 05:50:00 | SPY | ETF | 356.57 | 357.09 | 356.57 | 357.02 | 5160.0 |
| 2022-10-11 05:55:00 | SPY | ETF | 357.09 | 357.1 | 356.8 | 356.8 | 594.0 |
| 2022-10-11 06:00:00 | SPY | ETF | 356.93 | 356.93 | 356.41 | 356.51 | 3224.0 |
| 2022-10-11 06:05:00 | SPY | ETF | 356.51 | 356.69 | 356.31 | 356.69 | 8402.0 |
| 2022-10-11 06:10:00 | SPY | ETF | 356.67 | 356.99 | 356.67 | 356.97 | 1599.0 |
| 2022-10-11 06:15:00 | SPY | ETF | 356.69 | 356.82 | 356.51 | 356.8 | 50398.0 |
| 2022-10-11 06:20:00 | SPY | ETF | 356.83 | 356.99 | 356.6 | 356.94 | 60799.0 |
| 2022-10-11 06:25:00 | SPY | ETF | 357.01 | 357.6 | 357.0 | 357.0 | 28165.0 |
| 2022-10-11 06:30:00 | SPY | ETF | 357.15 | 357.3 | 357.0 | 357.04 | 6977.0 |
| 2022-10-11 06:35:00 | SPY | ETF | 357.14 | 357.35 | 357.08 | 357.08 | 3303.0 |
| 2022-10-11 06:40:00 | SPY | ETF | 357.14 | 357.46 | 357.13 | 357.39 | 2342.0 |
| 2022-10-11 06:45:00 | SPY | ETF | 357.32 | 357.45 | 357.27 | 357.27 | 6225.0 |
| 2022-10-11 06:50:00 | SPY | ETF | 357.32 | 357.63 | 357.32 | 357.53 | 4550.0 |
| 2022-10-11 06:55:00 | SPY | ETF | 357.55 | 357.83 | 357.5 | 357.78 | 9938.0 |
| 2022-10-11 07:00:00 | SPY | ETF | 357.79 | 358.26 | 357.75 | 357.92 | 34534.0 |
| 2022-10-11 07:05:00 | SPY | ETF | 357.92 | 358.35 | 357.92 | 358.15 | 200141.0 |
| 2022-10-11 07:10:00 | SPY | ETF | 358.09 | 358.15 | 357.94 | 358.01 | 9242.0 |
| 2022-10-11 07:15:00 | SPY | ETF | 358.2 | 358.39 | 358.08 | 358.39 | 20522.0 |
| 2022-10-11 07:20:00 | SPY | ETF | 358.29 | 358.82 | 358.04 | 358.72 | 17203.0 |
| 2022-10-11 07:25:00 | SPY | ETF | 358.77 | 358.77 | 358.42 | 358.43 | 30063.0 |
| 2022-10-11 07:30:00 | SPY | ETF | 358.44 | 358.55 | 358.23 | 358.42 | 12160.0 |
| 2022-10-11 07:35:00 | SPY | ETF | 358.5 | 358.72 | 358.47 | 358.47 | 21825.0 |
| 2022-10-11 07:40:00 | SPY | ETF | 358.44 | 358.73 | 358.44 | 358.51 | 26298.0 |
| 2022-10-11 07:45:00 | SPY | ETF | 358.4 | 358.4 | 358.15 | 358.21 | 27275.0 |
| 2022-10-11 07:50:00 | SPY | ETF | 358.16 | 358.38 | 357.98 | 358.38 | 36421.0 |
| 2022-10-11 07:55:00 | SPY | ETF | 358.37 | 358.92 | 358.28 | 358.89 | 41144.0 |
| 2022-10-11 08:00:00 | SPY | ETF | 358.85 | 359.23 | 356.83 | 359.08 | 463916.0 |
| 2022-10-11 08:05:00 | SPY | ETF | 359.06 | 359.4 | 359.02 | 359.3 | 29651.0 |
> showing 50 of 98,697 rows — these rows as CSV