PREVIEW / etf_5min / 2008-08-13
file: by_date/etf_5min/2008/2008-08-13.parquet size: 509 KB rows: 23,750
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-08-13 05:35:00 | SPY | ETF | 129.24 | 129.24 | 129.24 | 129.24 | 2500.0 |
| 2008-08-13 06:00:00 | SPY | ETF | 129.1 | 129.1 | 129.1 | 129.1 | 1500.0 |
| 2008-08-13 06:05:00 | SPY | ETF | 129.18 | 129.27 | 129.18 | 129.26 | 49000.0 |
| 2008-08-13 06:10:00 | SPY | ETF | 129.26 | 129.26 | 129.26 | 129.26 | 2000.0 |
| 2008-08-13 06:45:00 | SPY | ETF | 129.09 | 129.13 | 129.08 | 129.08 | 184500.0 |
| 2008-08-13 06:50:00 | SPY | ETF | 129.14 | 129.2 | 129.11 | 129.2 | 52100.0 |
| 2008-08-13 06:55:00 | SPY | ETF | 129.14 | 129.15 | 129.11 | 129.11 | 44300.0 |
| 2008-08-13 07:00:00 | SPY | ETF | 129.11 | 129.13 | 129.04 | 129.07 | 109800.0 |
| 2008-08-13 07:05:00 | SPY | ETF | 129.12 | 129.19 | 129.12 | 129.17 | 50600.0 |
| 2008-08-13 07:10:00 | SPY | ETF | 129.17 | 129.17 | 129.12 | 129.12 | 16350.0 |
| 2008-08-13 07:15:00 | SPY | ETF | 129.04 | 129.13 | 129.03 | 129.13 | 35350.0 |
| 2008-08-13 07:20:00 | SPY | ETF | 129.1 | 129.1 | 129.05 | 129.06 | 38300.0 |
| 2008-08-13 07:25:00 | SPY | ETF | 129.07 | 129.07 | 129.0 | 129.03 | 31350.0 |
| 2008-08-13 07:30:00 | SPY | ETF | 129.06 | 129.09 | 129.05 | 129.09 | 60300.0 |
| 2008-08-13 07:35:00 | SPY | ETF | 129.11 | 129.11 | 129.11 | 129.11 | 2500.0 |
| 2008-08-13 07:40:00 | SPY | ETF | 129.11 | 129.11 | 129.1 | 129.11 | 2989.0 |
| 2008-08-13 07:45:00 | SPY | ETF | 129.08 | 129.08 | 128.97 | 129.0 | 100243.0 |
| 2008-08-13 07:50:00 | SPY | ETF | 129.0 | 129.0 | 128.9 | 128.95 | 69888.0 |
| 2008-08-13 07:55:00 | SPY | ETF | 128.95 | 128.95 | 128.83 | 128.86 | 111428.0 |
| 2008-08-13 08:00:00 | SPY | ETF | 128.86 | 129.25 | 128.81 | 128.84 | 171272.0 |
| 2008-08-13 08:05:00 | SPY | ETF | 128.84 | 129.01 | 128.81 | 128.98 | 294118.0 |
| 2008-08-13 08:10:00 | SPY | ETF | 128.97 | 128.98 | 128.79 | 128.8 | 225323.0 |
| 2008-08-13 08:15:00 | SPY | ETF | 128.81 | 128.81 | 128.65 | 128.7 | 354869.0 |
| 2008-08-13 08:20:00 | SPY | ETF | 128.7 | 128.72 | 128.56 | 128.7 | 441415.0 |
| 2008-08-13 08:25:00 | SPY | ETF | 128.7 | 128.79 | 128.65 | 128.72 | 280980.0 |
| 2008-08-13 08:30:00 | SPY | ETF | 128.7 | 128.82 | 128.57 | 128.65 | 972806.0 |
| 2008-08-13 08:35:00 | SPY | ETF | 128.67 | 128.7 | 128.47 | 128.5 | 563450.0 |
| 2008-08-13 08:40:00 | SPY | ETF | 128.51 | 128.64 | 128.48 | 128.63 | 342219.0 |
| 2008-08-13 08:45:00 | SPY | ETF | 128.64 | 128.67 | 128.57 | 128.64 | 146823.0 |
| 2008-08-13 08:50:00 | SPY | ETF | 128.62 | 128.7 | 128.62 | 128.67 | 69140.0 |
| 2008-08-13 08:55:00 | SPY | ETF | 128.67 | 128.72 | 128.65 | 128.68 | 83182.0 |
| 2008-08-13 09:00:00 | SPY | ETF | 128.69 | 128.74 | 128.67 | 128.7 | 76500.0 |
| 2008-08-13 09:05:00 | SPY | ETF | 128.71 | 128.78 | 128.67 | 128.78 | 150539.0 |
| 2008-08-13 09:10:00 | SPY | ETF | 128.79 | 128.81 | 128.74 | 128.77 | 302361.0 |
| 2008-08-13 09:15:00 | SPY | ETF | 128.79 | 128.79 | 128.73 | 128.75 | 57691.0 |
| 2008-08-13 09:20:00 | SPY | ETF | 128.76 | 128.78 | 128.75 | 128.77 | 40722.0 |
| 2008-08-13 09:25:00 | SPY | ETF | 128.76 | 128.79 | 128.72 | 128.79 | 74493.0 |
| 2008-08-13 09:30:00 | SPY | ETF | 128.79 | 128.87 | 128.59 | 128.85 | 5887067.0 |
| 2008-08-13 09:35:00 | SPY | ETF | 128.85 | 128.94 | 128.54 | 128.57 | 4377814.0 |
| 2008-08-13 09:40:00 | SPY | ETF | 128.58 | 128.6 | 128.35 | 128.52 | 4835658.0 |
| 2008-08-13 09:45:00 | SPY | ETF | 128.52 | 128.52 | 128.23 | 128.43 | 5899812.0 |
| 2008-08-13 09:50:00 | SPY | ETF | 128.42 | 128.58 | 128.32 | 128.5 | 3358221.0 |
| 2008-08-13 09:55:00 | SPY | ETF | 128.5 | 128.55 | 128.41 | 128.5 | 2913002.0 |
| 2008-08-13 10:00:00 | SPY | ETF | 128.5 | 129.35 | 128.33 | 128.7 | 4824393.0 |
| 2008-08-13 10:05:00 | SPY | ETF | 128.69 | 128.7 | 128.44 | 128.53 | 3026729.0 |
| 2008-08-13 10:10:00 | SPY | ETF | 128.53 | 128.53 | 128.35 | 128.36 | 1919778.0 |
| 2008-08-13 10:15:00 | SPY | ETF | 128.36 | 128.38 | 128.24 | 128.33 | 3065549.0 |
| 2008-08-13 10:20:00 | SPY | ETF | 128.33 | 128.55 | 128.33 | 128.51 | 2705238.0 |
| 2008-08-13 10:25:00 | SPY | ETF | 128.5 | 128.5097 | 128.23 | 128.3001 | 2310694.0 |
| 2008-08-13 10:30:00 | SPY | ETF | 128.3 | 128.37 | 128.1225 | 128.21 | 6163196.0 |
> showing 50 of 23,750 rows — these rows as CSV