PREVIEW / etf_5min / 2008-10-07
file: by_date/etf_5min/2008/2008-10-07.parquet size: 590 KB rows: 27,462
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-07 04:15:00 | SPY | ETF | 105.07 | 105.07 | 105.07 | 105.07 | 200.0 |
| 2008-10-07 05:20:00 | SPY | ETF | 104.86 | 104.88 | 104.86 | 104.88 | 5000.0 |
| 2008-10-07 05:35:00 | SPY | ETF | 104.88 | 104.88 | 104.84 | 104.84 | 5300.0 |
| 2008-10-07 05:40:00 | SPY | ETF | 104.8 | 104.8 | 104.77 | 104.77 | 1300.0 |
| 2008-10-07 05:45:00 | SPY | ETF | 104.8 | 104.92 | 104.8 | 104.92 | 500.0 |
| 2008-10-07 05:50:00 | SPY | ETF | 104.76 | 104.76 | 104.75 | 104.75 | 2000.0 |
| 2008-10-07 06:00:00 | SPY | ETF | 105.07 | 105.07 | 105.07 | 105.07 | 300.0 |
| 2008-10-07 06:05:00 | SPY | ETF | 105.21 | 105.3 | 105.14 | 105.2 | 19000.0 |
| 2008-10-07 06:10:00 | SPY | ETF | 105.29 | 105.6 | 105.29 | 105.54 | 34100.0 |
| 2008-10-07 06:15:00 | SPY | ETF | 105.65 | 105.9 | 105.53 | 105.79 | 6300.0 |
| 2008-10-07 06:20:00 | SPY | ETF | 105.69 | 105.8 | 105.63 | 105.7 | 16800.0 |
| 2008-10-07 06:25:00 | SPY | ETF | 105.84 | 106.13 | 105.84 | 106.13 | 22600.0 |
| 2008-10-07 06:30:00 | SPY | ETF | 105.81 | 105.81 | 105.73 | 105.73 | 2200.0 |
| 2008-10-07 06:35:00 | SPY | ETF | 105.89 | 106.02 | 105.89 | 106.02 | 2000.0 |
| 2008-10-07 06:40:00 | SPY | ETF | 106.05 | 106.05 | 105.85 | 105.85 | 3800.0 |
| 2008-10-07 06:45:00 | SPY | ETF | 105.88 | 105.88 | 105.88 | 105.88 | 100.0 |
| 2008-10-07 06:50:00 | SPY | ETF | 105.57 | 105.63 | 105.57 | 105.63 | 7000.0 |
| 2008-10-07 06:55:00 | SPY | ETF | 105.96 | 106.15 | 105.96 | 106.15 | 700.0 |
| 2008-10-07 07:00:00 | SPY | ETF | 106.13 | 106.19 | 105.88 | 106.0 | 36030.0 |
| 2008-10-07 07:05:00 | SPY | ETF | 105.98 | 105.99 | 105.84 | 105.84 | 57350.0 |
| 2008-10-07 07:10:00 | SPY | ETF | 105.84 | 106.0 | 105.81 | 105.95 | 121000.0 |
| 2008-10-07 07:15:00 | SPY | ETF | 105.95 | 106.0 | 105.95 | 106.0 | 62800.0 |
| 2008-10-07 07:20:00 | SPY | ETF | 105.99 | 106.15 | 105.99 | 106.0 | 42480.0 |
| 2008-10-07 07:25:00 | SPY | ETF | 106.02 | 106.05 | 105.77 | 105.8 | 146950.0 |
| 2008-10-07 07:30:00 | SPY | ETF | 105.77 | 105.77 | 105.58 | 105.77 | 87335.0 |
| 2008-10-07 07:35:00 | SPY | ETF | 105.8 | 105.86 | 105.72 | 105.85 | 20750.0 |
| 2008-10-07 07:40:00 | SPY | ETF | 105.85 | 105.98 | 105.8 | 105.92 | 104730.0 |
| 2008-10-07 07:45:00 | SPY | ETF | 105.92 | 105.92 | 105.76 | 105.88 | 223075.0 |
| 2008-10-07 07:50:00 | SPY | ETF | 105.9 | 105.93 | 105.86 | 105.9 | 20800.0 |
| 2008-10-07 07:55:00 | SPY | ETF | 105.93 | 106.2 | 105.93 | 106.08 | 69900.0 |
| 2008-10-07 08:00:00 | SPY | ETF | 106.07 | 106.832 | 105.33 | 106.06 | 737745.0 |
| 2008-10-07 08:05:00 | SPY | ETF | 105.3 | 106.14 | 105.3 | 106.13 | 219425.0 |
| 2008-10-07 08:10:00 | SPY | ETF | 106.11 | 106.5 | 105.1 | 106.14 | 316119.0 |
| 2008-10-07 08:15:00 | SPY | ETF | 106.15 | 106.47 | 104.96 | 105.33 | 1645319.0 |
| 2008-10-07 08:20:00 | SPY | ETF | 105.36 | 105.44 | 104.45 | 104.79 | 1467232.0 |
| 2008-10-07 08:25:00 | SPY | ETF | 104.8 | 105.14 | 104.67 | 104.7 | 947244.0 |
| 2008-10-07 08:30:00 | SPY | ETF | 104.7 | 105.27 | 104.65 | 105.13 | 1029262.0 |
| 2008-10-07 08:35:00 | SPY | ETF | 105.12 | 105.35 | 105.06 | 105.24 | 443034.0 |
| 2008-10-07 08:40:00 | SPY | ETF | 105.25 | 105.32 | 104.96 | 104.96 | 205275.0 |
| 2008-10-07 08:45:00 | SPY | ETF | 105.05 | 106.28 | 104.42 | 104.48 | 650030.0 |
| 2008-10-07 08:50:00 | SPY | ETF | 104.48 | 104.66 | 104.03 | 104.11 | 1342012.0 |
| 2008-10-07 08:55:00 | SPY | ETF | 104.07 | 104.56 | 104.06 | 104.46 | 610305.0 |
| 2008-10-07 09:00:00 | SPY | ETF | 104.46 | 106.6 | 104.46 | 106.32 | 8908315.0 |
| 2008-10-07 09:05:00 | SPY | ETF | 106.32 | 107.31 | 106.11 | 106.53 | 4714454.0 |
| 2008-10-07 09:10:00 | SPY | ETF | 106.49 | 107.1 | 106.4 | 106.9 | 1636533.0 |
| 2008-10-07 09:15:00 | SPY | ETF | 106.89 | 106.89 | 106.34 | 106.45 | 1323783.0 |
| 2008-10-07 09:20:00 | SPY | ETF | 106.46 | 107.14 | 106.44 | 107.14 | 2397915.0 |
| 2008-10-07 09:25:00 | SPY | ETF | 107.12 | 107.12 | 106.81 | 106.82 | 1529369.0 |
| 2008-10-07 09:30:00 | SPY | ETF | 106.84 | 107.02 | 106.16 | 106.24 | 8328896.0 |
| 2008-10-07 09:35:00 | SPY | ETF | 106.24 | 106.77 | 105.92 | 106.77 | 10398527.0 |
> showing 50 of 27,462 rows — these rows as CSV