PREVIEW / etf_5min / 2006-10-23
file: by_date/etf_5min/2006/2006-10-23.parquet size: 243 KB rows: 11,964
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-23 07:00:00 | SPY | ETF | 136.77 | 136.77 | 136.77 | 136.77 | 300.0 |
| 2006-10-23 07:35:00 | SPY | ETF | 136.78 | 136.78 | 136.78 | 136.78 | 5000.0 |
| 2006-10-23 07:40:00 | SPY | ETF | 136.79 | 136.81 | 136.79 | 136.81 | 15400.0 |
| 2006-10-23 07:45:00 | SPY | ETF | 136.79 | 136.79 | 136.77 | 136.77 | 16000.0 |
| 2006-10-23 07:50:00 | SPY | ETF | 136.76 | 136.76 | 136.76 | 136.76 | 500.0 |
| 2006-10-23 07:55:00 | SPY | ETF | 136.77 | 136.77 | 136.75 | 136.77 | 2300.0 |
| 2006-10-23 08:00:00 | SPY | ETF | 136.77 | 136.83 | 136.75 | 136.77 | 34000.0 |
| 2006-10-23 08:05:00 | SPY | ETF | 136.75 | 136.78 | 136.75 | 136.77 | 8300.0 |
| 2006-10-23 08:10:00 | SPY | ETF | 136.81 | 136.81 | 136.79 | 136.79 | 6500.0 |
| 2006-10-23 08:15:00 | SPY | ETF | 136.81 | 136.85 | 136.8 | 136.85 | 11800.0 |
| 2006-10-23 08:20:00 | SPY | ETF | 136.83 | 136.83 | 136.79 | 136.79 | 10500.0 |
| 2006-10-23 08:25:00 | SPY | ETF | 136.81 | 136.82 | 136.81 | 136.82 | 6000.0 |
| 2006-10-23 08:30:00 | SPY | ETF | 136.83 | 136.85 | 136.81 | 136.83 | 37100.0 |
| 2006-10-23 08:35:00 | SPY | ETF | 136.84 | 136.84 | 136.83 | 136.83 | 29000.0 |
| 2006-10-23 08:40:00 | SPY | ETF | 136.84 | 136.85 | 136.83 | 136.85 | 172100.0 |
| 2006-10-23 08:45:00 | SPY | ETF | 136.84 | 136.84 | 136.76 | 136.77 | 57200.0 |
| 2006-10-23 08:50:00 | SPY | ETF | 136.77 | 136.82 | 136.43 | 136.48 | 183500.0 |
| 2006-10-23 08:55:00 | SPY | ETF | 136.49 | 136.58 | 136.47 | 136.57 | 98500.0 |
| 2006-10-23 09:00:00 | SPY | ETF | 136.57 | 136.57 | 136.5 | 136.55 | 71800.0 |
| 2006-10-23 09:05:00 | SPY | ETF | 136.55 | 136.62 | 136.54 | 136.59 | 48100.0 |
| 2006-10-23 09:10:00 | SPY | ETF | 136.56 | 136.57 | 136.51 | 136.56 | 161700.0 |
| 2006-10-23 09:15:00 | SPY | ETF | 136.55 | 136.79 | 136.53 | 136.79 | 329500.0 |
| 2006-10-23 09:20:00 | SPY | ETF | 136.55 | 136.59 | 136.55 | 136.59 | 14100.0 |
| 2006-10-23 09:25:00 | SPY | ETF | 136.57 | 136.58 | 136.53 | 136.55 | 46500.0 |
| 2006-10-23 09:30:00 | SPY | ETF | 136.56 | 136.58 | 136.44 | 136.55 | 1310500.0 |
| 2006-10-23 09:35:00 | SPY | ETF | 136.55 | 136.56 | 136.39 | 136.51 | 1126800.0 |
| 2006-10-23 09:40:00 | SPY | ETF | 136.52 | 136.61 | 136.48 | 136.58 | 832500.0 |
| 2006-10-23 09:45:00 | SPY | ETF | 136.59 | 136.82 | 136.54 | 136.79 | 1638400.0 |
| 2006-10-23 09:50:00 | SPY | ETF | 136.78 | 136.84 | 136.71 | 136.82 | 1819900.0 |
| 2006-10-23 09:55:00 | SPY | ETF | 136.82 | 136.92 | 136.78 | 136.87 | 1043300.0 |
| 2006-10-23 10:00:00 | SPY | ETF | 136.88 | 136.94 | 136.85 | 136.94 | 962500.0 |
| 2006-10-23 10:05:00 | SPY | ETF | 136.94 | 137.2 | 136.93 | 137.19 | 1815100.0 |
| 2006-10-23 10:10:00 | SPY | ETF | 137.14 | 137.27 | 137.14 | 137.18 | 2122500.0 |
| 2006-10-23 10:15:00 | SPY | ETF | 137.18 | 137.3 | 137.16 | 137.26 | 1099700.0 |
| 2006-10-23 10:20:00 | SPY | ETF | 137.2588 | 137.35 | 137.22 | 137.33 | 736000.0 |
| 2006-10-23 10:25:00 | SPY | ETF | 137.34 | 137.55 | 137.34 | 137.53 | 1608200.0 |
| 2006-10-23 10:30:00 | SPY | ETF | 137.53 | 137.57 | 137.48 | 137.53 | 899600.0 |
| 2006-10-23 10:35:00 | SPY | ETF | 137.53 | 137.57 | 137.46 | 137.5 | 791500.0 |
| 2006-10-23 10:40:00 | SPY | ETF | 137.5 | 137.52 | 137.43 | 137.44 | 766000.0 |
| 2006-10-23 10:45:00 | SPY | ETF | 137.44 | 137.54 | 137.44 | 137.47 | 669600.0 |
| 2006-10-23 10:50:00 | SPY | ETF | 137.4792 | 137.48 | 137.37 | 137.39 | 717000.0 |
| 2006-10-23 10:55:00 | SPY | ETF | 137.39 | 137.43 | 137.38 | 137.41 | 1549400.0 |
| 2006-10-23 11:00:00 | SPY | ETF | 137.42 | 137.52 | 137.42 | 137.49 | 864400.0 |
| 2006-10-23 11:05:00 | SPY | ETF | 137.49 | 137.67 | 137.48 | 137.65 | 1289100.0 |
| 2006-10-23 11:10:00 | SPY | ETF | 137.65 | 137.72 | 137.65 | 137.68 | 1803300.0 |
| 2006-10-23 11:15:00 | SPY | ETF | 137.69 | 137.75 | 137.66 | 137.6601 | 1459200.0 |
| 2006-10-23 11:20:00 | SPY | ETF | 137.67 | 137.7 | 137.6 | 137.6 | 621700.0 |
| 2006-10-23 11:25:00 | SPY | ETF | 137.6 | 137.6 | 137.51 | 137.53 | 298800.0 |
| 2006-10-23 11:30:00 | SPY | ETF | 137.5 | 137.62 | 137.5 | 137.54 | 842100.0 |
| 2006-10-23 11:35:00 | SPY | ETF | 137.54 | 137.56 | 137.5 | 137.54 | 1046900.0 |
> showing 50 of 11,964 rows — these rows as CSV