PREVIEW / etf_5min / 2020-06-11
file: by_date/etf_5min/2020/2020-06-11.parquet size: 1.9 MB rows: 88,262
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-11 04:00:00 | SPY | ETF | 313.45 | 313.45 | 312.8 | 312.96 | 48293.0 |
| 2020-06-11 04:05:00 | SPY | ETF | 313.13 | 313.54 | 313.01 | 313.39 | 32931.0 |
| 2020-06-11 04:10:00 | SPY | ETF | 313.48 | 313.8 | 313.33 | 313.64 | 12300.0 |
| 2020-06-11 04:15:00 | SPY | ETF | 313.56 | 313.71 | 313.44 | 313.6 | 8914.0 |
| 2020-06-11 04:20:00 | SPY | ETF | 313.63 | 313.67 | 313.55 | 313.61 | 5400.0 |
| 2020-06-11 04:25:00 | SPY | ETF | 313.67 | 313.72 | 313.3 | 313.3 | 10566.0 |
| 2020-06-11 04:30:00 | SPY | ETF | 313.32 | 313.74 | 313.27 | 313.67 | 7754.0 |
| 2020-06-11 04:35:00 | SPY | ETF | 313.7 | 313.87 | 313.61 | 313.61 | 22480.0 |
| 2020-06-11 04:40:00 | SPY | ETF | 313.44 | 313.5 | 312.8 | 312.92 | 13918.0 |
| 2020-06-11 04:45:00 | SPY | ETF | 312.82 | 312.83 | 312.57 | 312.74 | 20483.0 |
| 2020-06-11 04:50:00 | SPY | ETF | 312.6 | 312.77 | 312.34 | 312.73 | 33885.0 |
| 2020-06-11 04:55:00 | SPY | ETF | 312.5 | 312.88 | 312.5 | 312.85 | 13532.0 |
| 2020-06-11 05:00:00 | SPY | ETF | 312.79 | 313.04 | 312.6 | 313.04 | 35627.0 |
| 2020-06-11 05:05:00 | SPY | ETF | 313.04 | 313.28 | 312.94 | 313.1 | 14986.0 |
| 2020-06-11 05:10:00 | SPY | ETF | 313.13 | 313.3 | 312.99 | 313.21 | 3789.0 |
| 2020-06-11 05:15:00 | SPY | ETF | 313.18 | 314.12 | 313.18 | 314.02 | 32593.0 |
| 2020-06-11 05:20:00 | SPY | ETF | 314.02 | 314.17 | 313.83 | 313.86 | 15297.0 |
| 2020-06-11 05:25:00 | SPY | ETF | 313.78 | 314.1 | 313.78 | 313.97 | 5669.0 |
| 2020-06-11 05:30:00 | SPY | ETF | 314.08 | 314.51 | 314.0 | 314.44 | 26953.0 |
| 2020-06-11 05:35:00 | SPY | ETF | 314.44 | 314.5 | 314.31 | 314.37 | 16430.0 |
| 2020-06-11 05:40:00 | SPY | ETF | 314.43 | 314.5 | 314.35 | 314.38 | 4405.0 |
| 2020-06-11 05:45:00 | SPY | ETF | 314.32 | 314.5 | 314.29 | 314.35 | 9900.0 |
| 2020-06-11 05:50:00 | SPY | ETF | 314.41 | 314.57 | 314.4 | 314.52 | 14607.0 |
| 2020-06-11 05:55:00 | SPY | ETF | 314.53 | 314.83 | 314.41 | 314.58 | 27049.0 |
| 2020-06-11 06:00:00 | SPY | ETF | 314.7 | 314.75 | 314.43 | 314.49 | 21002.0 |
| 2020-06-11 06:05:00 | SPY | ETF | 314.52 | 314.65 | 314.07 | 314.15 | 16481.0 |
| 2020-06-11 06:10:00 | SPY | ETF | 314.08 | 314.14 | 313.95 | 314.07 | 3620.0 |
| 2020-06-11 06:15:00 | SPY | ETF | 314.05 | 314.05 | 313.9 | 313.99 | 3461.0 |
| 2020-06-11 06:20:00 | SPY | ETF | 314.06 | 314.3 | 314.06 | 314.25 | 4475.0 |
| 2020-06-11 06:25:00 | SPY | ETF | 314.18 | 314.25 | 313.89 | 313.9 | 13050.0 |
| 2020-06-11 06:30:00 | SPY | ETF | 313.96 | 314.1 | 313.78 | 313.82 | 35185.0 |
| 2020-06-11 06:35:00 | SPY | ETF | 313.85 | 313.85 | 313.31 | 313.5 | 46524.0 |
| 2020-06-11 06:40:00 | SPY | ETF | 313.48 | 313.6 | 313.4 | 313.47 | 10447.0 |
| 2020-06-11 06:45:00 | SPY | ETF | 313.57 | 313.79 | 313.25 | 313.78 | 6286.0 |
| 2020-06-11 06:50:00 | SPY | ETF | 313.8 | 313.86 | 313.68 | 313.68 | 5018.0 |
| 2020-06-11 06:55:00 | SPY | ETF | 313.65 | 313.72 | 313.2 | 313.3 | 36752.0 |
| 2020-06-11 07:00:00 | SPY | ETF | 313.4 | 313.56 | 313.34 | 313.5 | 89844.0 |
| 2020-06-11 07:05:00 | SPY | ETF | 313.48 | 313.69 | 313.09 | 313.09 | 40414.0 |
| 2020-06-11 07:10:00 | SPY | ETF | 313.1 | 313.25 | 312.67 | 312.74 | 60296.0 |
| 2020-06-11 07:15:00 | SPY | ETF | 312.64 | 312.69 | 312.15 | 312.25 | 135622.0 |
| 2020-06-11 07:20:00 | SPY | ETF | 312.18 | 312.63 | 311.95 | 312.59 | 128372.0 |
| 2020-06-11 07:25:00 | SPY | ETF | 312.6 | 312.9 | 312.48 | 312.82 | 121076.0 |
| 2020-06-11 07:30:00 | SPY | ETF | 312.79 | 312.91 | 312.5 | 312.81 | 77571.0 |
| 2020-06-11 07:35:00 | SPY | ETF | 312.75 | 312.85 | 312.51 | 312.51 | 92170.0 |
| 2020-06-11 07:40:00 | SPY | ETF | 312.58 | 312.83 | 312.56 | 312.56 | 44042.0 |
| 2020-06-11 07:45:00 | SPY | ETF | 312.59 | 312.65 | 312.44 | 312.44 | 41403.0 |
| 2020-06-11 07:50:00 | SPY | ETF | 312.46 | 312.46 | 311.77 | 312.07 | 113824.0 |
| 2020-06-11 07:55:00 | SPY | ETF | 312.07 | 312.46 | 312.0 | 312.411 | 93002.0 |
| 2020-06-11 08:00:00 | SPY | ETF | 318.2822 | 318.2822 | 311.79 | 315.65 | 713640.0 |
| 2020-06-11 08:05:00 | SPY | ETF | 312.04 | 312.38 | 311.99 | 312.0 | 122217.0 |
> showing 50 of 88,262 rows — these rows as CSV