PREVIEW / etf_5min / 2007-04-05
file: by_date/etf_5min/2007/2007-04-05.parquet size: 274 KB rows: 13,670
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-04-05 04:40:00 | SPY | ETF | 143.76 | 143.76 | 143.76 | 143.76 | 100.0 |
| 2007-04-05 06:55:00 | SPY | ETF | 143.76 | 143.76 | 143.76 | 143.76 | 5000.0 |
| 2007-04-05 07:25:00 | SPY | ETF | 143.8 | 143.8 | 143.8 | 143.8 | 500.0 |
| 2007-04-05 07:30:00 | SPY | ETF | 143.8 | 143.8 | 143.8 | 143.8 | 5400.0 |
| 2007-04-05 07:35:00 | SPY | ETF | 143.81 | 143.81 | 143.8 | 143.8 | 3600.0 |
| 2007-04-05 07:40:00 | SPY | ETF | 143.77 | 143.77 | 143.76 | 143.76 | 5000.0 |
| 2007-04-05 07:55:00 | SPY | ETF | 143.82 | 143.82 | 143.82 | 143.82 | 200.0 |
| 2007-04-05 08:00:00 | SPY | ETF | 143.82 | 143.82 | 143.78 | 143.8 | 5400.0 |
| 2007-04-05 08:05:00 | SPY | ETF | 143.82 | 143.82 | 143.8 | 143.8 | 26200.0 |
| 2007-04-05 08:10:00 | SPY | ETF | 143.82 | 143.85 | 143.82 | 143.85 | 6100.0 |
| 2007-04-05 08:15:00 | SPY | ETF | 143.82 | 143.84 | 143.82 | 143.83 | 77000.0 |
| 2007-04-05 08:20:00 | SPY | ETF | 143.81 | 143.84 | 143.8 | 143.84 | 14500.0 |
| 2007-04-05 08:25:00 | SPY | ETF | 143.84 | 143.85 | 143.83 | 143.83 | 8000.0 |
| 2007-04-05 08:30:00 | SPY | ETF | 143.86 | 143.86 | 143.79 | 143.79 | 15600.0 |
| 2007-04-05 08:35:00 | SPY | ETF | 143.81 | 143.81 | 143.8 | 143.8 | 2200.0 |
| 2007-04-05 08:40:00 | SPY | ETF | 143.81 | 143.83 | 143.8 | 143.8 | 11100.0 |
| 2007-04-05 08:45:00 | SPY | ETF | 143.81 | 143.81 | 143.76 | 143.77 | 205100.0 |
| 2007-04-05 08:50:00 | SPY | ETF | 143.78 | 143.79 | 143.77 | 143.79 | 6900.0 |
| 2007-04-05 08:55:00 | SPY | ETF | 143.78 | 143.78 | 143.76 | 143.76 | 14500.0 |
| 2007-04-05 09:00:00 | SPY | ETF | 143.77 | 143.77 | 143.77 | 143.77 | 10400.0 |
| 2007-04-05 09:05:00 | SPY | ETF | 143.77 | 143.78 | 143.77 | 143.77 | 10700.0 |
| 2007-04-05 09:10:00 | SPY | ETF | 143.78 | 143.8 | 143.78 | 143.79 | 18400.0 |
| 2007-04-05 09:15:00 | SPY | ETF | 143.79 | 143.79 | 143.74 | 143.76 | 34000.0 |
| 2007-04-05 09:20:00 | SPY | ETF | 143.76 | 143.76 | 143.73 | 143.74 | 43200.0 |
| 2007-04-05 09:25:00 | SPY | ETF | 143.73 | 143.74 | 143.65 | 143.67 | 45200.0 |
| 2007-04-05 09:30:00 | SPY | ETF | 143.67 | 143.7 | 143.61 | 143.66 | 659800.0 |
| 2007-04-05 09:35:00 | SPY | ETF | 143.67 | 143.68 | 143.61 | 143.66 | 881300.0 |
| 2007-04-05 09:40:00 | SPY | ETF | 143.66 | 143.7 | 143.64 | 143.7 | 644200.0 |
| 2007-04-05 09:45:00 | SPY | ETF | 143.7 | 143.84 | 143.7 | 143.75 | 1461300.0 |
| 2007-04-05 09:50:00 | SPY | ETF | 143.75 | 143.83 | 143.738 | 143.8 | 1095300.0 |
| 2007-04-05 09:55:00 | SPY | ETF | 143.81 | 143.82 | 143.72 | 143.75 | 491800.0 |
| 2007-04-05 10:00:00 | SPY | ETF | 143.74 | 143.76 | 143.69 | 143.73 | 543800.0 |
| 2007-04-05 10:05:00 | SPY | ETF | 143.73 | 143.88 | 143.72 | 143.88 | 825700.0 |
| 2007-04-05 10:10:00 | SPY | ETF | 143.87 | 143.88 | 143.69 | 143.83 | 583300.0 |
| 2007-04-05 10:15:00 | SPY | ETF | 143.83 | 143.9 | 143.79 | 143.89 | 616700.0 |
| 2007-04-05 10:20:00 | SPY | ETF | 143.89 | 143.9 | 143.85 | 143.86 | 586500.0 |
| 2007-04-05 10:25:00 | SPY | ETF | 143.86 | 143.88 | 143.82 | 143.85 | 457925.0 |
| 2007-04-05 10:30:00 | SPY | ETF | 143.86 | 143.92 | 143.84 | 143.91 | 365900.0 |
| 2007-04-05 10:35:00 | SPY | ETF | 143.91 | 143.91 | 143.8 | 143.81 | 1704900.0 |
| 2007-04-05 10:40:00 | SPY | ETF | 143.82 | 143.86 | 143.81 | 143.86 | 325800.0 |
| 2007-04-05 10:45:00 | SPY | ETF | 143.855 | 143.91 | 143.85 | 143.91 | 494900.0 |
| 2007-04-05 10:50:00 | SPY | ETF | 143.91 | 143.93 | 143.87 | 143.89 | 381700.0 |
| 2007-04-05 10:55:00 | SPY | ETF | 143.89 | 143.92 | 143.88 | 143.9 | 255800.0 |
| 2007-04-05 11:00:00 | SPY | ETF | 143.9 | 143.9 | 143.86 | 143.9 | 446700.0 |
| 2007-04-05 11:05:00 | SPY | ETF | 143.9 | 143.93 | 143.88 | 143.9 | 375400.0 |
| 2007-04-05 11:10:00 | SPY | ETF | 143.9 | 143.91 | 143.86 | 143.89 | 318150.0 |
| 2007-04-05 11:15:00 | SPY | ETF | 143.8999 | 143.9 | 143.87 | 143.87 | 163400.0 |
| 2007-04-05 11:20:00 | SPY | ETF | 143.87 | 143.89 | 143.84 | 143.89 | 415800.0 |
| 2007-04-05 11:25:00 | SPY | ETF | 143.89 | 143.91 | 143.89 | 143.9 | 291300.0 |
| 2007-04-05 11:30:00 | SPY | ETF | 143.89 | 143.9 | 143.87 | 143.89 | 349000.0 |
> showing 50 of 13,670 rows — these rows as CSV