PREVIEW / etf_5min / 2022-03-15
file: by_date/etf_5min/2022/2022-03-15.parquet size: 2.0 MB rows: 97,730
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-03-15 04:00:00 | SPY | ETF | 415.71 | 415.72 | 415.27 | 415.62 | 6020.0 |
| 2022-03-15 04:05:00 | SPY | ETF | 415.67 | 417.48 | 415.66 | 416.38 | 15783.0 |
| 2022-03-15 04:10:00 | SPY | ETF | 416.18 | 416.18 | 415.77 | 415.8 | 4278.0 |
| 2022-03-15 04:15:00 | SPY | ETF | 415.75 | 415.77 | 415.52 | 415.58 | 1544.0 |
| 2022-03-15 04:20:00 | SPY | ETF | 415.46 | 415.47 | 414.89 | 415.1 | 3597.0 |
| 2022-03-15 04:25:00 | SPY | ETF | 415.26 | 415.53 | 415.15 | 415.15 | 4900.0 |
| 2022-03-15 04:30:00 | SPY | ETF | 415.07 | 415.19 | 414.8 | 415.11 | 7649.0 |
| 2022-03-15 04:35:00 | SPY | ETF | 415.25 | 415.45 | 414.9 | 414.9 | 1550.0 |
| 2022-03-15 04:40:00 | SPY | ETF | 415.0 | 415.41 | 415.0 | 415.29 | 950.0 |
| 2022-03-15 04:45:00 | SPY | ETF | 415.12 | 415.12 | 414.52 | 414.58 | 2550.0 |
| 2022-03-15 04:50:00 | SPY | ETF | 414.68 | 414.68 | 414.34 | 414.49 | 1200.0 |
| 2022-03-15 04:55:00 | SPY | ETF | 414.49 | 414.5 | 414.0 | 414.25 | 9300.0 |
| 2022-03-15 05:00:00 | SPY | ETF | 414.21 | 414.35 | 414.21 | 414.24 | 1764.0 |
| 2022-03-15 05:05:00 | SPY | ETF | 414.1 | 414.1 | 413.61 | 413.82 | 4421.0 |
| 2022-03-15 05:10:00 | SPY | ETF | 413.82 | 414.25 | 413.82 | 414.25 | 2980.0 |
| 2022-03-15 05:15:00 | SPY | ETF | 414.19 | 414.21 | 413.98 | 413.99 | 2618.0 |
| 2022-03-15 05:20:00 | SPY | ETF | 414.14 | 414.78 | 414.03 | 414.78 | 3500.0 |
| 2022-03-15 05:25:00 | SPY | ETF | 414.96 | 415.16 | 414.85 | 415.0 | 6768.0 |
| 2022-03-15 05:30:00 | SPY | ETF | 414.99 | 415.41 | 414.99 | 415.12 | 4550.0 |
| 2022-03-15 05:35:00 | SPY | ETF | 415.15 | 415.15 | 414.87 | 414.87 | 1300.0 |
| 2022-03-15 05:40:00 | SPY | ETF | 415.08 | 416.06 | 415.03 | 415.91 | 10444.0 |
| 2022-03-15 05:45:00 | SPY | ETF | 416.01 | 416.23 | 415.73 | 415.8 | 5376.0 |
| 2022-03-15 05:50:00 | SPY | ETF | 415.97 | 415.97 | 415.24 | 415.24 | 40905.0 |
| 2022-03-15 05:55:00 | SPY | ETF | 415.16 | 415.4 | 414.98 | 415.37 | 5725.0 |
| 2022-03-15 06:00:00 | SPY | ETF | 415.36 | 415.71 | 415.36 | 415.64 | 4000.0 |
| 2022-03-15 06:05:00 | SPY | ETF | 415.54 | 415.85 | 415.46 | 415.77 | 3700.0 |
| 2022-03-15 06:10:00 | SPY | ETF | 415.57 | 416.25 | 415.57 | 416.25 | 20920.0 |
| 2022-03-15 06:15:00 | SPY | ETF | 416.24 | 416.29 | 415.95 | 416.08 | 14870.0 |
| 2022-03-15 06:20:00 | SPY | ETF | 416.02 | 416.39 | 415.61 | 416.27 | 8840.0 |
| 2022-03-15 06:25:00 | SPY | ETF | 416.14 | 416.42 | 416.14 | 416.3 | 17039.0 |
| 2022-03-15 06:30:00 | SPY | ETF | 416.44 | 416.7 | 416.4 | 416.7 | 1690.0 |
| 2022-03-15 06:35:00 | SPY | ETF | 416.88 | 416.99 | 416.83 | 416.86 | 25749.0 |
| 2022-03-15 06:40:00 | SPY | ETF | 416.78 | 416.78 | 416.46 | 416.46 | 3028.0 |
| 2022-03-15 06:45:00 | SPY | ETF | 416.41 | 416.7 | 416.4 | 416.59 | 8300.0 |
| 2022-03-15 06:50:00 | SPY | ETF | 416.75 | 417.37 | 416.69 | 417.37 | 7323.0 |
| 2022-03-15 06:55:00 | SPY | ETF | 417.45 | 417.97 | 417.39 | 417.42 | 53597.0 |
| 2022-03-15 07:00:00 | SPY | ETF | 417.32 | 417.75 | 417.32 | 417.67 | 8113.0 |
| 2022-03-15 07:05:00 | SPY | ETF | 417.76 | 418.22 | 417.66 | 418.15 | 31286.0 |
| 2022-03-15 07:10:00 | SPY | ETF | 418.15 | 418.31 | 417.95 | 418.26 | 16534.0 |
| 2022-03-15 07:15:00 | SPY | ETF | 418.35 | 418.45 | 417.95 | 418.15 | 20162.0 |
| 2022-03-15 07:20:00 | SPY | ETF | 418.0 | 418.0 | 417.32 | 417.35 | 35339.0 |
| 2022-03-15 07:25:00 | SPY | ETF | 417.54 | 417.67 | 417.34 | 417.41 | 33251.0 |
| 2022-03-15 07:30:00 | SPY | ETF | 417.48 | 417.71 | 417.32 | 417.71 | 31250.0 |
| 2022-03-15 07:35:00 | SPY | ETF | 417.76 | 417.96 | 417.55 | 417.65 | 27717.0 |
| 2022-03-15 07:40:00 | SPY | ETF | 417.63 | 417.63 | 417.3 | 417.34 | 10412.0 |
| 2022-03-15 07:45:00 | SPY | ETF | 417.29 | 417.3 | 416.95 | 416.95 | 17989.0 |
| 2022-03-15 07:50:00 | SPY | ETF | 416.96 | 417.19 | 416.9 | 417.11 | 50325.0 |
| 2022-03-15 07:55:00 | SPY | ETF | 417.11 | 417.5 | 417.1 | 417.42 | 166030.0 |
| 2022-03-15 08:00:00 | SPY | ETF | 418.2201 | 418.4499 | 414.8004 | 417.56 | 105971.0 |
| 2022-03-15 08:05:00 | SPY | ETF | 417.59 | 417.68 | 417.19 | 417.26 | 9213.0 |
> showing 50 of 97,730 rows — these rows as CSV