PREVIEW / etf_5min / 2022-09-29
file: by_date/etf_5min/2022/2022-09-29.parquet size: 2.0 MB rows: 99,728
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-09-29 04:00:00 | SPY | ETF | 366.02 | 367.48 | 364.0 | 366.35 | 12155.0 |
| 2022-09-29 04:05:00 | SPY | ETF | 366.31 | 366.78 | 366.26 | 366.68 | 5877.0 |
| 2022-09-29 04:10:00 | SPY | ETF | 366.64 | 366.64 | 366.37 | 366.37 | 2630.0 |
| 2022-09-29 04:15:00 | SPY | ETF | 366.5 | 366.6 | 366.36 | 366.6 | 6708.0 |
| 2022-09-29 04:20:00 | SPY | ETF | 366.82 | 366.82 | 366.3 | 366.3 | 18770.0 |
| 2022-09-29 04:25:00 | SPY | ETF | 366.29 | 366.46 | 366.19 | 366.37 | 1070.0 |
| 2022-09-29 04:30:00 | SPY | ETF | 366.22 | 366.6 | 366.17 | 366.6 | 4500.0 |
| 2022-09-29 04:35:00 | SPY | ETF | 366.15 | 366.15 | 365.81 | 365.92 | 14218.0 |
| 2022-09-29 04:40:00 | SPY | ETF | 365.91 | 366.72 | 365.91 | 366.6 | 23915.0 |
| 2022-09-29 04:45:00 | SPY | ETF | 366.62 | 366.63 | 366.28 | 366.3 | 27824.0 |
| 2022-09-29 04:50:00 | SPY | ETF | 366.21 | 366.22 | 366.01 | 366.22 | 46904.0 |
| 2022-09-29 04:55:00 | SPY | ETF | 366.2 | 366.2 | 365.92 | 366.09 | 12425.0 |
| 2022-09-29 05:00:00 | SPY | ETF | 366.3 | 366.77 | 366.0 | 366.7 | 45600.0 |
| 2022-09-29 05:05:00 | SPY | ETF | 366.61 | 367.21 | 366.61 | 367.14 | 7619.0 |
| 2022-09-29 05:10:00 | SPY | ETF | 367.05 | 367.52 | 367.05 | 367.35 | 3210.0 |
| 2022-09-29 05:15:00 | SPY | ETF | 367.51 | 367.71 | 367.01 | 367.01 | 7816.0 |
| 2022-09-29 05:20:00 | SPY | ETF | 367.01 | 367.34 | 366.96 | 367.21 | 3739.0 |
| 2022-09-29 05:25:00 | SPY | ETF | 367.21 | 367.26 | 367.1 | 367.1 | 800.0 |
| 2022-09-29 05:30:00 | SPY | ETF | 367.27 | 367.28 | 367.09 | 367.13 | 1600.0 |
| 2022-09-29 05:35:00 | SPY | ETF | 367.32 | 367.32 | 367.24 | 367.24 | 725.0 |
| 2022-09-29 05:40:00 | SPY | ETF | 367.46 | 368.26 | 367.46 | 368.22 | 7488.0 |
| 2022-09-29 05:45:00 | SPY | ETF | 368.21 | 368.29 | 367.8 | 368.1 | 26962.0 |
| 2022-09-29 05:50:00 | SPY | ETF | 368.02 | 368.02 | 367.7 | 367.75 | 20752.0 |
| 2022-09-29 05:55:00 | SPY | ETF | 367.72 | 367.73 | 367.49 | 367.69 | 21950.0 |
| 2022-09-29 06:00:00 | SPY | ETF | 367.57 | 367.6 | 366.59 | 366.64 | 28985.0 |
| 2022-09-29 06:05:00 | SPY | ETF | 366.58 | 366.92 | 366.44 | 366.78 | 4339.0 |
| 2022-09-29 06:10:00 | SPY | ETF | 366.78 | 366.83 | 366.7 | 366.76 | 29863.0 |
| 2022-09-29 06:15:00 | SPY | ETF | 366.78 | 367.08 | 366.78 | 367.02 | 3885.0 |
| 2022-09-29 06:20:00 | SPY | ETF | 367.15 | 367.15 | 366.91 | 367.05 | 2410.0 |
| 2022-09-29 06:25:00 | SPY | ETF | 366.8 | 366.95 | 366.69 | 366.69 | 1890.0 |
| 2022-09-29 06:30:00 | SPY | ETF | 366.7 | 366.72 | 366.6 | 366.7 | 2037.0 |
| 2022-09-29 06:35:00 | SPY | ETF | 367.0 | 367.12 | 366.87 | 366.94 | 51300.0 |
| 2022-09-29 06:40:00 | SPY | ETF | 366.94 | 367.19 | 366.94 | 367.11 | 9728.0 |
| 2022-09-29 06:45:00 | SPY | ETF | 367.06 | 367.42 | 367.06 | 367.42 | 6184.0 |
| 2022-09-29 06:50:00 | SPY | ETF | 367.35 | 367.7 | 367.35 | 367.7 | 1400.0 |
| 2022-09-29 06:55:00 | SPY | ETF | 367.6 | 367.6 | 367.06 | 367.06 | 5650.0 |
| 2022-09-29 07:00:00 | SPY | ETF | 367.07 | 367.52 | 367.02 | 367.29 | 42013.0 |
| 2022-09-29 07:05:00 | SPY | ETF | 367.329 | 367.61 | 367.25 | 367.54 | 16583.0 |
| 2022-09-29 07:10:00 | SPY | ETF | 367.49 | 367.95 | 367.36 | 367.95 | 11517.0 |
| 2022-09-29 07:15:00 | SPY | ETF | 368.15 | 368.5 | 368.1 | 368.42 | 38178.0 |
| 2022-09-29 07:20:00 | SPY | ETF | 368.42 | 368.48 | 368.16 | 368.35 | 15055.0 |
| 2022-09-29 07:25:00 | SPY | ETF | 368.24 | 368.41 | 368.16 | 368.41 | 34399.0 |
| 2022-09-29 07:30:00 | SPY | ETF | 368.44 | 368.49 | 368.19 | 368.26 | 57384.0 |
| 2022-09-29 07:35:00 | SPY | ETF | 368.2 | 368.27 | 367.61 | 367.73 | 108758.0 |
| 2022-09-29 07:40:00 | SPY | ETF | 367.7 | 368.13 | 367.7 | 368.02 | 10429.0 |
| 2022-09-29 07:45:00 | SPY | ETF | 368.01 | 368.29 | 367.6 | 367.64 | 18605.0 |
| 2022-09-29 07:50:00 | SPY | ETF | 367.65 | 367.86 | 367.58 | 367.86 | 43678.0 |
| 2022-09-29 07:55:00 | SPY | ETF | 367.81 | 367.81 | 367.31 | 367.35 | 31665.0 |
| 2022-09-29 08:00:00 | SPY | ETF | 367.17 | 370.85 | 365.29 | 366.86 | 165683.0 |
| 2022-09-29 08:05:00 | SPY | ETF | 366.88 | 367.0 | 366.66 | 366.99 | 72406.0 |
> showing 50 of 99,728 rows — these rows as CSV