PREVIEW / etf_5min / 2010-11-16
file: by_date/etf_5min/2010/2010-11-16.parquet size: 947 KB rows: 38,526
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-11-16 04:00:00 | SPY | ETF | 119.64 | 119.64 | 119.43 | 119.43 | 1600.0 |
| 2010-11-16 04:10:00 | SPY | ETF | 119.5 | 119.5 | 119.46 | 119.46 | 300.0 |
| 2010-11-16 04:20:00 | SPY | ETF | 119.44 | 119.44 | 119.41 | 119.41 | 2350.0 |
| 2010-11-16 04:40:00 | SPY | ETF | 119.5 | 119.52 | 119.46 | 119.46 | 1700.0 |
| 2010-11-16 05:00:00 | SPY | ETF | 119.49 | 119.49 | 119.49 | 119.49 | 100.0 |
| 2010-11-16 05:35:00 | SPY | ETF | 119.65 | 119.65 | 119.65 | 119.65 | 600.0 |
| 2010-11-16 05:40:00 | SPY | ETF | 119.38 | 119.38 | 119.35 | 119.35 | 1600.0 |
| 2010-11-16 05:45:00 | SPY | ETF | 119.35 | 119.35 | 119.35 | 119.35 | 5000.0 |
| 2010-11-16 05:50:00 | SPY | ETF | 119.38 | 119.43 | 119.38 | 119.43 | 300.0 |
| 2010-11-16 05:55:00 | SPY | ETF | 119.45 | 119.45 | 119.41 | 119.41 | 2600.0 |
| 2010-11-16 06:00:00 | SPY | ETF | 119.39 | 119.4 | 119.39 | 119.4 | 600.0 |
| 2010-11-16 06:05:00 | SPY | ETF | 119.4 | 119.4 | 119.4 | 119.4 | 100.0 |
| 2010-11-16 06:10:00 | SPY | ETF | 119.4 | 119.4 | 119.24 | 119.29 | 21050.0 |
| 2010-11-16 06:15:00 | SPY | ETF | 119.28 | 119.28 | 119.19 | 119.19 | 1850.0 |
| 2010-11-16 06:20:00 | SPY | ETF | 119.21 | 119.21 | 119.2 | 119.21 | 16000.0 |
| 2010-11-16 06:25:00 | SPY | ETF | 119.23 | 119.23 | 119.2 | 119.2 | 31650.0 |
| 2010-11-16 06:30:00 | SPY | ETF | 119.23 | 119.25 | 119.2 | 119.25 | 300.0 |
| 2010-11-16 06:35:00 | SPY | ETF | 119.28 | 119.3 | 119.28 | 119.3 | 18575.0 |
| 2010-11-16 06:40:00 | SPY | ETF | 119.29 | 119.33 | 119.28 | 119.33 | 1100.0 |
| 2010-11-16 06:45:00 | SPY | ETF | 119.31 | 119.31 | 119.31 | 119.31 | 10000.0 |
| 2010-11-16 06:50:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 200.0 |
| 2010-11-16 06:55:00 | SPY | ETF | 119.21 | 119.27 | 119.16 | 119.18 | 80125.0 |
| 2010-11-16 07:00:00 | SPY | ETF | 119.18 | 119.24 | 119.18 | 119.24 | 92000.0 |
| 2010-11-16 07:05:00 | SPY | ETF | 119.24 | 119.28 | 119.24 | 119.28 | 115850.0 |
| 2010-11-16 07:10:00 | SPY | ETF | 119.3 | 119.43 | 119.29 | 119.43 | 129060.0 |
| 2010-11-16 07:15:00 | SPY | ETF | 119.42 | 119.45 | 119.41 | 119.43 | 140600.0 |
| 2010-11-16 07:20:00 | SPY | ETF | 119.41 | 119.43 | 119.37 | 119.37 | 64525.0 |
| 2010-11-16 07:25:00 | SPY | ETF | 119.39 | 119.43 | 119.37 | 119.38 | 43100.0 |
| 2010-11-16 07:30:00 | SPY | ETF | 119.38 | 119.38 | 119.34 | 119.34 | 11377.0 |
| 2010-11-16 07:35:00 | SPY | ETF | 119.38 | 119.46 | 119.35 | 119.46 | 121350.0 |
| 2010-11-16 07:40:00 | SPY | ETF | 119.46 | 119.56 | 119.46 | 119.52 | 112930.0 |
| 2010-11-16 07:45:00 | SPY | ETF | 119.52 | 119.55 | 119.5 | 119.53 | 17650.0 |
| 2010-11-16 07:50:00 | SPY | ETF | 119.5 | 119.52 | 119.48 | 119.48 | 134420.0 |
| 2010-11-16 07:55:00 | SPY | ETF | 119.48 | 119.48 | 119.38 | 119.4 | 46800.0 |
| 2010-11-16 08:00:00 | SPY | ETF | 119.4 | 119.55 | 119.21 | 119.52 | 866034.0 |
| 2010-11-16 08:05:00 | SPY | ETF | 119.53 | 119.53 | 119.48 | 119.5 | 83071.0 |
| 2010-11-16 08:10:00 | SPY | ETF | 119.49 | 119.49 | 119.44 | 119.46 | 45025.0 |
| 2010-11-16 08:15:00 | SPY | ETF | 119.46 | 119.64 | 119.42 | 119.59 | 412239.0 |
| 2010-11-16 08:20:00 | SPY | ETF | 119.56 | 119.56 | 119.4 | 119.4 | 237274.0 |
| 2010-11-16 08:25:00 | SPY | ETF | 119.41 | 119.48 | 119.39 | 119.44 | 300419.0 |
| 2010-11-16 08:30:00 | SPY | ETF | 119.44 | 119.68 | 119.41 | 119.52 | 441457.0 |
| 2010-11-16 08:35:00 | SPY | ETF | 119.51 | 119.68 | 119.51 | 119.65 | 155468.0 |
| 2010-11-16 08:40:00 | SPY | ETF | 119.65 | 119.69 | 119.54 | 119.54 | 373896.0 |
| 2010-11-16 08:45:00 | SPY | ETF | 119.54 | 119.54 | 119.43 | 119.51 | 356980.0 |
| 2010-11-16 08:50:00 | SPY | ETF | 119.49 | 119.59 | 119.42 | 119.43 | 635831.0 |
| 2010-11-16 08:55:00 | SPY | ETF | 119.43 | 119.44 | 119.4 | 119.41 | 325593.0 |
| 2010-11-16 09:00:00 | SPY | ETF | 119.41 | 119.55 | 119.38 | 119.49 | 825163.0 |
| 2010-11-16 09:05:00 | SPY | ETF | 119.5 | 119.53 | 119.39 | 119.39 | 131972.0 |
| 2010-11-16 09:10:00 | SPY | ETF | 119.39 | 119.46 | 119.37 | 119.39 | 508850.0 |
| 2010-11-16 09:15:00 | SPY | ETF | 119.39 | 119.46 | 119.19 | 119.21 | 800515.0 |
> showing 50 of 38,526 rows — these rows as CSV