PREVIEW / etf_5min / 2010-07-01
file: by_date/etf_5min/2010/2010-07-01.parquet size: 904 KB rows: 37,078
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-01 04:15:00 | SPY | ETF | 102.91 | 102.91 | 102.91 | 102.91 | 600.0 |
| 2010-07-01 04:20:00 | SPY | ETF | 102.91 | 102.98 | 102.89 | 102.98 | 1100.0 |
| 2010-07-01 04:25:00 | SPY | ETF | 102.92 | 102.92 | 102.92 | 102.92 | 100.0 |
| 2010-07-01 04:30:00 | SPY | ETF | 102.85 | 102.87 | 102.85 | 102.87 | 1300.0 |
| 2010-07-01 04:35:00 | SPY | ETF | 102.99 | 103.0 | 102.99 | 103.0 | 200.0 |
| 2010-07-01 04:45:00 | SPY | ETF | 102.88 | 102.88 | 102.87 | 102.87 | 1100.0 |
| 2010-07-01 04:55:00 | SPY | ETF | 102.95 | 102.95 | 102.93 | 102.95 | 500.0 |
| 2010-07-01 05:00:00 | SPY | ETF | 102.95 | 102.95 | 102.89 | 102.9 | 500.0 |
| 2010-07-01 05:20:00 | SPY | ETF | 102.85 | 102.85 | 102.85 | 102.85 | 100.0 |
| 2010-07-01 05:25:00 | SPY | ETF | 102.85 | 102.85 | 102.73 | 102.73 | 4200.0 |
| 2010-07-01 05:30:00 | SPY | ETF | 102.75 | 102.76 | 102.75 | 102.75 | 3400.0 |
| 2010-07-01 06:00:00 | SPY | ETF | 102.8 | 102.8 | 102.8 | 102.8 | 100.0 |
| 2010-07-01 06:10:00 | SPY | ETF | 102.94 | 102.94 | 102.94 | 102.94 | 300.0 |
| 2010-07-01 06:15:00 | SPY | ETF | 103.03 | 103.05 | 103.03 | 103.05 | 900.0 |
| 2010-07-01 06:20:00 | SPY | ETF | 103.07 | 103.1 | 103.05 | 103.1 | 17000.0 |
| 2010-07-01 06:25:00 | SPY | ETF | 103.09 | 103.1 | 103.08 | 103.1 | 55000.0 |
| 2010-07-01 06:30:00 | SPY | ETF | 103.05 | 103.09 | 103.05 | 103.09 | 14000.0 |
| 2010-07-01 06:35:00 | SPY | ETF | 103.05 | 103.05 | 103.05 | 103.05 | 300.0 |
| 2010-07-01 06:40:00 | SPY | ETF | 103.08 | 103.1 | 103.06 | 103.1 | 10800.0 |
| 2010-07-01 06:45:00 | SPY | ETF | 103.08 | 103.12 | 103.06 | 103.11 | 53900.0 |
| 2010-07-01 06:50:00 | SPY | ETF | 103.13 | 103.13 | 103.11 | 103.11 | 300.0 |
| 2010-07-01 06:55:00 | SPY | ETF | 103.15 | 103.26 | 103.15 | 103.25 | 54600.0 |
| 2010-07-01 07:00:00 | SPY | ETF | 103.26 | 103.26 | 103.11 | 103.11 | 17900.0 |
| 2010-07-01 07:05:00 | SPY | ETF | 103.12 | 103.12 | 103.06 | 103.09 | 7000.0 |
| 2010-07-01 07:10:00 | SPY | ETF | 103.06 | 103.09 | 103.0 | 103.0 | 78240.0 |
| 2010-07-01 07:15:00 | SPY | ETF | 103.01 | 103.16 | 103.01 | 103.08 | 48910.0 |
| 2010-07-01 07:20:00 | SPY | ETF | 103.09 | 103.15 | 103.09 | 103.09 | 321954.0 |
| 2010-07-01 07:25:00 | SPY | ETF | 103.08 | 103.09 | 103.05 | 103.06 | 18400.0 |
| 2010-07-01 07:30:00 | SPY | ETF | 103.05 | 103.05 | 102.91 | 102.91 | 374411.0 |
| 2010-07-01 07:35:00 | SPY | ETF | 102.91 | 102.97 | 102.86 | 102.95 | 106500.0 |
| 2010-07-01 07:40:00 | SPY | ETF | 102.94 | 103.04 | 102.91 | 102.93 | 516088.0 |
| 2010-07-01 07:45:00 | SPY | ETF | 102.97 | 103.03 | 102.95 | 102.99 | 89438.0 |
| 2010-07-01 07:50:00 | SPY | ETF | 102.99 | 103.02 | 102.88 | 102.88 | 86800.0 |
| 2010-07-01 07:55:00 | SPY | ETF | 102.89 | 102.89 | 102.82 | 102.86 | 146845.0 |
| 2010-07-01 08:00:00 | SPY | ETF | 102.86 | 103.0 | 102.83 | 103.0 | 1459605.0 |
| 2010-07-01 08:05:00 | SPY | ETF | 102.91 | 103.22 | 102.9 | 102.97 | 153238.0 |
| 2010-07-01 08:10:00 | SPY | ETF | 102.97 | 102.97 | 102.76 | 102.78 | 202750.0 |
| 2010-07-01 08:15:00 | SPY | ETF | 102.78 | 102.83 | 102.75 | 102.83 | 185098.0 |
| 2010-07-01 08:20:00 | SPY | ETF | 102.83 | 102.92 | 102.82 | 102.91 | 176899.0 |
| 2010-07-01 08:25:00 | SPY | ETF | 102.91 | 103.1 | 102.87 | 102.92 | 735387.0 |
| 2010-07-01 08:30:00 | SPY | ETF | 102.93 | 102.93 | 102.42 | 102.56 | 2546370.0 |
| 2010-07-01 08:35:00 | SPY | ETF | 102.56 | 103.1432 | 102.56 | 102.71 | 1188659.0 |
| 2010-07-01 08:40:00 | SPY | ETF | 102.73 | 102.8 | 102.69 | 102.75 | 450522.0 |
| 2010-07-01 08:45:00 | SPY | ETF | 102.76 | 102.97 | 102.76 | 102.97 | 762140.0 |
| 2010-07-01 08:50:00 | SPY | ETF | 102.95 | 102.98 | 102.89 | 102.95 | 277597.0 |
| 2010-07-01 08:55:00 | SPY | ETF | 102.95 | 103.14 | 102.94 | 103.12 | 936590.0 |
| 2010-07-01 09:00:00 | SPY | ETF | 103.11 | 103.22 | 103.09 | 103.16 | 858047.0 |
| 2010-07-01 09:05:00 | SPY | ETF | 103.15 | 103.27 | 102.48 | 103.14 | 735809.0 |
| 2010-07-01 09:10:00 | SPY | ETF | 103.14 | 103.23 | 103.1 | 103.12 | 445421.0 |
| 2010-07-01 09:15:00 | SPY | ETF | 103.12 | 103.22 | 103.07 | 103.14 | 217286.0 |
> showing 50 of 37,078 rows — these rows as CSV