PREVIEW / etf_5min / 2007-02-15
file: by_date/etf_5min/2007/2007-02-15.parquet size: 284 KB rows: 13,849
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-15 05:15:00 | SPY | ETF | 145.56 | 145.56 | 145.56 | 145.56 | 100.0 |
| 2007-02-15 07:15:00 | SPY | ETF | 145.68 | 145.68 | 145.68 | 145.68 | 6000.0 |
| 2007-02-15 07:35:00 | SPY | ETF | 145.65 | 145.65 | 145.65 | 145.65 | 100.0 |
| 2007-02-15 07:40:00 | SPY | ETF | 145.65 | 145.65 | 145.65 | 145.65 | 2400.0 |
| 2007-02-15 07:45:00 | SPY | ETF | 145.65 | 145.65 | 145.64 | 145.64 | 20100.0 |
| 2007-02-15 07:50:00 | SPY | ETF | 145.65 | 145.66 | 145.61 | 145.62 | 40100.0 |
| 2007-02-15 07:55:00 | SPY | ETF | 145.62 | 145.62 | 145.62 | 145.62 | 200.0 |
| 2007-02-15 08:00:00 | SPY | ETF | 145.62 | 145.62 | 145.62 | 145.62 | 8000.0 |
| 2007-02-15 08:05:00 | SPY | ETF | 145.61 | 145.61 | 145.56 | 145.59 | 15700.0 |
| 2007-02-15 08:10:00 | SPY | ETF | 145.58 | 145.58 | 145.56 | 145.56 | 3400.0 |
| 2007-02-15 08:15:00 | SPY | ETF | 145.56 | 145.59 | 145.56 | 145.59 | 19100.0 |
| 2007-02-15 08:20:00 | SPY | ETF | 145.59 | 145.59 | 145.58 | 145.58 | 41900.0 |
| 2007-02-15 08:25:00 | SPY | ETF | 145.59 | 145.59 | 145.57 | 145.57 | 112100.0 |
| 2007-02-15 08:30:00 | SPY | ETF | 145.57 | 145.68 | 145.57 | 145.68 | 24500.0 |
| 2007-02-15 08:35:00 | SPY | ETF | 145.7 | 145.7 | 145.68 | 145.68 | 7500.0 |
| 2007-02-15 08:40:00 | SPY | ETF | 145.68 | 145.7 | 145.45 | 145.7 | 21300.0 |
| 2007-02-15 08:45:00 | SPY | ETF | 145.71 | 145.72 | 145.7 | 145.7 | 22500.0 |
| 2007-02-15 08:50:00 | SPY | ETF | 145.71 | 145.72 | 145.7 | 145.71 | 10900.0 |
| 2007-02-15 08:55:00 | SPY | ETF | 145.7 | 145.73 | 145.7 | 145.71 | 101500.0 |
| 2007-02-15 09:00:00 | SPY | ETF | 145.71 | 145.72 | 145.7 | 145.7 | 106200.0 |
| 2007-02-15 09:05:00 | SPY | ETF | 145.72 | 145.72 | 145.66 | 145.66 | 54000.0 |
| 2007-02-15 09:10:00 | SPY | ETF | 145.69 | 145.71 | 145.69 | 145.71 | 56300.0 |
| 2007-02-15 09:15:00 | SPY | ETF | 145.71 | 145.77 | 145.7 | 145.77 | 50200.0 |
| 2007-02-15 09:20:00 | SPY | ETF | 145.77 | 145.79 | 145.71 | 145.71 | 31600.0 |
| 2007-02-15 09:25:00 | SPY | ETF | 145.7 | 145.71 | 145.68 | 145.69 | 96000.0 |
| 2007-02-15 09:30:00 | SPY | ETF | 145.67 | 145.67 | 145.61 | 145.61 | 488000.0 |
| 2007-02-15 09:35:00 | SPY | ETF | 145.62 | 145.68 | 145.49 | 145.52 | 774200.0 |
| 2007-02-15 09:40:00 | SPY | ETF | 145.51 | 145.58 | 145.48 | 145.54 | 869500.0 |
| 2007-02-15 09:45:00 | SPY | ETF | 145.55 | 145.57 | 145.49 | 145.51 | 395000.0 |
| 2007-02-15 09:50:00 | SPY | ETF | 145.51 | 145.55 | 145.49 | 145.54 | 507400.0 |
| 2007-02-15 09:55:00 | SPY | ETF | 145.54 | 145.69 | 145.5 | 145.68 | 607100.0 |
| 2007-02-15 10:00:00 | SPY | ETF | 145.68 | 145.81 | 145.64 | 145.8 | 1160800.0 |
| 2007-02-15 10:05:00 | SPY | ETF | 145.81 | 145.85 | 145.74 | 145.7601 | 960100.0 |
| 2007-02-15 10:10:00 | SPY | ETF | 145.76 | 145.77 | 145.68 | 145.73 | 1083200.0 |
| 2007-02-15 10:15:00 | SPY | ETF | 145.73 | 145.79 | 145.73 | 145.78 | 321000.0 |
| 2007-02-15 10:20:00 | SPY | ETF | 145.78 | 145.79 | 145.65 | 145.66 | 250200.0 |
| 2007-02-15 10:25:00 | SPY | ETF | 145.66 | 145.68 | 145.58 | 145.62 | 362100.0 |
| 2007-02-15 10:30:00 | SPY | ETF | 145.62 | 145.74 | 145.62 | 145.67 | 257200.0 |
| 2007-02-15 10:35:00 | SPY | ETF | 145.68 | 145.7 | 145.64 | 145.64 | 314600.0 |
| 2007-02-15 10:40:00 | SPY | ETF | 145.64 | 145.67 | 145.59 | 145.59 | 392300.0 |
| 2007-02-15 10:45:00 | SPY | ETF | 145.59 | 145.6 | 145.43 | 145.44 | 1045900.0 |
| 2007-02-15 10:50:00 | SPY | ETF | 145.44 | 145.57 | 145.43 | 145.49 | 911500.0 |
| 2007-02-15 10:55:00 | SPY | ETF | 145.48 | 145.66 | 145.44 | 145.48 | 656700.0 |
| 2007-02-15 11:00:00 | SPY | ETF | 145.48 | 145.59 | 145.46 | 145.58 | 597100.0 |
| 2007-02-15 11:05:00 | SPY | ETF | 145.58 | 145.65 | 145.54 | 145.56 | 552300.0 |
| 2007-02-15 11:10:00 | SPY | ETF | 145.57 | 145.7 | 145.55 | 145.64 | 476700.0 |
| 2007-02-15 11:15:00 | SPY | ETF | 145.65 | 145.66 | 145.58 | 145.61 | 531600.0 |
| 2007-02-15 11:20:00 | SPY | ETF | 145.61 | 145.64 | 145.6 | 145.63 | 107500.0 |
| 2007-02-15 11:25:00 | SPY | ETF | 145.63 | 145.73 | 145.62 | 145.72 | 414300.0 |
| 2007-02-15 11:30:00 | SPY | ETF | 145.7275 | 145.75 | 145.68 | 145.69 | 285700.0 |
> showing 50 of 13,849 rows — these rows as CSV