PREVIEW / etf_5min / 2004-11-18
file: by_date/etf_5min/2004/2004-11-18.parquet size: 100 KB rows: 5,468
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-18 08:00:00 | SPY | ETF | 118.48 | 118.48 | 118.48 | 118.48 | 5000.0 |
| 2004-11-18 08:10:00 | SPY | ETF | 118.45 | 118.47 | 118.44 | 118.47 | 22500.0 |
| 2004-11-18 08:15:00 | SPY | ETF | 118.49 | 118.49 | 118.49 | 118.49 | 4000.0 |
| 2004-11-18 08:20:00 | SPY | ETF | 118.52 | 118.52 | 118.52 | 118.52 | 1000.0 |
| 2004-11-18 08:25:00 | SPY | ETF | 118.59 | 118.64 | 118.59 | 118.64 | 27900.0 |
| 2004-11-18 08:30:00 | SPY | ETF | 118.6 | 118.6 | 118.6 | 118.6 | 200.0 |
| 2004-11-18 08:40:00 | SPY | ETF | 118.57 | 118.57 | 118.57 | 118.57 | 1000.0 |
| 2004-11-18 08:45:00 | SPY | ETF | 118.55 | 118.55 | 118.55 | 118.55 | 600.0 |
| 2004-11-18 08:50:00 | SPY | ETF | 118.55 | 118.56 | 118.55 | 118.56 | 3000.0 |
| 2004-11-18 09:00:00 | SPY | ETF | 118.56 | 118.56 | 118.55 | 118.56 | 1200.0 |
| 2004-11-18 09:05:00 | SPY | ETF | 118.55 | 118.55 | 118.52 | 118.53 | 1200.0 |
| 2004-11-18 09:10:00 | SPY | ETF | 118.52 | 118.54 | 118.52 | 118.54 | 1000.0 |
| 2004-11-18 09:15:00 | SPY | ETF | 118.53 | 118.53 | 118.51 | 118.51 | 400.0 |
| 2004-11-18 09:20:00 | SPY | ETF | 118.5 | 118.53 | 118.5 | 118.53 | 700.0 |
| 2004-11-18 09:25:00 | SPY | ETF | 118.53 | 118.55 | 118.52 | 118.54 | 17600.0 |
| 2004-11-18 09:30:00 | SPY | ETF | 118.53 | 118.59 | 118.49 | 118.58 | 571600.0 |
| 2004-11-18 09:35:00 | SPY | ETF | 118.58 | 118.58 | 118.46 | 118.56 | 525700.0 |
| 2004-11-18 09:40:00 | SPY | ETF | 118.55 | 118.68 | 118.55 | 118.56 | 593100.0 |
| 2004-11-18 09:45:00 | SPY | ETF | 118.57 | 118.6 | 118.49 | 118.51 | 533600.0 |
| 2004-11-18 09:50:00 | SPY | ETF | 118.51 | 118.61 | 118.38 | 118.41 | 528400.0 |
| 2004-11-18 09:55:00 | SPY | ETF | 118.41 | 118.47 | 118.39 | 118.43 | 776200.0 |
| 2004-11-18 10:00:00 | SPY | ETF | 118.43 | 118.46 | 118.27 | 118.36 | 1212800.0 |
| 2004-11-18 10:05:00 | SPY | ETF | 118.36 | 118.4 | 118.24 | 118.32 | 732800.0 |
| 2004-11-18 10:10:00 | SPY | ETF | 118.32 | 118.44 | 118.25 | 118.43 | 546200.0 |
| 2004-11-18 10:15:00 | SPY | ETF | 118.43 | 118.43 | 118.23 | 118.29 | 731900.0 |
| 2004-11-18 10:20:00 | SPY | ETF | 118.29 | 118.38 | 118.24 | 118.37 | 360800.0 |
| 2004-11-18 10:25:00 | SPY | ETF | 118.37 | 118.44 | 118.31 | 118.34 | 325600.0 |
| 2004-11-18 10:30:00 | SPY | ETF | 118.34 | 118.4 | 118.28 | 118.37 | 256400.0 |
| 2004-11-18 10:35:00 | SPY | ETF | 118.37 | 118.51 | 118.37 | 118.43 | 539700.0 |
| 2004-11-18 10:40:00 | SPY | ETF | 118.44 | 118.56 | 118.41 | 118.51 | 485700.0 |
| 2004-11-18 10:45:00 | SPY | ETF | 118.5 | 118.6 | 118.48 | 118.55 | 537700.0 |
| 2004-11-18 10:50:00 | SPY | ETF | 118.56 | 118.61 | 118.52 | 118.59 | 439700.0 |
| 2004-11-18 10:55:00 | SPY | ETF | 118.59 | 118.72 | 118.58 | 118.62 | 910900.0 |
| 2004-11-18 11:00:00 | SPY | ETF | 118.63 | 118.66 | 118.54 | 118.56 | 281400.0 |
| 2004-11-18 11:05:00 | SPY | ETF | 118.56 | 118.66 | 118.52 | 118.66 | 513600.0 |
| 2004-11-18 11:10:00 | SPY | ETF | 118.65 | 118.66 | 118.57 | 118.6 | 306000.0 |
| 2004-11-18 11:15:00 | SPY | ETF | 118.6 | 118.62 | 118.52 | 118.56 | 203100.0 |
| 2004-11-18 11:20:00 | SPY | ETF | 118.56 | 118.59 | 118.53 | 118.58 | 157300.0 |
| 2004-11-18 11:25:00 | SPY | ETF | 118.58 | 118.58 | 118.53 | 118.55 | 297100.0 |
| 2004-11-18 11:30:00 | SPY | ETF | 118.56 | 118.59 | 118.52 | 118.57 | 324100.0 |
| 2004-11-18 11:35:00 | SPY | ETF | 118.56 | 118.68 | 118.55 | 118.67 | 365600.0 |
| 2004-11-18 11:40:00 | SPY | ETF | 118.67 | 118.68 | 118.63 | 118.64 | 190200.0 |
| 2004-11-18 11:45:00 | SPY | ETF | 118.66 | 118.66 | 118.55 | 118.56 | 354700.0 |
| 2004-11-18 11:50:00 | SPY | ETF | 118.57 | 118.6 | 118.54 | 118.58 | 103100.0 |
| 2004-11-18 11:55:00 | SPY | ETF | 118.58 | 118.61 | 118.55 | 118.57 | 205500.0 |
| 2004-11-18 12:00:00 | SPY | ETF | 118.57 | 118.64 | 118.49 | 118.58 | 696400.0 |
| 2004-11-18 12:05:00 | SPY | ETF | 118.57 | 118.62 | 118.44 | 118.48 | 312500.0 |
| 2004-11-18 12:10:00 | SPY | ETF | 118.49 | 118.54 | 118.46 | 118.5 | 330400.0 |
| 2004-11-18 12:15:00 | SPY | ETF | 118.51 | 118.54 | 118.47 | 118.5 | 133500.0 |
| 2004-11-18 12:20:00 | SPY | ETF | 118.5 | 118.67 | 118.49 | 118.6 | 242400.0 |
> showing 50 of 5,468 rows — these rows as CSV