PREVIEW / etf_5min / 2005-09-07
file: by_date/etf_5min/2005/2005-09-07.parquet size: 122 KB rows: 7,003
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-09-07 07:00:00 | SPY | ETF | 123.6 | 123.61 | 123.6 | 123.61 | 7000.0 |
| 2005-09-07 07:40:00 | SPY | ETF | 123.63 | 123.64 | 123.63 | 123.64 | 3000.0 |
| 2005-09-07 07:45:00 | SPY | ETF | 123.67 | 123.67 | 123.67 | 123.67 | 10000.0 |
| 2005-09-07 07:50:00 | SPY | ETF | 123.72 | 123.72 | 123.72 | 123.72 | 100.0 |
| 2005-09-07 07:55:00 | SPY | ETF | 123.7 | 123.7 | 123.7 | 123.7 | 200.0 |
| 2005-09-07 08:00:00 | SPY | ETF | 123.7 | 123.7 | 123.7 | 123.7 | 5300.0 |
| 2005-09-07 08:05:00 | SPY | ETF | 123.7 | 123.7 | 123.68 | 123.68 | 2600.0 |
| 2005-09-07 08:10:00 | SPY | ETF | 123.67 | 123.67 | 123.67 | 123.67 | 100.0 |
| 2005-09-07 08:20:00 | SPY | ETF | 123.67 | 123.67 | 123.67 | 123.67 | 1000.0 |
| 2005-09-07 08:25:00 | SPY | ETF | 123.68 | 123.74 | 123.62 | 123.74 | 47400.0 |
| 2005-09-07 08:30:00 | SPY | ETF | 123.66 | 123.66 | 123.58 | 123.58 | 26900.0 |
| 2005-09-07 08:35:00 | SPY | ETF | 123.56 | 123.61 | 123.55 | 123.6 | 59800.0 |
| 2005-09-07 08:40:00 | SPY | ETF | 123.58 | 123.69 | 123.58 | 123.6 | 239300.0 |
| 2005-09-07 08:45:00 | SPY | ETF | 123.59 | 123.59 | 123.56 | 123.56 | 29500.0 |
| 2005-09-07 08:50:00 | SPY | ETF | 123.6 | 123.61 | 123.6 | 123.6 | 30000.0 |
| 2005-09-07 08:55:00 | SPY | ETF | 123.59 | 123.6 | 123.59 | 123.6 | 9600.0 |
| 2005-09-07 09:00:00 | SPY | ETF | 123.61 | 123.62 | 123.61 | 123.61 | 4200.0 |
| 2005-09-07 09:05:00 | SPY | ETF | 123.6 | 123.62 | 123.6 | 123.61 | 6400.0 |
| 2005-09-07 09:10:00 | SPY | ETF | 123.61 | 123.61 | 123.6 | 123.6 | 5500.0 |
| 2005-09-07 09:15:00 | SPY | ETF | 123.59 | 123.6 | 123.59 | 123.6 | 1700.0 |
| 2005-09-07 09:20:00 | SPY | ETF | 123.61 | 123.68 | 123.61 | 123.61 | 42000.0 |
| 2005-09-07 09:25:00 | SPY | ETF | 123.62 | 123.65 | 123.62 | 123.64 | 131000.0 |
| 2005-09-07 09:30:00 | SPY | ETF | 123.63 | 123.7 | 123.61 | 123.67 | 678700.0 |
| 2005-09-07 09:35:00 | SPY | ETF | 123.68 | 123.71 | 123.62 | 123.65 | 545900.0 |
| 2005-09-07 09:40:00 | SPY | ETF | 123.64 | 123.71 | 123.59 | 123.6 | 369400.0 |
| 2005-09-07 09:45:00 | SPY | ETF | 123.6 | 123.72 | 123.55 | 123.68 | 537400.0 |
| 2005-09-07 09:50:00 | SPY | ETF | 123.66 | 123.69 | 123.5 | 123.55 | 576000.0 |
| 2005-09-07 09:55:00 | SPY | ETF | 123.55 | 123.63 | 123.52 | 123.57 | 433100.0 |
| 2005-09-07 10:00:00 | SPY | ETF | 123.58 | 123.63 | 123.53 | 123.55 | 431700.0 |
| 2005-09-07 10:05:00 | SPY | ETF | 123.55 | 123.61 | 123.48 | 123.51 | 694700.0 |
| 2005-09-07 10:10:00 | SPY | ETF | 123.5 | 123.61 | 123.48 | 123.53 | 461200.0 |
| 2005-09-07 10:15:00 | SPY | ETF | 123.52 | 123.55 | 123.46 | 123.53 | 813200.0 |
| 2005-09-07 10:20:00 | SPY | ETF | 123.52 | 123.58 | 123.48 | 123.54 | 344700.0 |
| 2005-09-07 10:25:00 | SPY | ETF | 123.53 | 123.59 | 123.48 | 123.54 | 334000.0 |
| 2005-09-07 10:30:00 | SPY | ETF | 123.52 | 123.63 | 123.49 | 123.6 | 483600.0 |
| 2005-09-07 10:35:00 | SPY | ETF | 123.6 | 123.72 | 123.58 | 123.7 | 582900.0 |
| 2005-09-07 10:40:00 | SPY | ETF | 123.69 | 123.8 | 123.54 | 123.73 | 921500.0 |
| 2005-09-07 10:45:00 | SPY | ETF | 123.72 | 123.77 | 123.64 | 123.66 | 1052000.0 |
| 2005-09-07 10:50:00 | SPY | ETF | 123.67 | 123.8 | 123.66 | 123.78 | 633900.0 |
| 2005-09-07 10:55:00 | SPY | ETF | 123.78 | 123.82 | 123.73 | 123.81 | 348300.0 |
| 2005-09-07 11:00:00 | SPY | ETF | 123.82 | 123.96 | 123.79 | 123.93 | 1102100.0 |
| 2005-09-07 11:05:00 | SPY | ETF | 123.92 | 123.95 | 123.82 | 123.86 | 598600.0 |
| 2005-09-07 11:10:00 | SPY | ETF | 123.86 | 123.87 | 123.77 | 123.79 | 702500.0 |
| 2005-09-07 11:15:00 | SPY | ETF | 123.78 | 123.79 | 123.64 | 123.65 | 401200.0 |
| 2005-09-07 11:20:00 | SPY | ETF | 123.65 | 123.77 | 123.63 | 123.71 | 1029700.0 |
| 2005-09-07 11:25:00 | SPY | ETF | 123.71 | 123.8 | 123.66 | 123.69 | 149600.0 |
| 2005-09-07 11:30:00 | SPY | ETF | 123.69 | 123.72 | 123.65 | 123.69 | 110400.0 |
| 2005-09-07 11:35:00 | SPY | ETF | 123.7 | 123.75 | 123.69 | 123.75 | 160300.0 |
| 2005-09-07 11:40:00 | SPY | ETF | 123.75 | 123.77 | 123.69 | 123.76 | 156800.0 |
| 2005-09-07 11:45:00 | SPY | ETF | 123.75 | 123.79 | 123.74 | 123.77 | 122800.0 |
> showing 50 of 7,003 rows — these rows as CSV