PREVIEW / etf_5min / 2007-02-06
file: by_date/etf_5min/2007/2007-02-06.parquet size: 285 KB rows: 13,726
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-02-06 07:35:00 | SPY | ETF | 145.03 | 145.08 | 145.0 | 145.06 | 7900.0 |
| 2007-02-06 07:40:00 | SPY | ETF | 145.03 | 145.03 | 145.03 | 145.03 | 5800.0 |
| 2007-02-06 07:45:00 | SPY | ETF | 145.05 | 145.05 | 145.05 | 145.05 | 100.0 |
| 2007-02-06 07:50:00 | SPY | ETF | 145.05 | 145.05 | 145.05 | 145.05 | 300.0 |
| 2007-02-06 07:55:00 | SPY | ETF | 145.05 | 145.05 | 145.05 | 145.05 | 500.0 |
| 2007-02-06 08:00:00 | SPY | ETF | 145.05 | 145.08 | 144.98 | 145.05 | 101000.0 |
| 2007-02-06 08:05:00 | SPY | ETF | 145.05 | 145.05 | 145.04 | 145.04 | 3800.0 |
| 2007-02-06 08:10:00 | SPY | ETF | 145.04 | 145.06 | 145.03 | 145.06 | 10200.0 |
| 2007-02-06 08:15:00 | SPY | ETF | 145.05 | 145.05 | 145.03 | 145.03 | 16000.0 |
| 2007-02-06 08:20:00 | SPY | ETF | 145.04 | 145.08 | 145.04 | 145.06 | 10800.0 |
| 2007-02-06 08:25:00 | SPY | ETF | 145.06 | 145.1 | 145.06 | 145.06 | 21200.0 |
| 2007-02-06 08:30:00 | SPY | ETF | 145.04 | 145.07 | 145.03 | 145.04 | 459600.0 |
| 2007-02-06 08:35:00 | SPY | ETF | 145.02 | 145.03 | 145.0 | 145.02 | 11100.0 |
| 2007-02-06 08:40:00 | SPY | ETF | 145.01 | 145.03 | 145.0 | 145.0 | 5300.0 |
| 2007-02-06 08:45:00 | SPY | ETF | 144.99 | 144.99 | 144.99 | 144.99 | 7700.0 |
| 2007-02-06 08:50:00 | SPY | ETF | 145.0 | 145.0 | 144.98 | 144.99 | 103300.0 |
| 2007-02-06 08:55:00 | SPY | ETF | 145.0 | 145.01 | 144.99 | 145.01 | 4300.0 |
| 2007-02-06 09:00:00 | SPY | ETF | 145.0 | 145.0 | 144.99 | 145.0 | 3700.0 |
| 2007-02-06 09:05:00 | SPY | ETF | 145.0 | 145.0 | 144.98 | 144.98 | 13500.0 |
| 2007-02-06 09:10:00 | SPY | ETF | 145.0 | 145.0 | 144.99 | 144.99 | 6900.0 |
| 2007-02-06 09:15:00 | SPY | ETF | 144.99 | 145.0 | 144.96 | 144.96 | 7600.0 |
| 2007-02-06 09:20:00 | SPY | ETF | 144.96 | 144.96 | 144.93 | 144.95 | 24000.0 |
| 2007-02-06 09:25:00 | SPY | ETF | 144.95 | 145.01 | 144.95 | 145.01 | 6800.0 |
| 2007-02-06 09:30:00 | SPY | ETF | 144.97 | 144.97 | 144.79 | 144.8 | 860500.0 |
| 2007-02-06 09:35:00 | SPY | ETF | 144.79 | 144.93 | 144.78 | 144.85 | 1037500.0 |
| 2007-02-06 09:40:00 | SPY | ETF | 144.85 | 144.99 | 144.85 | 144.94 | 1024400.0 |
| 2007-02-06 09:45:00 | SPY | ETF | 144.94 | 145.0 | 144.88 | 144.99 | 617900.0 |
| 2007-02-06 09:50:00 | SPY | ETF | 144.99 | 145.02 | 144.95 | 145.0 | 751300.0 |
| 2007-02-06 09:55:00 | SPY | ETF | 145.01 | 145.03 | 144.79 | 144.87 | 1745500.0 |
| 2007-02-06 10:00:00 | SPY | ETF | 144.86 | 144.87 | 144.78 | 144.84 | 857100.0 |
| 2007-02-06 10:05:00 | SPY | ETF | 144.85 | 144.92 | 144.77 | 144.78 | 744700.0 |
| 2007-02-06 10:10:00 | SPY | ETF | 144.7883 | 144.81 | 144.73 | 144.8 | 1168600.0 |
| 2007-02-06 10:15:00 | SPY | ETF | 144.8 | 144.87 | 144.72 | 144.8 | 1521600.0 |
| 2007-02-06 10:20:00 | SPY | ETF | 144.8 | 144.92 | 144.79 | 144.89 | 763600.0 |
| 2007-02-06 10:25:00 | SPY | ETF | 144.89 | 144.91 | 144.82 | 144.87 | 586800.0 |
| 2007-02-06 10:30:00 | SPY | ETF | 144.86 | 144.89 | 144.83 | 144.87 | 399200.0 |
| 2007-02-06 10:35:00 | SPY | ETF | 144.86 | 144.87 | 144.76 | 144.8 | 429000.0 |
| 2007-02-06 10:40:00 | SPY | ETF | 144.79 | 144.84 | 144.71 | 144.71 | 707400.0 |
| 2007-02-06 10:45:00 | SPY | ETF | 144.72 | 144.75 | 144.67 | 144.74 | 834700.0 |
| 2007-02-06 10:50:00 | SPY | ETF | 144.74 | 144.75 | 144.61 | 144.62 | 795500.0 |
| 2007-02-06 10:55:00 | SPY | ETF | 144.62 | 144.65 | 144.54 | 144.56 | 1290500.0 |
| 2007-02-06 11:00:00 | SPY | ETF | 144.56 | 144.64 | 144.51 | 144.61 | 1306800.0 |
| 2007-02-06 11:05:00 | SPY | ETF | 144.61 | 144.66 | 144.57 | 144.62 | 791700.0 |
| 2007-02-06 11:10:00 | SPY | ETF | 144.62 | 144.66 | 144.58 | 144.64 | 518700.0 |
| 2007-02-06 11:15:00 | SPY | ETF | 144.63 | 144.64 | 144.55 | 144.56 | 229800.0 |
| 2007-02-06 11:20:00 | SPY | ETF | 144.55 | 144.61 | 144.54 | 144.59 | 309400.0 |
| 2007-02-06 11:25:00 | SPY | ETF | 144.6 | 144.6 | 144.49 | 144.55 | 846000.0 |
| 2007-02-06 11:30:00 | SPY | ETF | 144.55 | 144.61 | 144.55 | 144.58 | 612400.0 |
| 2007-02-06 11:35:00 | SPY | ETF | 144.59 | 144.59 | 144.53 | 144.56 | 260400.0 |
| 2007-02-06 11:40:00 | SPY | ETF | 144.56 | 144.62 | 144.51 | 144.52 | 520600.0 |
> showing 50 of 13,726 rows — these rows as CSV