PREVIEW / etf_5min / 2008-07-14
file: by_date/etf_5min/2008/2008-07-14.parquet size: 537 KB rows: 24,422
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-14 04:15:00 | SPY | ETF | 125.11 | 125.11 | 125.11 | 125.11 | 300.0 |
| 2008-07-14 04:20:00 | SPY | ETF | 125.09 | 125.16 | 125.09 | 125.14 | 300.0 |
| 2008-07-14 04:45:00 | SPY | ETF | 124.82 | 124.82 | 124.82 | 124.82 | 100.0 |
| 2008-07-14 04:55:00 | SPY | ETF | 124.77 | 124.77 | 124.77 | 124.77 | 100.0 |
| 2008-07-14 05:00:00 | SPY | ETF | 124.68 | 124.68 | 124.68 | 124.68 | 1000.0 |
| 2008-07-14 05:10:00 | SPY | ETF | 124.66 | 124.66 | 124.66 | 124.66 | 100.0 |
| 2008-07-14 05:15:00 | SPY | ETF | 124.64 | 124.65 | 124.64 | 124.65 | 200.0 |
| 2008-07-14 05:20:00 | SPY | ETF | 124.67 | 124.7 | 124.67 | 124.7 | 1500.0 |
| 2008-07-14 05:40:00 | SPY | ETF | 124.82 | 124.83 | 124.82 | 124.83 | 5000.0 |
| 2008-07-14 05:50:00 | SPY | ETF | 125.0 | 125.0 | 125.0 | 125.0 | 100.0 |
| 2008-07-14 06:05:00 | SPY | ETF | 124.98 | 125.03 | 124.98 | 125.03 | 300.0 |
| 2008-07-14 06:10:00 | SPY | ETF | 125.13 | 125.16 | 125.13 | 125.16 | 7200.0 |
| 2008-07-14 06:15:00 | SPY | ETF | 125.07 | 125.07 | 125.07 | 125.07 | 4500.0 |
| 2008-07-14 06:20:00 | SPY | ETF | 125.14 | 125.16 | 125.14 | 125.16 | 1100.0 |
| 2008-07-14 06:25:00 | SPY | ETF | 125.14 | 125.27 | 125.14 | 125.27 | 23100.0 |
| 2008-07-14 06:30:00 | SPY | ETF | 125.33 | 125.39 | 125.33 | 125.39 | 50000.0 |
| 2008-07-14 06:40:00 | SPY | ETF | 125.37 | 125.37 | 125.37 | 125.37 | 100.0 |
| 2008-07-14 06:45:00 | SPY | ETF | 125.32 | 125.38 | 125.31 | 125.34 | 6700.0 |
| 2008-07-14 06:50:00 | SPY | ETF | 125.35 | 125.47 | 125.35 | 125.45 | 15700.0 |
| 2008-07-14 06:55:00 | SPY | ETF | 125.45 | 125.5 | 125.44 | 125.5 | 9000.0 |
| 2008-07-14 07:00:00 | SPY | ETF | 125.45 | 125.66 | 125.45 | 125.61 | 72290.0 |
| 2008-07-14 07:05:00 | SPY | ETF | 125.63 | 125.71 | 125.6 | 125.71 | 14000.0 |
| 2008-07-14 07:10:00 | SPY | ETF | 125.66 | 125.77 | 125.66 | 125.76 | 195606.0 |
| 2008-07-14 07:15:00 | SPY | ETF | 125.8 | 125.92 | 125.76 | 125.8 | 192047.0 |
| 2008-07-14 07:20:00 | SPY | ETF | 125.8 | 125.8 | 125.58 | 125.63 | 335937.0 |
| 2008-07-14 07:25:00 | SPY | ETF | 125.67 | 125.86 | 125.6 | 125.68 | 312662.0 |
| 2008-07-14 07:30:00 | SPY | ETF | 125.68 | 125.68 | 125.5 | 125.64 | 107589.0 |
| 2008-07-14 07:35:00 | SPY | ETF | 125.65 | 125.68 | 125.54 | 125.54 | 354097.0 |
| 2008-07-14 07:40:00 | SPY | ETF | 125.53 | 125.55 | 125.46 | 125.5 | 200945.0 |
| 2008-07-14 07:45:00 | SPY | ETF | 125.49 | 125.49 | 125.41 | 125.47 | 118305.0 |
| 2008-07-14 07:50:00 | SPY | ETF | 125.48 | 125.48 | 125.42 | 125.45 | 87940.0 |
| 2008-07-14 07:55:00 | SPY | ETF | 125.46 | 125.48 | 125.42 | 125.47 | 83193.0 |
| 2008-07-14 08:00:00 | SPY | ETF | 125.49 | 125.83 | 125.44 | 125.44 | 1000773.0 |
| 2008-07-14 08:05:00 | SPY | ETF | 125.45 | 125.64 | 125.45 | 125.64 | 209196.0 |
| 2008-07-14 08:10:00 | SPY | ETF | 125.62 | 125.62 | 125.54 | 125.59 | 222961.0 |
| 2008-07-14 08:15:00 | SPY | ETF | 125.58 | 125.6 | 125.51 | 125.6 | 118238.0 |
| 2008-07-14 08:20:00 | SPY | ETF | 125.6 | 125.65 | 125.56 | 125.59 | 215289.0 |
| 2008-07-14 08:25:00 | SPY | ETF | 125.56 | 125.58 | 125.51 | 125.55 | 185867.0 |
| 2008-07-14 08:30:00 | SPY | ETF | 125.55 | 125.56 | 125.43 | 125.44 | 246654.0 |
| 2008-07-14 08:35:00 | SPY | ETF | 125.45 | 125.53 | 125.42 | 125.43 | 217257.0 |
| 2008-07-14 08:40:00 | SPY | ETF | 125.43 | 125.48 | 125.41 | 125.43 | 176348.0 |
| 2008-07-14 08:45:00 | SPY | ETF | 125.44 | 125.46 | 125.39 | 125.43 | 138385.0 |
| 2008-07-14 08:50:00 | SPY | ETF | 125.42 | 125.49 | 125.42 | 125.44 | 228520.0 |
| 2008-07-14 08:55:00 | SPY | ETF | 125.43 | 125.46 | 125.41 | 125.41 | 83941.0 |
| 2008-07-14 09:00:00 | SPY | ETF | 125.42 | 125.53 | 125.33 | 125.39 | 1168811.0 |
| 2008-07-14 09:05:00 | SPY | ETF | 125.4 | 125.42 | 125.29 | 125.29 | 513661.0 |
| 2008-07-14 09:10:00 | SPY | ETF | 125.29 | 125.35 | 125.22 | 125.24 | 263910.0 |
| 2008-07-14 09:15:00 | SPY | ETF | 125.25 | 125.39 | 125.23 | 125.33 | 555210.0 |
| 2008-07-14 09:20:00 | SPY | ETF | 125.34 | 125.46 | 124.82 | 125.42 | 568546.0 |
| 2008-07-14 09:25:00 | SPY | ETF | 125.4 | 125.48 | 125.21 | 125.26 | 580223.0 |
> showing 50 of 24,422 rows — these rows as CSV