PREVIEW / etf_5min / 2007-11-27
file: by_date/etf_5min/2007/2007-11-27.parquet size: 445 KB rows: 21,309
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-27 04:05:00 | SPY | ETF | 142.37 | 142.37 | 142.37 | 142.37 | 2500.0 |
| 2007-11-27 04:10:00 | SPY | ETF | 142.65 | 142.65 | 142.65 | 142.65 | 2500.0 |
| 2007-11-27 04:15:00 | SPY | ETF | 142.59 | 142.67 | 142.59 | 142.67 | 700.0 |
| 2007-11-27 04:20:00 | SPY | ETF | 142.61 | 142.61 | 142.61 | 142.61 | 1000.0 |
| 2007-11-27 04:25:00 | SPY | ETF | 142.71 | 142.71 | 142.71 | 142.71 | 500.0 |
| 2007-11-27 04:45:00 | SPY | ETF | 142.65 | 142.65 | 142.63 | 142.63 | 1200.0 |
| 2007-11-27 04:50:00 | SPY | ETF | 142.65 | 142.65 | 142.65 | 142.65 | 500.0 |
| 2007-11-27 05:00:00 | SPY | ETF | 142.6 | 142.6 | 142.6 | 142.6 | 5000.0 |
| 2007-11-27 05:10:00 | SPY | ETF | 142.4 | 142.4 | 142.4 | 142.4 | 1400.0 |
| 2007-11-27 05:20:00 | SPY | ETF | 142.42 | 142.45 | 142.42 | 142.45 | 4900.0 |
| 2007-11-27 05:25:00 | SPY | ETF | 142.35 | 142.35 | 142.35 | 142.35 | 2500.0 |
| 2007-11-27 05:30:00 | SPY | ETF | 142.41 | 142.41 | 142.41 | 142.41 | 2500.0 |
| 2007-11-27 06:05:00 | SPY | ETF | 142.38 | 142.38 | 142.31 | 142.31 | 5500.0 |
| 2007-11-27 06:20:00 | SPY | ETF | 142.36 | 142.4 | 142.36 | 142.4 | 500.0 |
| 2007-11-27 06:25:00 | SPY | ETF | 142.36 | 142.36 | 142.28 | 142.28 | 54800.0 |
| 2007-11-27 06:30:00 | SPY | ETF | 142.32 | 142.32 | 142.25 | 142.31 | 53200.0 |
| 2007-11-27 06:35:00 | SPY | ETF | 142.35 | 142.37 | 142.35 | 142.37 | 6500.0 |
| 2007-11-27 06:40:00 | SPY | ETF | 142.27 | 142.27 | 142.27 | 142.27 | 1000.0 |
| 2007-11-27 06:45:00 | SPY | ETF | 142.13 | 142.21 | 142.13 | 142.18 | 14400.0 |
| 2007-11-27 06:50:00 | SPY | ETF | 142.21 | 142.22 | 142.15 | 142.16 | 22700.0 |
| 2007-11-27 06:55:00 | SPY | ETF | 142.16 | 142.19 | 142.08 | 142.08 | 11000.0 |
| 2007-11-27 07:00:00 | SPY | ETF | 142.05 | 142.21 | 142.03 | 142.12 | 112000.0 |
| 2007-11-27 07:05:00 | SPY | ETF | 142.16 | 142.16 | 142.03 | 142.03 | 78300.0 |
| 2007-11-27 07:10:00 | SPY | ETF | 142.05 | 142.12 | 142.03 | 142.08 | 23800.0 |
| 2007-11-27 07:15:00 | SPY | ETF | 142.03 | 142.15 | 141.97 | 142.15 | 57000.0 |
| 2007-11-27 07:20:00 | SPY | ETF | 142.14 | 142.16 | 142.03 | 142.03 | 183100.0 |
| 2007-11-27 07:25:00 | SPY | ETF | 142.01 | 142.05 | 141.98 | 142.05 | 86900.0 |
| 2007-11-27 07:30:00 | SPY | ETF | 142.05 | 142.05 | 141.85 | 141.85 | 125400.0 |
| 2007-11-27 07:35:00 | SPY | ETF | 141.9 | 141.95 | 141.83 | 141.83 | 143600.0 |
| 2007-11-27 07:40:00 | SPY | ETF | 141.81 | 141.85 | 141.69 | 141.85 | 166500.0 |
| 2007-11-27 07:45:00 | SPY | ETF | 141.76 | 141.81 | 141.6 | 141.66 | 195500.0 |
| 2007-11-27 07:50:00 | SPY | ETF | 141.65 | 141.65 | 141.45 | 141.64 | 252800.0 |
| 2007-11-27 07:55:00 | SPY | ETF | 141.56 | 141.64 | 141.33 | 141.41 | 268400.0 |
| 2007-11-27 08:00:00 | SPY | ETF | 142.05 | 142.55 | 141.21 | 141.22 | 2267100.0 |
| 2007-11-27 08:05:00 | SPY | ETF | 141.27 | 141.44 | 141.2 | 141.32 | 340400.0 |
| 2007-11-27 08:10:00 | SPY | ETF | 141.33 | 141.56 | 141.32 | 141.49 | 487900.0 |
| 2007-11-27 08:15:00 | SPY | ETF | 141.51 | 141.62 | 141.48 | 141.57 | 440300.0 |
| 2007-11-27 08:20:00 | SPY | ETF | 141.58 | 141.65 | 141.52 | 141.52 | 176000.0 |
| 2007-11-27 08:25:00 | SPY | ETF | 141.5 | 141.55 | 141.4 | 141.45 | 88700.0 |
| 2007-11-27 08:30:00 | SPY | ETF | 141.49 | 142.55 | 141.36 | 141.48 | 260300.0 |
| 2007-11-27 08:35:00 | SPY | ETF | 141.46 | 141.66 | 141.39 | 141.64 | 219000.0 |
| 2007-11-27 08:40:00 | SPY | ETF | 141.65 | 141.75 | 141.59 | 141.74 | 1435700.0 |
| 2007-11-27 08:45:00 | SPY | ETF | 141.75 | 141.85 | 141.68 | 141.85 | 49700.0 |
| 2007-11-27 08:50:00 | SPY | ETF | 141.85 | 141.92 | 141.84 | 141.85 | 510700.0 |
| 2007-11-27 08:55:00 | SPY | ETF | 141.85 | 141.96 | 141.82 | 141.92 | 161700.0 |
| 2007-11-27 09:00:00 | SPY | ETF | 141.87 | 141.87 | 141.7 | 141.82 | 239600.0 |
| 2007-11-27 09:05:00 | SPY | ETF | 141.83 | 141.94 | 141.76 | 141.89 | 123500.0 |
| 2007-11-27 09:10:00 | SPY | ETF | 141.89 | 141.91 | 141.84 | 141.88 | 199400.0 |
| 2007-11-27 09:15:00 | SPY | ETF | 141.89 | 141.93 | 141.78 | 141.84 | 129920.0 |
| 2007-11-27 09:20:00 | SPY | ETF | 141.84 | 141.84 | 141.71 | 141.8 | 121000.0 |
> showing 50 of 21,309 rows — these rows as CSV