PREVIEW / etf_5min / 2022-03-16
file: by_date/etf_5min/2022/2022-03-16.parquet size: 2.1 MB rows: 101,357
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-16 04:00:00 | SPY | ETF | 429.17 | 429.64 | 426.9 | 429.59 | 15732.0 |
| 2022-03-16 04:05:00 | SPY | ETF | 429.62 | 429.62 | 429.13 | 429.47 | 5524.0 |
| 2022-03-16 04:10:00 | SPY | ETF | 429.6 | 429.67 | 429.13 | 429.19 | 2600.0 |
| 2022-03-16 04:15:00 | SPY | ETF | 429.21 | 430.24 | 429.21 | 430.24 | 17250.0 |
| 2022-03-16 04:20:00 | SPY | ETF | 430.14 | 430.19 | 429.52 | 429.63 | 13330.0 |
| 2022-03-16 04:25:00 | SPY | ETF | 429.61 | 430.0 | 429.54 | 430.0 | 1000.0 |
| 2022-03-16 04:30:00 | SPY | ETF | 430.0 | 430.74 | 429.81 | 430.58 | 16295.0 |
| 2022-03-16 04:35:00 | SPY | ETF | 430.01 | 430.65 | 429.86 | 430.14 | 7000.0 |
| 2022-03-16 04:40:00 | SPY | ETF | 430.18 | 430.31 | 429.97 | 429.98 | 11165.0 |
| 2022-03-16 04:45:00 | SPY | ETF | 429.88 | 430.0 | 429.86 | 429.86 | 2100.0 |
| 2022-03-16 04:50:00 | SPY | ETF | 430.0 | 430.0 | 429.75 | 429.75 | 981.0 |
| 2022-03-16 04:55:00 | SPY | ETF | 430.0 | 430.3 | 430.0 | 430.16 | 5580.0 |
| 2022-03-16 05:00:00 | SPY | ETF | 430.27 | 430.35 | 430.25 | 430.27 | 2820.0 |
| 2022-03-16 05:05:00 | SPY | ETF | 430.42 | 430.49 | 430.34 | 430.42 | 4537.0 |
| 2022-03-16 05:10:00 | SPY | ETF | 430.5 | 430.56 | 430.34 | 430.45 | 6776.0 |
| 2022-03-16 05:15:00 | SPY | ETF | 430.46 | 430.86 | 430.46 | 430.75 | 10494.0 |
| 2022-03-16 05:20:00 | SPY | ETF | 430.58 | 430.62 | 430.45 | 430.62 | 1000.0 |
| 2022-03-16 05:25:00 | SPY | ETF | 430.63 | 430.86 | 430.63 | 430.86 | 32246.0 |
| 2022-03-16 05:30:00 | SPY | ETF | 430.84 | 431.04 | 430.84 | 430.95 | 14350.0 |
| 2022-03-16 05:35:00 | SPY | ETF | 430.88 | 430.88 | 430.86 | 430.86 | 483.0 |
| 2022-03-16 05:40:00 | SPY | ETF | 430.58 | 430.74 | 430.56 | 430.57 | 2600.0 |
| 2022-03-16 05:45:00 | SPY | ETF | 430.35 | 430.52 | 430.29 | 430.52 | 1125.0 |
| 2022-03-16 05:50:00 | SPY | ETF | 430.6 | 430.7 | 430.6 | 430.66 | 1120.0 |
| 2022-03-16 05:55:00 | SPY | ETF | 430.36 | 430.37 | 430.25 | 430.28 | 4648.0 |
| 2022-03-16 06:00:00 | SPY | ETF | 430.25 | 430.51 | 430.2 | 430.51 | 3083.0 |
| 2022-03-16 06:05:00 | SPY | ETF | 430.4 | 430.4 | 430.39 | 430.39 | 200.0 |
| 2022-03-16 06:10:00 | SPY | ETF | 430.59 | 431.71 | 430.51 | 431.67 | 28735.0 |
| 2022-03-16 06:15:00 | SPY | ETF | 431.71 | 431.8 | 431.4 | 431.5 | 17410.0 |
| 2022-03-16 06:20:00 | SPY | ETF | 431.45 | 431.52 | 431.44 | 431.5 | 1927.0 |
| 2022-03-16 06:25:00 | SPY | ETF | 431.52 | 431.56 | 431.23 | 431.23 | 39135.0 |
| 2022-03-16 06:30:00 | SPY | ETF | 431.3 | 431.46 | 431.25 | 431.38 | 22328.0 |
| 2022-03-16 06:35:00 | SPY | ETF | 431.25 | 431.33 | 430.82 | 431.06 | 28257.0 |
| 2022-03-16 06:40:00 | SPY | ETF | 431.01 | 431.33 | 431.01 | 431.33 | 9375.0 |
| 2022-03-16 06:45:00 | SPY | ETF | 431.58 | 431.58 | 431.15 | 431.3 | 5564.0 |
| 2022-03-16 06:50:00 | SPY | ETF | 431.32 | 431.4 | 431.17 | 431.3 | 25266.0 |
| 2022-03-16 06:55:00 | SPY | ETF | 431.23 | 431.3 | 431.06 | 431.16 | 1012.0 |
| 2022-03-16 07:00:00 | SPY | ETF | 431.29 | 431.29 | 430.85 | 430.9 | 31186.0 |
| 2022-03-16 07:05:00 | SPY | ETF | 430.9 | 431.02 | 430.77 | 430.9 | 54067.0 |
| 2022-03-16 07:10:00 | SPY | ETF | 431.0 | 431.15 | 430.84 | 430.86 | 25800.0 |
| 2022-03-16 07:15:00 | SPY | ETF | 430.9 | 430.94 | 430.56 | 430.73 | 31949.0 |
| 2022-03-16 07:20:00 | SPY | ETF | 430.76 | 430.99 | 430.58 | 430.9 | 13720.0 |
| 2022-03-16 07:25:00 | SPY | ETF | 430.87 | 431.06 | 430.87 | 430.99 | 22087.0 |
| 2022-03-16 07:30:00 | SPY | ETF | 431.0 | 431.35 | 431.0 | 431.199 | 34881.0 |
| 2022-03-16 07:35:00 | SPY | ETF | 431.2 | 431.52 | 431.15 | 431.43 | 36737.0 |
| 2022-03-16 07:40:00 | SPY | ETF | 431.4 | 431.4 | 431.21 | 431.28 | 13525.0 |
| 2022-03-16 07:45:00 | SPY | ETF | 431.28 | 431.28 | 430.95 | 430.95 | 40983.0 |
| 2022-03-16 07:50:00 | SPY | ETF | 430.95 | 431.36 | 430.92 | 431.3 | 76602.0 |
| 2022-03-16 07:55:00 | SPY | ETF | 431.3 | 431.45 | 431.2 | 431.45 | 42899.0 |
| 2022-03-16 08:00:00 | SPY | ETF | 431.28 | 431.75 | 426.0 | 431.54 | 149406.0 |
| 2022-03-16 08:05:00 | SPY | ETF | 431.52 | 431.72 | 431.3887 | 431.72 | 128812.0 |
> showing 50 of 101,357 rows — these rows as CSV