PREVIEW / etf_5min / 2005-03-24
file: by_date/etf_5min/2005/2005-03-24.parquet size: 113 KB rows: 6,071
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-24 08:00:00 | SPY | ETF | 117.54 | 117.57 | 117.54 | 117.55 | 19500.0 |
| 2005-03-24 08:05:00 | SPY | ETF | 117.55 | 117.57 | 117.55 | 117.57 | 2800.0 |
| 2005-03-24 08:10:00 | SPY | ETF | 117.55 | 117.55 | 117.54 | 117.54 | 600.0 |
| 2005-03-24 08:15:00 | SPY | ETF | 117.54 | 117.54 | 117.5 | 117.5 | 9300.0 |
| 2005-03-24 08:20:00 | SPY | ETF | 117.5 | 117.5 | 117.47 | 117.47 | 2200.0 |
| 2005-03-24 08:25:00 | SPY | ETF | 117.45 | 117.46 | 117.45 | 117.46 | 3500.0 |
| 2005-03-24 08:30:00 | SPY | ETF | 117.49 | 117.58 | 117.45 | 117.49 | 180100.0 |
| 2005-03-24 08:35:00 | SPY | ETF | 117.5 | 117.55 | 117.5 | 117.55 | 28300.0 |
| 2005-03-24 08:40:00 | SPY | ETF | 117.51 | 117.6 | 117.51 | 117.6 | 21000.0 |
| 2005-03-24 08:45:00 | SPY | ETF | 117.62 | 117.62 | 117.55 | 117.56 | 26000.0 |
| 2005-03-24 08:50:00 | SPY | ETF | 117.56 | 117.57 | 117.55 | 117.57 | 7400.0 |
| 2005-03-24 08:55:00 | SPY | ETF | 117.56 | 117.58 | 117.56 | 117.58 | 11100.0 |
| 2005-03-24 09:00:00 | SPY | ETF | 117.57 | 117.57 | 117.55 | 117.55 | 15300.0 |
| 2005-03-24 09:05:00 | SPY | ETF | 117.53 | 117.56 | 117.53 | 117.56 | 1400.0 |
| 2005-03-24 09:10:00 | SPY | ETF | 117.54 | 117.55 | 117.5 | 117.51 | 4300.0 |
| 2005-03-24 09:15:00 | SPY | ETF | 117.5 | 117.5 | 117.46 | 117.48 | 1700.0 |
| 2005-03-24 09:20:00 | SPY | ETF | 117.48 | 117.5 | 117.47 | 117.5 | 25300.0 |
| 2005-03-24 09:25:00 | SPY | ETF | 117.5 | 117.5 | 117.45 | 117.46 | 1300.0 |
| 2005-03-24 09:30:00 | SPY | ETF | 117.46 | 117.54 | 117.34 | 117.53 | 2055200.0 |
| 2005-03-24 09:35:00 | SPY | ETF | 117.51 | 117.61 | 117.35 | 117.56 | 1180600.0 |
| 2005-03-24 09:40:00 | SPY | ETF | 117.56 | 117.64 | 117.51 | 117.52 | 1276900.0 |
| 2005-03-24 09:45:00 | SPY | ETF | 117.53 | 117.68 | 117.47 | 117.59 | 1292200.0 |
| 2005-03-24 09:50:00 | SPY | ETF | 117.58 | 117.72 | 117.57 | 117.68 | 420700.0 |
| 2005-03-24 09:55:00 | SPY | ETF | 117.68 | 117.71 | 117.61 | 117.68 | 527200.0 |
| 2005-03-24 10:00:00 | SPY | ETF | 117.68 | 117.82 | 117.67 | 117.72 | 1598000.0 |
| 2005-03-24 10:05:00 | SPY | ETF | 117.71 | 117.8 | 117.65 | 117.71 | 790700.0 |
| 2005-03-24 10:10:00 | SPY | ETF | 117.71 | 117.75 | 117.63 | 117.65 | 671200.0 |
| 2005-03-24 10:15:00 | SPY | ETF | 117.64 | 117.68 | 117.53 | 117.63 | 731200.0 |
| 2005-03-24 10:20:00 | SPY | ETF | 117.63 | 117.68 | 117.53 | 117.59 | 396400.0 |
| 2005-03-24 10:25:00 | SPY | ETF | 117.59 | 117.73 | 117.55 | 117.72 | 415800.0 |
| 2005-03-24 10:30:00 | SPY | ETF | 117.73 | 117.82 | 117.66 | 117.67 | 697100.0 |
| 2005-03-24 10:35:00 | SPY | ETF | 117.66 | 117.78 | 117.63 | 117.68 | 378600.0 |
| 2005-03-24 10:40:00 | SPY | ETF | 117.69 | 117.75 | 117.63 | 117.73 | 290400.0 |
| 2005-03-24 10:45:00 | SPY | ETF | 117.72 | 117.72 | 117.62 | 117.64 | 295800.0 |
| 2005-03-24 10:50:00 | SPY | ETF | 117.64 | 117.71 | 117.61 | 117.7 | 282100.0 |
| 2005-03-24 10:55:00 | SPY | ETF | 117.7 | 117.7 | 117.62 | 117.63 | 363700.0 |
| 2005-03-24 11:00:00 | SPY | ETF | 117.63 | 117.66 | 117.53 | 117.56 | 457600.0 |
| 2005-03-24 11:05:00 | SPY | ETF | 117.57 | 117.58 | 117.35 | 117.41 | 1172100.0 |
| 2005-03-24 11:10:00 | SPY | ETF | 117.42 | 117.47 | 117.36 | 117.4 | 286600.0 |
| 2005-03-24 11:15:00 | SPY | ETF | 117.4 | 117.46 | 117.36 | 117.42 | 350200.0 |
| 2005-03-24 11:20:00 | SPY | ETF | 117.42 | 117.51 | 117.42 | 117.48 | 487400.0 |
| 2005-03-24 11:25:00 | SPY | ETF | 117.49 | 117.51 | 117.44 | 117.48 | 476900.0 |
| 2005-03-24 11:30:00 | SPY | ETF | 117.48 | 117.59 | 117.45 | 117.57 | 183300.0 |
| 2005-03-24 11:35:00 | SPY | ETF | 117.58 | 117.59 | 117.5 | 117.57 | 350900.0 |
| 2005-03-24 11:40:00 | SPY | ETF | 117.55 | 117.57 | 117.5 | 117.52 | 250200.0 |
| 2005-03-24 11:45:00 | SPY | ETF | 117.51 | 117.67 | 117.49 | 117.57 | 287500.0 |
| 2005-03-24 11:50:00 | SPY | ETF | 117.57 | 117.59 | 117.5 | 117.56 | 219500.0 |
| 2005-03-24 11:55:00 | SPY | ETF | 117.56 | 117.57 | 117.49 | 117.53 | 371600.0 |
| 2005-03-24 12:00:00 | SPY | ETF | 117.53 | 117.56 | 117.52 | 117.56 | 115500.0 |
| 2005-03-24 12:05:00 | SPY | ETF | 117.57 | 117.66 | 117.53 | 117.64 | 275000.0 |
> showing 50 of 6,071 rows — these rows as CSV