PREVIEW / etf_5min / 2007-12-28
file: by_date/etf_5min/2007/2007-12-28.parquet size: 382 KB rows: 19,521
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-12-28 06:30:00 | SPY | ETF | 148.18 | 148.21 | 148.18 | 148.21 | 30000.0 |
| 2007-12-28 07:00:00 | SPY | ETF | 148.55 | 148.61 | 148.52 | 148.55 | 31400.0 |
| 2007-12-28 07:05:00 | SPY | ETF | 148.55 | 148.55 | 148.51 | 148.54 | 2400.0 |
| 2007-12-28 07:10:00 | SPY | ETF | 148.5 | 148.52 | 148.5 | 148.52 | 5000.0 |
| 2007-12-28 07:15:00 | SPY | ETF | 148.55 | 148.56 | 148.55 | 148.56 | 2000.0 |
| 2007-12-28 07:20:00 | SPY | ETF | 148.53 | 148.58 | 148.52 | 148.55 | 87000.0 |
| 2007-12-28 07:25:00 | SPY | ETF | 148.56 | 148.6 | 148.52 | 148.6 | 38900.0 |
| 2007-12-28 07:30:00 | SPY | ETF | 148.53 | 148.53 | 148.53 | 148.53 | 1200.0 |
| 2007-12-28 07:35:00 | SPY | ETF | 148.54 | 148.56 | 148.53 | 148.54 | 3500.0 |
| 2007-12-28 07:40:00 | SPY | ETF | 148.5 | 148.67 | 148.5 | 148.62 | 40600.0 |
| 2007-12-28 07:45:00 | SPY | ETF | 148.65 | 148.98 | 148.64 | 148.95 | 52500.0 |
| 2007-12-28 07:50:00 | SPY | ETF | 148.91 | 148.94 | 148.86 | 148.89 | 47500.0 |
| 2007-12-28 07:55:00 | SPY | ETF | 148.89 | 148.9 | 148.83 | 148.85 | 89300.0 |
| 2007-12-28 08:00:00 | SPY | ETF | 148.83 | 148.9 | 148.78 | 148.9 | 3176000.0 |
| 2007-12-28 08:05:00 | SPY | ETF | 148.89 | 148.9 | 148.83 | 148.83 | 130400.0 |
| 2007-12-28 08:10:00 | SPY | ETF | 148.85 | 148.86 | 148.74 | 148.79 | 129300.0 |
| 2007-12-28 08:15:00 | SPY | ETF | 148.79 | 148.81 | 147.76 | 148.73 | 240800.0 |
| 2007-12-28 08:20:00 | SPY | ETF | 148.74 | 148.76 | 148.71 | 148.76 | 90100.0 |
| 2007-12-28 08:25:00 | SPY | ETF | 148.76 | 148.83 | 148.76 | 148.78 | 46000.0 |
| 2007-12-28 08:30:00 | SPY | ETF | 148.78 | 148.78 | 148.71 | 148.75 | 66500.0 |
| 2007-12-28 08:35:00 | SPY | ETF | 148.74 | 148.74 | 148.71 | 148.73 | 42900.0 |
| 2007-12-28 08:40:00 | SPY | ETF | 148.74 | 148.75 | 148.65 | 148.67 | 94400.0 |
| 2007-12-28 08:45:00 | SPY | ETF | 148.67 | 148.68 | 148.64 | 148.65 | 42600.0 |
| 2007-12-28 08:50:00 | SPY | ETF | 148.65 | 148.65 | 148.59 | 148.61 | 91100.0 |
| 2007-12-28 08:55:00 | SPY | ETF | 148.61 | 148.62 | 148.57 | 148.58 | 23300.0 |
| 2007-12-28 09:00:00 | SPY | ETF | 148.59 | 148.61 | 148.48 | 148.48 | 395690.0 |
| 2007-12-28 09:05:00 | SPY | ETF | 148.49 | 148.52 | 148.48 | 148.52 | 57229.0 |
| 2007-12-28 09:10:00 | SPY | ETF | 148.53 | 148.6 | 148.53 | 148.58 | 68000.0 |
| 2007-12-28 09:15:00 | SPY | ETF | 148.58 | 148.58 | 148.5 | 148.51 | 20287.0 |
| 2007-12-28 09:20:00 | SPY | ETF | 148.51 | 148.53 | 148.49 | 148.51 | 64600.0 |
| 2007-12-28 09:25:00 | SPY | ETF | 148.52 | 148.61 | 148.51 | 148.56 | 126393.0 |
| 2007-12-28 09:30:00 | SPY | ETF | 148.54 | 148.61 | 148.43 | 148.43 | 2673612.0 |
| 2007-12-28 09:35:00 | SPY | ETF | 148.43 | 148.5326 | 148.3 | 148.41 | 3467017.0 |
| 2007-12-28 09:40:00 | SPY | ETF | 148.41 | 148.54 | 148.31 | 148.42 | 2212515.0 |
| 2007-12-28 09:45:00 | SPY | ETF | 148.42 | 148.58 | 148.37 | 148.48 | 2323328.0 |
| 2007-12-28 09:50:00 | SPY | ETF | 148.47 | 148.52 | 148.39 | 148.41 | 1254790.0 |
| 2007-12-28 09:55:00 | SPY | ETF | 148.4 | 148.45 | 148.26 | 148.36 | 1619607.0 |
| 2007-12-28 10:00:00 | SPY | ETF | 148.35 | 148.35 | 147.64 | 147.69 | 4932342.0 |
| 2007-12-28 10:05:00 | SPY | ETF | 147.69 | 147.84 | 147.47 | 147.64 | 5063860.0 |
| 2007-12-28 10:10:00 | SPY | ETF | 147.63 | 147.84 | 147.63 | 147.82 | 1680885.0 |
| 2007-12-28 10:15:00 | SPY | ETF | 147.82 | 147.89 | 147.66 | 147.88 | 1708427.0 |
| 2007-12-28 10:20:00 | SPY | ETF | 147.89 | 147.94 | 147.78 | 147.82 | 963349.0 |
| 2007-12-28 10:25:00 | SPY | ETF | 147.82 | 147.94 | 147.81 | 147.89 | 1165992.0 |
| 2007-12-28 10:30:00 | SPY | ETF | 147.88 | 147.94 | 147.79 | 147.8 | 1163207.0 |
| 2007-12-28 10:35:00 | SPY | ETF | 147.8 | 147.83 | 147.74 | 147.81 | 941607.0 |
| 2007-12-28 10:40:00 | SPY | ETF | 147.81 | 147.9 | 147.79 | 147.82 | 412490.0 |
| 2007-12-28 10:45:00 | SPY | ETF | 147.8 | 147.89 | 147.76 | 147.86 | 643377.0 |
| 2007-12-28 10:50:00 | SPY | ETF | 147.87 | 147.87 | 147.76 | 147.81 | 666129.0 |
| 2007-12-28 10:55:00 | SPY | ETF | 147.81 | 147.81 | 147.63 | 147.66 | 679158.0 |
| 2007-12-28 11:00:00 | SPY | ETF | 147.66 | 147.79 | 147.6 | 147.6 | 667229.0 |
> showing 50 of 19,521 rows — these rows as CSV