PREVIEW / etf_5min / 2008-05-28
file: by_date/etf_5min/2008/2008-05-28.parquet size: 459 KB rows: 21,449
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-05-28 04:45:00 | SPY | ETF | 138.89 | 138.89 | 138.89 | 138.89 | 1000.0 |
| 2008-05-28 04:50:00 | SPY | ETF | 138.8 | 138.8 | 138.8 | 138.8 | 500.0 |
| 2008-05-28 05:25:00 | SPY | ETF | 138.84 | 138.84 | 138.81 | 138.81 | 2070.0 |
| 2008-05-28 05:35:00 | SPY | ETF | 138.92 | 138.92 | 138.92 | 138.92 | 100.0 |
| 2008-05-28 06:05:00 | SPY | ETF | 138.95 | 138.95 | 138.95 | 138.95 | 100.0 |
| 2008-05-28 06:20:00 | SPY | ETF | 139.07 | 139.07 | 139.07 | 139.07 | 700.0 |
| 2008-05-28 06:25:00 | SPY | ETF | 139.13 | 139.13 | 139.13 | 139.13 | 2000.0 |
| 2008-05-28 06:30:00 | SPY | ETF | 139.08 | 139.08 | 139.08 | 139.08 | 1000.0 |
| 2008-05-28 06:50:00 | SPY | ETF | 138.87 | 138.95 | 138.87 | 138.95 | 3000.0 |
| 2008-05-28 06:55:00 | SPY | ETF | 138.95 | 138.95 | 138.95 | 138.95 | 500.0 |
| 2008-05-28 07:00:00 | SPY | ETF | 138.92 | 138.92 | 138.92 | 138.92 | 100.0 |
| 2008-05-28 07:05:00 | SPY | ETF | 138.92 | 138.92 | 138.92 | 138.92 | 100.0 |
| 2008-05-28 07:10:00 | SPY | ETF | 138.95 | 139.06 | 138.95 | 139.0 | 416674.0 |
| 2008-05-28 07:15:00 | SPY | ETF | 139.01 | 139.08 | 139.0 | 139.0 | 70800.0 |
| 2008-05-28 07:20:00 | SPY | ETF | 139.0 | 139.02 | 138.95 | 139.02 | 70600.0 |
| 2008-05-28 07:25:00 | SPY | ETF | 139.01 | 139.03 | 138.98 | 139.03 | 205950.0 |
| 2008-05-28 07:30:00 | SPY | ETF | 139.02 | 139.02 | 139.01 | 139.01 | 100000.0 |
| 2008-05-28 07:35:00 | SPY | ETF | 139.03 | 139.15 | 139.03 | 139.13 | 347100.0 |
| 2008-05-28 07:40:00 | SPY | ETF | 139.13 | 139.23 | 139.13 | 139.14 | 488212.0 |
| 2008-05-28 07:45:00 | SPY | ETF | 139.15 | 139.21 | 139.15 | 139.21 | 273688.0 |
| 2008-05-28 07:50:00 | SPY | ETF | 139.2 | 139.22 | 139.18 | 139.18 | 40031.0 |
| 2008-05-28 07:55:00 | SPY | ETF | 139.2 | 139.28 | 139.2 | 139.26 | 81183.0 |
| 2008-05-28 08:00:00 | SPY | ETF | 139.24 | 139.29 | 139.18 | 139.18 | 672568.0 |
| 2008-05-28 08:05:00 | SPY | ETF | 139.18 | 139.22 | 138.66 | 139.1 | 2798182.0 |
| 2008-05-28 08:10:00 | SPY | ETF | 139.0 | 139.19 | 139.0 | 139.17 | 680356.0 |
| 2008-05-28 08:15:00 | SPY | ETF | 139.15 | 139.2 | 139.14 | 139.14 | 104436.0 |
| 2008-05-28 08:20:00 | SPY | ETF | 139.13 | 139.16 | 139.08 | 139.11 | 178014.0 |
| 2008-05-28 08:25:00 | SPY | ETF | 139.1 | 139.1 | 139.03 | 139.04 | 354994.0 |
| 2008-05-28 08:30:00 | SPY | ETF | 139.05 | 139.58 | 139.05 | 139.48 | 2844064.0 |
| 2008-05-28 08:35:00 | SPY | ETF | 139.48 | 139.54 | 139.46 | 139.5 | 430924.0 |
| 2008-05-28 08:40:00 | SPY | ETF | 139.5 | 139.59 | 139.48 | 139.54 | 388235.0 |
| 2008-05-28 08:45:00 | SPY | ETF | 139.54 | 139.55 | 139.33 | 139.39 | 603978.0 |
| 2008-05-28 08:50:00 | SPY | ETF | 139.39 | 139.42 | 139.31 | 139.33 | 86769.0 |
| 2008-05-28 08:55:00 | SPY | ETF | 139.33 | 139.42 | 139.29 | 139.32 | 473333.0 |
| 2008-05-28 09:00:00 | SPY | ETF | 139.32 | 139.34 | 139.27 | 139.28 | 206356.0 |
| 2008-05-28 09:05:00 | SPY | ETF | 139.27 | 139.28 | 139.2 | 139.25 | 103430.0 |
| 2008-05-28 09:10:00 | SPY | ETF | 139.26 | 139.29 | 139.19 | 139.2 | 402227.0 |
| 2008-05-28 09:15:00 | SPY | ETF | 139.2 | 139.3 | 139.15 | 139.15 | 492835.0 |
| 2008-05-28 09:20:00 | SPY | ETF | 139.17 | 139.23 | 139.16 | 139.23 | 640798.0 |
| 2008-05-28 09:25:00 | SPY | ETF | 139.23 | 139.23 | 139.14 | 139.18 | 215242.0 |
| 2008-05-28 09:30:00 | SPY | ETF | 139.17 | 140.0 | 139.12 | 139.21 | 3198189.0 |
| 2008-05-28 09:35:00 | SPY | ETF | 139.21 | 139.23 | 138.97 | 139.19 | 2515804.0 |
| 2008-05-28 09:40:00 | SPY | ETF | 139.19 | 139.28 | 138.98 | 138.99 | 4241395.0 |
| 2008-05-28 09:45:00 | SPY | ETF | 138.99 | 139.06 | 138.78 | 138.83 | 2756395.0 |
| 2008-05-28 09:50:00 | SPY | ETF | 138.8201 | 138.97 | 138.77 | 138.79 | 3147973.0 |
| 2008-05-28 09:55:00 | SPY | ETF | 138.79 | 138.93 | 138.72 | 138.9 | 2901162.0 |
| 2008-05-28 10:00:00 | SPY | ETF | 138.9099 | 138.92 | 138.63 | 138.65 | 2089363.0 |
| 2008-05-28 10:05:00 | SPY | ETF | 138.65 | 138.73 | 138.57 | 138.59 | 2653108.0 |
| 2008-05-28 10:10:00 | SPY | ETF | 138.5901 | 138.72 | 138.5 | 138.67 | 2918003.0 |
| 2008-05-28 10:15:00 | SPY | ETF | 138.67 | 138.72 | 138.39 | 138.391 | 3207015.0 |
> showing 50 of 21,449 rows — these rows as CSV