PREVIEW / etf_5min / 2004-05-18
file: by_date/etf_5min/2004/2004-05-18.parquet size: 81 KB rows: 4,535
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-05-18 08:00:00 | SPY | ETF | 109.68 | 109.7 | 109.68 | 109.7 | 5800.0 |
| 2004-05-18 08:05:00 | SPY | ETF | 109.7 | 109.75 | 109.7 | 109.75 | 1700.0 |
| 2004-05-18 08:10:00 | SPY | ETF | 109.75 | 109.78 | 109.7 | 109.7 | 3400.0 |
| 2004-05-18 08:15:00 | SPY | ETF | 109.72 | 109.75 | 109.68 | 109.69 | 5100.0 |
| 2004-05-18 08:20:00 | SPY | ETF | 109.67 | 109.72 | 109.67 | 109.72 | 21400.0 |
| 2004-05-18 08:25:00 | SPY | ETF | 109.68 | 109.68 | 109.68 | 109.68 | 1200.0 |
| 2004-05-18 08:30:00 | SPY | ETF | 109.67 | 109.7 | 109.67 | 109.69 | 6800.0 |
| 2004-05-18 08:35:00 | SPY | ETF | 109.6 | 109.68 | 109.6 | 109.68 | 42300.0 |
| 2004-05-18 08:40:00 | SPY | ETF | 109.63 | 109.68 | 109.55 | 109.55 | 7600.0 |
| 2004-05-18 08:45:00 | SPY | ETF | 109.6 | 109.6 | 109.6 | 109.6 | 6000.0 |
| 2004-05-18 08:50:00 | SPY | ETF | 109.57 | 109.57 | 109.56 | 109.56 | 2500.0 |
| 2004-05-18 08:55:00 | SPY | ETF | 109.55 | 109.61 | 109.55 | 109.61 | 2000.0 |
| 2004-05-18 09:05:00 | SPY | ETF | 109.61 | 109.61 | 109.6 | 109.6 | 5400.0 |
| 2004-05-18 09:10:00 | SPY | ETF | 109.58 | 109.61 | 109.54 | 109.57 | 6300.0 |
| 2004-05-18 09:15:00 | SPY | ETF | 109.54 | 109.58 | 109.54 | 109.58 | 3600.0 |
| 2004-05-18 09:20:00 | SPY | ETF | 109.58 | 109.58 | 109.57 | 109.58 | 12600.0 |
| 2004-05-18 09:25:00 | SPY | ETF | 109.58 | 109.58 | 109.5 | 109.5 | 29600.0 |
| 2004-05-18 09:30:00 | SPY | ETF | 109.49 | 109.58 | 109.33 | 109.58 | 1042400.0 |
| 2004-05-18 09:35:00 | SPY | ETF | 109.58 | 109.72 | 109.54 | 109.62 | 976900.0 |
| 2004-05-18 09:40:00 | SPY | ETF | 109.61 | 109.63 | 109.48 | 109.55 | 952000.0 |
| 2004-05-18 09:45:00 | SPY | ETF | 109.54 | 109.67 | 109.45 | 109.47 | 514500.0 |
| 2004-05-18 09:50:00 | SPY | ETF | 109.47 | 109.51 | 109.33 | 109.49 | 476600.0 |
| 2004-05-18 09:55:00 | SPY | ETF | 109.5 | 109.51 | 109.34 | 109.44 | 519800.0 |
| 2004-05-18 10:00:00 | SPY | ETF | 109.46 | 109.669 | 109.34 | 109.669 | 653500.0 |
| 2004-05-18 10:05:00 | SPY | ETF | 109.64 | 109.67 | 109.53 | 109.65 | 829300.0 |
| 2004-05-18 10:10:00 | SPY | ETF | 109.65 | 109.71 | 109.46 | 109.57 | 625900.0 |
| 2004-05-18 10:15:00 | SPY | ETF | 109.55 | 109.55 | 109.42 | 109.53 | 264000.0 |
| 2004-05-18 10:20:00 | SPY | ETF | 109.5 | 109.65 | 109.45 | 109.57 | 175000.0 |
| 2004-05-18 10:25:00 | SPY | ETF | 109.58 | 109.62 | 109.48 | 109.52 | 170200.0 |
| 2004-05-18 10:30:00 | SPY | ETF | 109.53 | 109.55 | 109.45 | 109.5 | 473400.0 |
| 2004-05-18 10:35:00 | SPY | ETF | 109.5 | 109.66 | 109.46 | 109.58 | 443900.0 |
| 2004-05-18 10:40:00 | SPY | ETF | 109.58 | 109.86 | 109.56 | 109.82 | 433800.0 |
| 2004-05-18 10:45:00 | SPY | ETF | 109.81 | 109.9 | 109.72 | 109.74 | 488400.0 |
| 2004-05-18 10:50:00 | SPY | ETF | 109.75 | 109.81 | 109.67 | 109.76 | 393700.0 |
| 2004-05-18 10:55:00 | SPY | ETF | 109.76 | 109.86 | 109.74 | 109.78 | 264300.0 |
| 2004-05-18 11:00:00 | SPY | ETF | 109.78 | 109.89 | 109.73 | 109.75 | 265900.0 |
| 2004-05-18 11:05:00 | SPY | ETF | 109.74 | 109.81 | 109.7 | 109.76 | 201100.0 |
| 2004-05-18 11:10:00 | SPY | ETF | 109.77 | 109.8 | 109.67 | 109.76 | 668800.0 |
| 2004-05-18 11:15:00 | SPY | ETF | 109.76 | 109.85 | 109.69 | 109.8 | 523400.0 |
| 2004-05-18 11:20:00 | SPY | ETF | 109.79 | 109.83 | 109.68 | 109.73 | 201300.0 |
| 2004-05-18 11:25:00 | SPY | ETF | 109.7 | 109.78 | 109.66 | 109.72 | 157400.0 |
| 2004-05-18 11:30:00 | SPY | ETF | 109.71 | 109.76 | 109.67 | 109.69 | 108800.0 |
| 2004-05-18 11:35:00 | SPY | ETF | 109.71 | 109.76 | 109.67 | 109.7 | 110500.0 |
| 2004-05-18 11:40:00 | SPY | ETF | 109.71 | 109.76 | 109.64 | 109.74 | 194200.0 |
| 2004-05-18 11:45:00 | SPY | ETF | 109.73 | 109.75 | 109.66 | 109.69 | 411200.0 |
| 2004-05-18 11:50:00 | SPY | ETF | 109.71 | 109.8 | 109.69 | 109.75 | 471400.0 |
| 2004-05-18 11:55:00 | SPY | ETF | 109.73 | 109.79 | 109.7 | 109.72 | 131100.0 |
| 2004-05-18 12:00:00 | SPY | ETF | 109.73 | 109.77 | 109.69 | 109.73 | 140800.0 |
| 2004-05-18 12:05:00 | SPY | ETF | 109.73 | 109.8 | 109.7 | 109.75 | 232100.0 |
| 2004-05-18 12:10:00 | SPY | ETF | 109.74 | 109.92 | 109.74 | 109.84 | 481300.0 |
> showing 50 of 4,535 rows — these rows as CSV