PREVIEW / etf_5min / 2010-08-06
file: by_date/etf_5min/2010/2010-08-06.parquet size: 795 KB rows: 32,933
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-08-06 04:05:00 | SPY | ETF | 113.0 | 113.0 | 113.0 | 113.0 | 600.0 |
| 2010-08-06 04:15:00 | SPY | ETF | 113.04 | 113.04 | 113.04 | 113.04 | 150.0 |
| 2010-08-06 04:25:00 | SPY | ETF | 113.02 | 113.02 | 113.02 | 113.02 | 228.0 |
| 2010-08-06 04:40:00 | SPY | ETF | 112.94 | 113.02 | 112.94 | 113.02 | 600.0 |
| 2010-08-06 04:50:00 | SPY | ETF | 113.0 | 113.0 | 113.0 | 113.0 | 200.0 |
| 2010-08-06 05:20:00 | SPY | ETF | 112.86 | 112.86 | 112.86 | 112.86 | 500.0 |
| 2010-08-06 05:30:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 1000.0 |
| 2010-08-06 05:40:00 | SPY | ETF | 112.87 | 112.87 | 112.87 | 112.87 | 100.0 |
| 2010-08-06 06:05:00 | SPY | ETF | 112.94 | 112.95 | 112.94 | 112.95 | 6400.0 |
| 2010-08-06 06:10:00 | SPY | ETF | 112.85 | 112.85 | 112.85 | 112.85 | 100.0 |
| 2010-08-06 06:25:00 | SPY | ETF | 112.96 | 113.0 | 112.94 | 113.0 | 1119.0 |
| 2010-08-06 06:30:00 | SPY | ETF | 112.98 | 113.0 | 112.98 | 113.0 | 20000.0 |
| 2010-08-06 06:35:00 | SPY | ETF | 112.97 | 112.97 | 112.97 | 112.97 | 300.0 |
| 2010-08-06 06:40:00 | SPY | ETF | 113.0 | 113.0 | 112.98 | 112.98 | 50000.0 |
| 2010-08-06 07:00:00 | SPY | ETF | 112.96 | 112.97 | 112.91 | 112.95 | 4800.0 |
| 2010-08-06 07:05:00 | SPY | ETF | 112.94 | 112.97 | 112.94 | 112.97 | 32242.0 |
| 2010-08-06 07:10:00 | SPY | ETF | 112.98 | 113.16 | 112.98 | 113.16 | 733450.0 |
| 2010-08-06 07:15:00 | SPY | ETF | 113.16 | 113.17 | 113.12 | 113.16 | 205100.0 |
| 2010-08-06 07:20:00 | SPY | ETF | 113.13 | 113.18 | 113.13 | 113.18 | 133730.0 |
| 2010-08-06 07:25:00 | SPY | ETF | 113.16 | 113.16 | 113.07 | 113.09 | 158840.0 |
| 2010-08-06 07:30:00 | SPY | ETF | 113.08 | 113.15 | 113.05 | 113.12 | 41900.0 |
| 2010-08-06 07:40:00 | SPY | ETF | 113.07 | 113.07 | 113.04 | 113.06 | 6550.0 |
| 2010-08-06 07:45:00 | SPY | ETF | 113.01 | 113.04 | 113.01 | 113.04 | 1570.0 |
| 2010-08-06 07:50:00 | SPY | ETF | 113.04 | 113.06 | 113.01 | 113.01 | 16180.0 |
| 2010-08-06 07:55:00 | SPY | ETF | 113.06 | 113.12 | 113.04 | 113.12 | 117900.0 |
| 2010-08-06 08:00:00 | SPY | ETF | 113.09 | 113.13 | 113.07 | 113.09 | 227446.0 |
| 2010-08-06 08:05:00 | SPY | ETF | 113.08 | 113.11 | 113.06 | 113.07 | 749580.0 |
| 2010-08-06 08:10:00 | SPY | ETF | 113.07 | 113.09 | 113.03 | 113.05 | 130000.0 |
| 2010-08-06 08:15:00 | SPY | ETF | 113.04 | 113.06 | 112.96 | 113.02 | 241540.0 |
| 2010-08-06 08:20:00 | SPY | ETF | 113.02 | 113.11 | 113.02 | 113.08 | 398732.0 |
| 2010-08-06 08:25:00 | SPY | ETF | 113.08 | 113.2 | 112.9 | 113.2 | 481950.0 |
| 2010-08-06 08:30:00 | SPY | ETF | 113.04 | 113.09 | 111.9 | 112.19 | 8172811.0 |
| 2010-08-06 08:35:00 | SPY | ETF | 112.19 | 112.2 | 111.66 | 111.97 | 3297481.0 |
| 2010-08-06 08:40:00 | SPY | ETF | 111.97 | 112.07 | 111.8 | 112.04 | 1481705.0 |
| 2010-08-06 08:45:00 | SPY | ETF | 112.04 | 112.12 | 111.93 | 111.95 | 846524.0 |
| 2010-08-06 08:50:00 | SPY | ETF | 111.96 | 112.42 | 111.67 | 112.05 | 795995.0 |
| 2010-08-06 08:55:00 | SPY | ETF | 112.05 | 112.06 | 111.83 | 111.87 | 432887.0 |
| 2010-08-06 09:00:00 | SPY | ETF | 111.86 | 111.87 | 111.74 | 111.8 | 577316.0 |
| 2010-08-06 09:05:00 | SPY | ETF | 111.8 | 111.87 | 111.75 | 111.84 | 317289.0 |
| 2010-08-06 09:10:00 | SPY | ETF | 111.83 | 111.9 | 111.8 | 111.87 | 308915.0 |
| 2010-08-06 09:15:00 | SPY | ETF | 111.88 | 111.99 | 111.8 | 111.94 | 705660.0 |
| 2010-08-06 09:20:00 | SPY | ETF | 111.94 | 111.95 | 111.76 | 111.79 | 581320.0 |
| 2010-08-06 09:25:00 | SPY | ETF | 111.79 | 111.82 | 111.71 | 111.74 | 446680.0 |
| 2010-08-06 09:30:00 | SPY | ETF | 111.74 | 112.08 | 111.67 | 112.0719 | 7354854.0 |
| 2010-08-06 09:35:00 | SPY | ETF | 112.07 | 112.14 | 111.95 | 112.049 | 4629544.0 |
| 2010-08-06 09:40:00 | SPY | ETF | 112.05 | 112.39 | 112.0 | 112.31 | 6054642.0 |
| 2010-08-06 09:45:00 | SPY | ETF | 112.32 | 112.45 | 112.29 | 112.32 | 3605489.0 |
| 2010-08-06 09:50:00 | SPY | ETF | 112.32 | 112.45 | 112.25 | 112.34 | 3889467.0 |
| 2010-08-06 09:55:00 | SPY | ETF | 112.34 | 112.56 | 112.3 | 112.5 | 3310916.0 |
| 2010-08-06 10:00:00 | SPY | ETF | 112.51 | 112.57 | 112.32 | 112.38 | 3728466.0 |
> showing 50 of 32,933 rows — these rows as CSV