PREVIEW / etf_5min / 2007-04-12
file: by_date/etf_5min/2007/2007-04-12.parquet size: 305 KB rows: 13,907
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-12 05:10:00 | SPY | ETF | 143.68 | 143.68 | 143.68 | 143.68 | 200.0 |
| 2007-04-12 06:15:00 | SPY | ETF | 143.78 | 143.78 | 143.78 | 143.78 | 5000.0 |
| 2007-04-12 06:50:00 | SPY | ETF | 143.75 | 143.75 | 143.74 | 143.74 | 20000.0 |
| 2007-04-12 07:00:00 | SPY | ETF | 143.77 | 143.77 | 143.77 | 143.77 | 5000.0 |
| 2007-04-12 07:15:00 | SPY | ETF | 143.77 | 143.81 | 143.77 | 143.81 | 4000.0 |
| 2007-04-12 07:20:00 | SPY | ETF | 143.81 | 143.83 | 143.79 | 143.79 | 6400.0 |
| 2007-04-12 07:25:00 | SPY | ETF | 143.79 | 143.79 | 143.75 | 143.75 | 3000.0 |
| 2007-04-12 07:30:00 | SPY | ETF | 143.72 | 143.72 | 143.65 | 143.67 | 3600.0 |
| 2007-04-12 07:35:00 | SPY | ETF | 143.65 | 143.68 | 143.64 | 143.64 | 4500.0 |
| 2007-04-12 07:40:00 | SPY | ETF | 143.6 | 143.64 | 143.55 | 143.55 | 49000.0 |
| 2007-04-12 07:45:00 | SPY | ETF | 143.6 | 143.6 | 143.6 | 143.6 | 4200.0 |
| 2007-04-12 07:50:00 | SPY | ETF | 143.6 | 143.64 | 143.6 | 143.63 | 18500.0 |
| 2007-04-12 07:55:00 | SPY | ETF | 143.63 | 143.63 | 143.6 | 143.6 | 134100.0 |
| 2007-04-12 08:00:00 | SPY | ETF | 143.72 | 143.72 | 143.68 | 143.7 | 18900.0 |
| 2007-04-12 08:05:00 | SPY | ETF | 143.72 | 143.72 | 143.7 | 143.7 | 4000.0 |
| 2007-04-12 08:10:00 | SPY | ETF | 143.7 | 143.75 | 143.7 | 143.75 | 40500.0 |
| 2007-04-12 08:15:00 | SPY | ETF | 143.69 | 143.69 | 143.62 | 143.65 | 39100.0 |
| 2007-04-12 08:20:00 | SPY | ETF | 143.62 | 143.68 | 143.62 | 143.68 | 3400.0 |
| 2007-04-12 08:25:00 | SPY | ETF | 143.66 | 143.71 | 143.65 | 143.7 | 50200.0 |
| 2007-04-12 08:30:00 | SPY | ETF | 143.67 | 143.68 | 143.59 | 143.68 | 94500.0 |
| 2007-04-12 08:35:00 | SPY | ETF | 143.66 | 143.76 | 143.66 | 143.71 | 74700.0 |
| 2007-04-12 08:40:00 | SPY | ETF | 143.71 | 143.71 | 143.64 | 143.67 | 344400.0 |
| 2007-04-12 08:45:00 | SPY | ETF | 143.68 | 143.7 | 143.64 | 143.7 | 112700.0 |
| 2007-04-12 08:50:00 | SPY | ETF | 143.7 | 143.72 | 143.67 | 143.69 | 18000.0 |
| 2007-04-12 08:55:00 | SPY | ETF | 143.67 | 143.67 | 143.66 | 143.66 | 4600.0 |
| 2007-04-12 09:00:00 | SPY | ETF | 143.67 | 143.69 | 143.67 | 143.69 | 59100.0 |
| 2007-04-12 09:05:00 | SPY | ETF | 143.68 | 143.69 | 143.66 | 143.69 | 108197.0 |
| 2007-04-12 09:10:00 | SPY | ETF | 143.68 | 143.68 | 143.67 | 143.67 | 9200.0 |
| 2007-04-12 09:15:00 | SPY | ETF | 143.68 | 143.73 | 143.68 | 143.7 | 46500.0 |
| 2007-04-12 09:20:00 | SPY | ETF | 143.7 | 143.72 | 143.7 | 143.71 | 49400.0 |
| 2007-04-12 09:25:00 | SPY | ETF | 143.71 | 143.74 | 143.67 | 143.74 | 46100.0 |
| 2007-04-12 09:30:00 | SPY | ETF | 143.74 | 143.89 | 143.68 | 143.69 | 1839343.0 |
| 2007-04-12 09:35:00 | SPY | ETF | 143.69 | 143.84 | 143.61 | 143.67 | 1906311.0 |
| 2007-04-12 09:40:00 | SPY | ETF | 143.68 | 143.69 | 143.46 | 143.46 | 2852900.0 |
| 2007-04-12 09:45:00 | SPY | ETF | 143.46 | 143.59 | 143.4 | 143.55 | 4755921.0 |
| 2007-04-12 09:50:00 | SPY | ETF | 143.5401 | 143.6 | 143.41 | 143.41 | 2154220.0 |
| 2007-04-12 09:55:00 | SPY | ETF | 143.41 | 143.52 | 143.34 | 143.51 | 4357400.0 |
| 2007-04-12 10:00:00 | SPY | ETF | 143.5 | 143.7 | 143.46 | 143.7 | 1886753.0 |
| 2007-04-12 10:05:00 | SPY | ETF | 143.69 | 143.75 | 143.63 | 143.66 | 2677349.0 |
| 2007-04-12 10:10:00 | SPY | ETF | 143.65 | 143.65 | 143.5 | 143.64 | 1000054.0 |
| 2007-04-12 10:15:00 | SPY | ETF | 143.64 | 143.71 | 143.56 | 143.71 | 813411.0 |
| 2007-04-12 10:20:00 | SPY | ETF | 143.71 | 143.89 | 143.66 | 143.8 | 2008318.0 |
| 2007-04-12 10:25:00 | SPY | ETF | 143.8 | 144.07 | 143.78 | 143.97 | 3012307.0 |
| 2007-04-12 10:30:00 | SPY | ETF | 143.97 | 144.0 | 143.87 | 143.88 | 3213174.0 |
| 2007-04-12 10:35:00 | SPY | ETF | 143.87 | 143.97 | 143.8 | 143.81 | 1618999.0 |
| 2007-04-12 10:40:00 | SPY | ETF | 143.81 | 143.83 | 143.77 | 143.82 | 2996317.0 |
| 2007-04-12 10:45:00 | SPY | ETF | 143.83 | 144.11 | 143.82 | 144.0 | 3670561.0 |
| 2007-04-12 10:50:00 | SPY | ETF | 143.99 | 144.21 | 143.99 | 144.14 | 3087244.0 |
| 2007-04-12 10:55:00 | SPY | ETF | 144.14 | 144.18 | 144.09 | 144.09 | 717022.0 |
| 2007-04-12 11:00:00 | SPY | ETF | 144.1 | 144.18 | 144.04 | 144.15 | 1210300.0 |
> showing 50 of 13,907 rows — these rows as CSV