PREVIEW / etf_5min / 2023-03-14
file: by_date/etf_5min/2023/2023-03-14.parquet size: 2.0 MB rows: 100,363
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-14 04:00:00 | SPY | ETF | 386.93 | 387.05 | 386.51 | 386.51 | 1479.0 |
| 2023-03-14 04:05:00 | SPY | ETF | 386.5 | 387.2 | 386.5 | 386.89 | 595.0 |
| 2023-03-14 04:10:00 | SPY | ETF | 386.85 | 387.0 | 386.29 | 387.0 | 3513.0 |
| 2023-03-14 04:15:00 | SPY | ETF | 386.91 | 387.03 | 386.91 | 387.02 | 797.0 |
| 2023-03-14 04:20:00 | SPY | ETF | 386.48 | 386.65 | 386.4 | 386.42 | 2600.0 |
| 2023-03-14 04:25:00 | SPY | ETF | 386.48 | 386.95 | 386.48 | 386.95 | 600.0 |
| 2023-03-14 04:30:00 | SPY | ETF | 387.13 | 387.14 | 386.9 | 386.95 | 6074.0 |
| 2023-03-14 04:35:00 | SPY | ETF | 387.2 | 387.41 | 386.94 | 387.41 | 7007.0 |
| 2023-03-14 04:40:00 | SPY | ETF | 387.31 | 387.41 | 387.09 | 387.11 | 1587.0 |
| 2023-03-14 04:45:00 | SPY | ETF | 386.83 | 387.4 | 386.83 | 387.4 | 3691.0 |
| 2023-03-14 04:50:00 | SPY | ETF | 387.35 | 387.35 | 387.12 | 387.16 | 1138.0 |
| 2023-03-14 04:55:00 | SPY | ETF | 387.34 | 387.64 | 387.34 | 387.6 | 4786.0 |
| 2023-03-14 05:00:00 | SPY | ETF | 387.51 | 387.53 | 387.13 | 387.13 | 3100.0 |
| 2023-03-14 05:05:00 | SPY | ETF | 387.34 | 387.34 | 386.75 | 386.75 | 6458.0 |
| 2023-03-14 05:10:00 | SPY | ETF | 386.74 | 386.74 | 386.3 | 386.57 | 4616.0 |
| 2023-03-14 05:15:00 | SPY | ETF | 386.4 | 386.49 | 386.28 | 386.37 | 4800.0 |
| 2023-03-14 05:20:00 | SPY | ETF | 386.14 | 386.29 | 386.14 | 386.21 | 1952.0 |
| 2023-03-14 05:25:00 | SPY | ETF | 386.3 | 386.75 | 386.3 | 386.75 | 1824.0 |
| 2023-03-14 05:30:00 | SPY | ETF | 386.69 | 386.69 | 386.36 | 386.56 | 12430.0 |
| 2023-03-14 05:35:00 | SPY | ETF | 386.8 | 387.08 | 386.7 | 386.7 | 1952.0 |
| 2023-03-14 05:40:00 | SPY | ETF | 386.87 | 386.87 | 386.74 | 386.75 | 3300.0 |
| 2023-03-14 05:45:00 | SPY | ETF | 386.82 | 386.89 | 386.7 | 386.7 | 2800.0 |
| 2023-03-14 05:50:00 | SPY | ETF | 386.87 | 386.87 | 386.64 | 386.7 | 1500.0 |
| 2023-03-14 05:55:00 | SPY | ETF | 386.79 | 386.87 | 386.68 | 386.81 | 4700.0 |
| 2023-03-14 06:00:00 | SPY | ETF | 386.8 | 387.0 | 386.4 | 387.0 | 38972.0 |
| 2023-03-14 06:05:00 | SPY | ETF | 386.88 | 387.21 | 386.87 | 387.21 | 11982.0 |
| 2023-03-14 06:10:00 | SPY | ETF | 387.2 | 387.33 | 386.78 | 386.89 | 8203.0 |
| 2023-03-14 06:15:00 | SPY | ETF | 386.97 | 386.98 | 386.5 | 386.61 | 8392.0 |
| 2023-03-14 06:20:00 | SPY | ETF | 386.73 | 386.95 | 386.7 | 386.78 | 9100.0 |
| 2023-03-14 06:25:00 | SPY | ETF | 386.82 | 387.17 | 386.7 | 387.17 | 5287.0 |
| 2023-03-14 06:30:00 | SPY | ETF | 387.23 | 387.24 | 386.99 | 387.17 | 11530.0 |
| 2023-03-14 06:35:00 | SPY | ETF | 387.1 | 387.1 | 386.79 | 386.79 | 2896.0 |
| 2023-03-14 06:40:00 | SPY | ETF | 386.6 | 386.66 | 386.57 | 386.57 | 2200.0 |
| 2023-03-14 06:45:00 | SPY | ETF | 386.78 | 387.01 | 386.65 | 387.0 | 1718.0 |
| 2023-03-14 06:50:00 | SPY | ETF | 386.99 | 387.15 | 386.99 | 387.15 | 1190.0 |
| 2023-03-14 06:55:00 | SPY | ETF | 387.1 | 387.1 | 386.92 | 387.09 | 1503.0 |
| 2023-03-14 07:00:00 | SPY | ETF | 387.0 | 387.28 | 386.65 | 387.09 | 68537.0 |
| 2023-03-14 07:05:00 | SPY | ETF | 387.15 | 387.35 | 387.06 | 387.29 | 11916.0 |
| 2023-03-14 07:10:00 | SPY | ETF | 387.35 | 387.6 | 387.31 | 387.31 | 26538.0 |
| 2023-03-14 07:15:00 | SPY | ETF | 387.42 | 387.61 | 387.29 | 387.6 | 40150.0 |
| 2023-03-14 07:20:00 | SPY | ETF | 387.58 | 388.19 | 387.54 | 388.1 | 55305.0 |
| 2023-03-14 07:25:00 | SPY | ETF | 388.11 | 388.33 | 387.87 | 387.96 | 22554.0 |
| 2023-03-14 07:30:00 | SPY | ETF | 387.9 | 388.15 | 387.86 | 388.01 | 49283.0 |
| 2023-03-14 07:35:00 | SPY | ETF | 387.98 | 388.09 | 387.75 | 388.04 | 21574.0 |
| 2023-03-14 07:40:00 | SPY | ETF | 388.11 | 388.38 | 387.99 | 388.37 | 46828.0 |
| 2023-03-14 07:45:00 | SPY | ETF | 388.35 | 388.43 | 388.16 | 388.16 | 24425.0 |
| 2023-03-14 07:50:00 | SPY | ETF | 388.16 | 388.23 | 387.82 | 388.19 | 66642.0 |
| 2023-03-14 07:55:00 | SPY | ETF | 388.13 | 388.23 | 387.91 | 387.96 | 36657.0 |
| 2023-03-14 08:00:00 | SPY | ETF | 387.8 | 388.55 | 385.5 | 388.2 | 107759.0 |
| 2023-03-14 08:05:00 | SPY | ETF | 388.25 | 388.27 | 388.0 | 388.26 | 66441.0 |
> showing 50 of 100,363 rows — these rows as CSV