PREVIEW / etf_30min / 2021-02-10
file: by_date/etf_30min/2021/2021-02-10.parquet size: 630 KB rows: 24,058
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 |
|---|---|---|---|---|---|---|---|
| 2021-02-10 04:00:00 | SPY | ETF | 391.5 | 391.7 | 391.5 | 391.57 | 12197.0 |
| 2021-02-10 04:30:00 | SPY | ETF | 391.57 | 391.62 | 391.45 | 391.45 | 505.0 |
| 2021-02-10 05:00:00 | SPY | ETF | 391.56 | 391.6 | 391.39 | 391.5 | 3440.0 |
| 2021-02-10 05:30:00 | SPY | ETF | 391.35 | 391.59 | 391.35 | 391.58 | 8900.0 |
| 2021-02-10 06:00:00 | SPY | ETF | 391.62 | 391.9 | 391.61 | 391.83 | 11588.0 |
| 2021-02-10 06:30:00 | SPY | ETF | 391.62 | 391.8 | 391.45 | 391.45 | 38643.0 |
| 2021-02-10 07:00:00 | SPY | ETF | 391.45 | 391.51 | 391.29 | 391.5 | 95228.0 |
| 2021-02-10 07:30:00 | SPY | ETF | 391.49 | 391.58 | 391.4 | 391.53 | 46734.0 |
| 2021-02-10 08:00:00 | SPY | ETF | 391.49 | 391.99 | 391.36 | 391.44 | 45385.0 |
| 2021-02-10 08:30:00 | SPY | ETF | 391.55 | 392.46 | 391.5 | 392.12 | 326891.0 |
| 2021-02-10 09:00:00 | SPY | ETF | 392.12 | 392.19 | 391.92 | 392.1 | 98069.0 |
| 2021-02-10 09:30:00 | SPY | ETF | 392.12 | 392.28 | 391.37 | 391.54 | 3563363.0 |
| 2021-02-10 10:00:00 | SPY | ETF | 391.55 | 391.93 | 388.681 | 389.36 | 5878237.0 |
| 2021-02-10 10:30:00 | SPY | ETF | 389.36 | 389.77 | 387.5 | 389.699 | 8534212.0 |
| 2021-02-10 11:00:00 | SPY | ETF | 389.69 | 390.12 | 388.85 | 389.29 | 2920520.0 |
| 2021-02-10 11:30:00 | SPY | ETF | 389.2881 | 390.0499 | 388.85 | 389.5081 | 2042363.0 |
| 2021-02-10 12:00:00 | SPY | ETF | 389.49 | 389.56 | 388.66 | 389.34 | 2243090.0 |
| 2021-02-10 12:30:00 | SPY | ETF | 389.31 | 389.81 | 389.0099 | 389.55 | 1563472.0 |
| 2021-02-10 13:00:00 | SPY | ETF | 389.55 | 389.94 | 389.39 | 389.87 | 1027129.0 |
| 2021-02-10 13:30:00 | SPY | ETF | 389.8713 | 390.1 | 389.41 | 389.645 | 1320787.0 |
| 2021-02-10 14:00:00 | SPY | ETF | 389.65 | 390.41 | 389.45 | 390.38 | 2372281.0 |
| 2021-02-10 14:30:00 | SPY | ETF | 390.39 | 390.85 | 390.2 | 390.79 | 2413887.0 |
| 2021-02-10 15:00:00 | SPY | ETF | 390.7911 | 391.07 | 390.19 | 390.42 | 2551708.0 |
| 2021-02-10 15:30:00 | SPY | ETF | 390.415 | 390.6 | 389.37 | 390.1 | 5971213.0 |
| 2021-02-10 16:00:00 | SPY | ETF | 390.09 | 390.6 | 390.07 | 390.39 | 2279203.0 |
| 2021-02-10 16:30:00 | SPY | ETF | 390.39 | 390.52 | 390.08 | 390.42 | 112686.0 |
| 2021-02-10 17:00:00 | SPY | ETF | 390.43 | 390.57 | 390.3 | 390.31 | 44442.0 |
| 2021-02-10 17:30:00 | SPY | ETF | 390.3301 | 390.45 | 390.3301 | 390.36 | 15560.0 |
| 2021-02-10 18:00:00 | SPY | ETF | 390.43 | 390.45 | 390.09 | 390.23 | 74654.0 |
| 2021-02-10 18:30:00 | SPY | ETF | 390.08 | 390.41 | 390.08 | 390.21 | 273109.0 |
| 2021-02-10 19:00:00 | SPY | ETF | 390.21 | 390.21 | 389.73 | 389.7501 | 40357.0 |
| 2021-02-10 19:30:00 | SPY | ETF | 389.8 | 389.8 | 389.15 | 389.23 | 68357.0 |
| 2021-02-10 04:00:00 | QQQ | ETF | 335.27 | 335.28 | 334.99 | 335.05 | 17494.0 |
| 2021-02-10 04:30:00 | QQQ | ETF | 335.02 | 335.05 | 334.9 | 335.05 | 14923.0 |
| 2021-02-10 05:00:00 | QQQ | ETF | 335.0 | 335.06 | 334.91 | 334.95 | 7993.0 |
| 2021-02-10 05:30:00 | QQQ | ETF | 334.91 | 334.98 | 334.82 | 334.98 | 6699.0 |
| 2021-02-10 06:00:00 | QQQ | ETF | 334.98 | 335.05 | 334.89 | 334.89 | 6533.0 |
| 2021-02-10 06:30:00 | QQQ | ETF | 334.86 | 334.86 | 334.52 | 334.58 | 11199.0 |
| 2021-02-10 07:00:00 | QQQ | ETF | 334.51 | 334.65 | 334.41 | 334.52 | 57176.0 |
| 2021-02-10 07:30:00 | QQQ | ETF | 334.5 | 334.67 | 334.5 | 334.57 | 50101.0 |
| 2021-02-10 08:00:00 | QQQ | ETF | 334.49 | 335.43 | 333.51 | 334.43 | 48322.0 |
| 2021-02-10 08:30:00 | QQQ | ETF | 334.44 | 335.19 | 334.44 | 335.05 | 121665.0 |
| 2021-02-10 09:00:00 | QQQ | ETF | 335.01 | 335.07 | 334.79 | 334.98 | 66575.0 |
| 2021-02-10 09:30:00 | QQQ | ETF | 335.0 | 335.46 | 334.33 | 334.845 | 1847084.0 |
| 2021-02-10 10:00:00 | QQQ | ETF | 334.865 | 335.24 | 330.61 | 331.76 | 3613870.0 |
| 2021-02-10 10:30:00 | QQQ | ETF | 331.7901 | 332.12 | 329.5 | 331.7099 | 4410775.0 |
| 2021-02-10 11:00:00 | QQQ | ETF | 331.675 | 332.295 | 330.7 | 331.4028 | 1810028.0 |
| 2021-02-10 11:30:00 | QQQ | ETF | 331.43 | 332.54 | 330.96 | 331.885 | 1276846.0 |
| 2021-02-10 12:00:00 | QQQ | ETF | 331.89 | 332.1272 | 331.115 | 331.99 | 1100687.0 |
| 2021-02-10 12:30:00 | QQQ | ETF | 331.96 | 332.4 | 331.64 | 332.19 | 600253.0 |
> showing 50 of 24,058 rows — these rows as CSV