PREVIEW / etf_5min / 2007-10-26
file: by_date/etf_5min/2007/2007-10-26.parquet size: 390 KB rows: 19,319
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-10-26 04:55:00 | SPY | ETF | 151.63 | 151.63 | 151.63 | 151.63 | 400.0 |
| 2007-10-26 05:00:00 | SPY | ETF | 151.6 | 151.6 | 151.6 | 151.6 | 100.0 |
| 2007-10-26 05:25:00 | SPY | ETF | 151.68 | 151.68 | 151.68 | 151.68 | 100.0 |
| 2007-10-26 06:10:00 | SPY | ETF | 151.7 | 151.7 | 151.65 | 151.65 | 3300.0 |
| 2007-10-26 06:15:00 | SPY | ETF | 151.7 | 151.7 | 151.7 | 151.7 | 3000.0 |
| 2007-10-26 06:20:00 | SPY | ETF | 151.9 | 151.9 | 151.9 | 151.9 | 3000.0 |
| 2007-10-26 06:50:00 | SPY | ETF | 152.13 | 152.13 | 152.08 | 152.08 | 33200.0 |
| 2007-10-26 07:00:00 | SPY | ETF | 152.0 | 152.0 | 151.97 | 151.97 | 800.0 |
| 2007-10-26 07:05:00 | SPY | ETF | 151.94 | 151.95 | 151.93 | 151.95 | 600.0 |
| 2007-10-26 07:10:00 | SPY | ETF | 151.95 | 151.97 | 151.94 | 151.97 | 7300.0 |
| 2007-10-26 07:15:00 | SPY | ETF | 152.0 | 152.0 | 151.86 | 151.88 | 17000.0 |
| 2007-10-26 07:20:00 | SPY | ETF | 151.85 | 151.86 | 151.81 | 151.83 | 13200.0 |
| 2007-10-26 07:25:00 | SPY | ETF | 151.9 | 151.9 | 151.85 | 151.85 | 72000.0 |
| 2007-10-26 07:30:00 | SPY | ETF | 151.9 | 151.91 | 151.88 | 151.88 | 31300.0 |
| 2007-10-26 07:35:00 | SPY | ETF | 151.93 | 151.93 | 151.68 | 151.68 | 39800.0 |
| 2007-10-26 07:40:00 | SPY | ETF | 151.66 | 151.75 | 151.65 | 151.75 | 75800.0 |
| 2007-10-26 07:45:00 | SPY | ETF | 151.72 | 151.72 | 151.54 | 151.6 | 302200.0 |
| 2007-10-26 07:50:00 | SPY | ETF | 151.64 | 151.67 | 151.64 | 151.66 | 8900.0 |
| 2007-10-26 07:55:00 | SPY | ETF | 151.67 | 151.67 | 151.6 | 151.63 | 30200.0 |
| 2007-10-26 08:00:00 | SPY | ETF | 151.64 | 152.04 | 151.53 | 152.04 | 491500.0 |
| 2007-10-26 08:05:00 | SPY | ETF | 152.05 | 152.19 | 152.0 | 152.19 | 1770800.0 |
| 2007-10-26 08:10:00 | SPY | ETF | 152.19 | 152.52 | 151.67 | 152.43 | 1884000.0 |
| 2007-10-26 08:15:00 | SPY | ETF | 152.43 | 152.55 | 152.4 | 152.55 | 1385200.0 |
| 2007-10-26 08:20:00 | SPY | ETF | 152.55 | 152.62 | 152.53 | 152.6 | 599400.0 |
| 2007-10-26 08:25:00 | SPY | ETF | 152.6 | 152.63 | 152.48 | 152.54 | 912900.0 |
| 2007-10-26 08:30:00 | SPY | ETF | 152.54 | 152.57 | 152.5 | 152.56 | 183800.0 |
| 2007-10-26 08:35:00 | SPY | ETF | 152.56 | 152.8 | 152.55 | 152.76 | 1241200.0 |
| 2007-10-26 08:40:00 | SPY | ETF | 152.78 | 152.82 | 152.73 | 152.75 | 127900.0 |
| 2007-10-26 08:45:00 | SPY | ETF | 152.72 | 152.73 | 152.64 | 152.66 | 165100.0 |
| 2007-10-26 08:50:00 | SPY | ETF | 152.7 | 152.8 | 152.69 | 152.79 | 409900.0 |
| 2007-10-26 08:55:00 | SPY | ETF | 152.79 | 152.82 | 152.75 | 152.79 | 857700.0 |
| 2007-10-26 09:00:00 | SPY | ETF | 152.79 | 152.8 | 152.7 | 152.7 | 413500.0 |
| 2007-10-26 09:05:00 | SPY | ETF | 152.7 | 152.77 | 152.7 | 152.76 | 150200.0 |
| 2007-10-26 09:10:00 | SPY | ETF | 152.76 | 153.02 | 152.76 | 153.01 | 1356500.0 |
| 2007-10-26 09:15:00 | SPY | ETF | 153.0 | 153.05 | 152.92 | 153.03 | 1359788.0 |
| 2007-10-26 09:20:00 | SPY | ETF | 153.03 | 153.1 | 153.01 | 153.07 | 659500.0 |
| 2007-10-26 09:25:00 | SPY | ETF | 153.05 | 153.09 | 152.99 | 153.06 | 454590.0 |
| 2007-10-26 09:30:00 | SPY | ETF | 153.06 | 153.23 | 153.06 | 153.07 | 2692711.0 |
| 2007-10-26 09:35:00 | SPY | ETF | 153.07 | 153.16 | 152.92 | 152.92 | 2713702.0 |
| 2007-10-26 09:40:00 | SPY | ETF | 152.92 | 153.0 | 152.67 | 152.71 | 6013200.0 |
| 2007-10-26 09:45:00 | SPY | ETF | 152.72 | 153.0 | 152.6 | 152.64 | 5869000.0 |
| 2007-10-26 09:50:00 | SPY | ETF | 152.64 | 152.82 | 152.62 | 152.66 | 2596900.0 |
| 2007-10-26 09:55:00 | SPY | ETF | 152.67 | 153.0 | 152.5 | 152.63 | 4800700.0 |
| 2007-10-26 10:00:00 | SPY | ETF | 152.63 | 152.86 | 152.35 | 152.59 | 6640400.0 |
| 2007-10-26 10:05:00 | SPY | ETF | 152.6 | 153.25 | 152.54 | 152.68 | 2800900.0 |
| 2007-10-26 10:10:00 | SPY | ETF | 152.68 | 152.91 | 152.62 | 152.88 | 3087700.0 |
| 2007-10-26 10:15:00 | SPY | ETF | 152.82 | 152.9 | 152.69 | 152.73 | 1350400.0 |
| 2007-10-26 10:20:00 | SPY | ETF | 152.74 | 152.87 | 152.61 | 152.82 | 1850000.0 |
| 2007-10-26 10:25:00 | SPY | ETF | 152.81 | 152.91 | 152.68 | 152.79 | 1182300.0 |
| 2007-10-26 10:30:00 | SPY | ETF | 152.78 | 152.78 | 152.62 | 152.65 | 769600.0 |
> showing 50 of 19,319 rows — these rows as CSV