PREVIEW / etf_5min / 2007-09-28
file: by_date/etf_5min/2007/2007-09-28.parquet size: 337 KB rows: 17,961
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-09-28 07:00:00 | SPY | ETF | 152.59 | 152.67 | 152.59 | 152.67 | 900.0 |
| 2007-09-28 07:05:00 | SPY | ETF | 152.65 | 152.69 | 152.65 | 152.69 | 15000.0 |
| 2007-09-28 07:10:00 | SPY | ETF | 152.69 | 152.69 | 152.66 | 152.66 | 25000.0 |
| 2007-09-28 07:15:00 | SPY | ETF | 152.72 | 152.72 | 152.72 | 152.72 | 7000.0 |
| 2007-09-28 07:20:00 | SPY | ETF | 152.69 | 152.79 | 152.69 | 152.79 | 5200.0 |
| 2007-09-28 07:25:00 | SPY | ETF | 152.77 | 152.77 | 152.72 | 152.72 | 8800.0 |
| 2007-09-28 07:30:00 | SPY | ETF | 152.7 | 152.7 | 152.63 | 152.63 | 40200.0 |
| 2007-09-28 07:35:00 | SPY | ETF | 152.64 | 152.72 | 152.64 | 152.65 | 55500.0 |
| 2007-09-28 07:40:00 | SPY | ETF | 152.69 | 152.69 | 152.59 | 152.59 | 21700.0 |
| 2007-09-28 07:45:00 | SPY | ETF | 152.64 | 152.64 | 152.64 | 152.64 | 4000.0 |
| 2007-09-28 07:50:00 | SPY | ETF | 152.69 | 152.72 | 152.68 | 152.68 | 53500.0 |
| 2007-09-28 07:55:00 | SPY | ETF | 152.68 | 152.72 | 152.68 | 152.69 | 9200.0 |
| 2007-09-28 08:00:00 | SPY | ETF | 152.67 | 152.7 | 152.67 | 152.69 | 37400.0 |
| 2007-09-28 08:05:00 | SPY | ETF | 152.7 | 152.75 | 152.7 | 152.73 | 31100.0 |
| 2007-09-28 08:10:00 | SPY | ETF | 152.73 | 152.76 | 152.64 | 152.64 | 134900.0 |
| 2007-09-28 08:15:00 | SPY | ETF | 152.67 | 152.76 | 152.67 | 152.74 | 119200.0 |
| 2007-09-28 08:20:00 | SPY | ETF | 152.77 | 152.79 | 152.6 | 152.61 | 453200.0 |
| 2007-09-28 08:25:00 | SPY | ETF | 152.61 | 152.63 | 152.53 | 152.62 | 656900.0 |
| 2007-09-28 08:30:00 | SPY | ETF | 152.62 | 152.78 | 152.61 | 152.76 | 626600.0 |
| 2007-09-28 08:35:00 | SPY | ETF | 152.77 | 152.86 | 152.77 | 152.82 | 111500.0 |
| 2007-09-28 08:40:00 | SPY | ETF | 152.84 | 152.84 | 152.8 | 152.83 | 70100.0 |
| 2007-09-28 08:45:00 | SPY | ETF | 152.81 | 152.89 | 152.8 | 152.88 | 92200.0 |
| 2007-09-28 08:50:00 | SPY | ETF | 152.88 | 152.89 | 152.78 | 152.78 | 282200.0 |
| 2007-09-28 08:55:00 | SPY | ETF | 152.79 | 152.81 | 152.74 | 152.78 | 53500.0 |
| 2007-09-28 09:00:00 | SPY | ETF | 152.74 | 152.79 | 152.73 | 152.76 | 61800.0 |
| 2007-09-28 09:05:00 | SPY | ETF | 152.75 | 152.82 | 152.75 | 152.8 | 42500.0 |
| 2007-09-28 09:10:00 | SPY | ETF | 152.62 | 152.83 | 152.62 | 152.81 | 89200.0 |
| 2007-09-28 09:15:00 | SPY | ETF | 152.82 | 152.86 | 152.81 | 152.84 | 31500.0 |
| 2007-09-28 09:20:00 | SPY | ETF | 152.86 | 152.86 | 152.83 | 152.83 | 43900.0 |
| 2007-09-28 09:25:00 | SPY | ETF | 152.83 | 152.88 | 152.8 | 152.86 | 312100.0 |
| 2007-09-28 09:30:00 | SPY | ETF | 152.85 | 152.97 | 152.79 | 152.83 | 2063887.0 |
| 2007-09-28 09:35:00 | SPY | ETF | 152.83 | 152.98 | 152.8 | 152.89 | 1778298.0 |
| 2007-09-28 09:40:00 | SPY | ETF | 152.89 | 153.05 | 152.86 | 153.05 | 1303000.0 |
| 2007-09-28 09:45:00 | SPY | ETF | 153.05 | 153.15 | 152.97 | 153.01 | 3145000.0 |
| 2007-09-28 09:50:00 | SPY | ETF | 153.01 | 153.04 | 152.9 | 153.04 | 1603400.0 |
| 2007-09-28 09:55:00 | SPY | ETF | 153.04 | 153.08 | 152.96 | 152.99 | 1398200.0 |
| 2007-09-28 10:00:00 | SPY | ETF | 152.99 | 153.19 | 152.95 | 152.96 | 2002500.0 |
| 2007-09-28 10:05:00 | SPY | ETF | 152.95 | 153.0 | 152.83 | 152.84 | 2477500.0 |
| 2007-09-28 10:10:00 | SPY | ETF | 152.85 | 152.94 | 152.82 | 152.84 | 1751000.0 |
| 2007-09-28 10:15:00 | SPY | ETF | 152.84 | 152.86 | 152.67 | 152.701 | 4342000.0 |
| 2007-09-28 10:20:00 | SPY | ETF | 152.71 | 152.79 | 152.66 | 152.7 | 1625800.0 |
| 2007-09-28 10:25:00 | SPY | ETF | 152.7 | 152.72 | 152.52 | 152.52 | 2342500.0 |
| 2007-09-28 10:30:00 | SPY | ETF | 152.52 | 152.53 | 152.25 | 152.35 | 3285900.0 |
| 2007-09-28 10:35:00 | SPY | ETF | 152.36 | 152.45 | 152.3 | 152.36 | 2793400.0 |
| 2007-09-28 10:40:00 | SPY | ETF | 152.36 | 152.44 | 152.31 | 152.4 | 1604100.0 |
| 2007-09-28 10:45:00 | SPY | ETF | 152.41 | 152.44 | 152.22 | 152.32 | 6283000.0 |
| 2007-09-28 10:50:00 | SPY | ETF | 152.32 | 152.49 | 152.3 | 152.49 | 1424700.0 |
| 2007-09-28 10:55:00 | SPY | ETF | 152.4875 | 152.57 | 152.47 | 152.52 | 1692100.0 |
| 2007-09-28 11:00:00 | SPY | ETF | 152.52 | 152.58 | 152.47 | 152.47 | 996600.0 |
| 2007-09-28 11:05:00 | SPY | ETF | 152.47 | 152.55 | 152.4595 | 152.46 | 1386100.0 |
> showing 50 of 17,961 rows — these rows as CSV