PREVIEW / etf_5min / 2008-07-18
file: by_date/etf_5min/2008/2008-07-18.parquet size: 503 KB rows: 23,667
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-07-18 04:45:00 | SPY | ETF | 124.75 | 124.75 | 124.75 | 124.75 | 500.0 |
| 2008-07-18 05:20:00 | SPY | ETF | 124.37 | 124.37 | 124.37 | 124.37 | 500.0 |
| 2008-07-18 05:30:00 | SPY | ETF | 124.57 | 124.6 | 124.57 | 124.6 | 10000.0 |
| 2008-07-18 05:40:00 | SPY | ETF | 124.6 | 124.6 | 124.6 | 124.6 | 1500.0 |
| 2008-07-18 05:50:00 | SPY | ETF | 124.6 | 124.6 | 124.58 | 124.58 | 8500.0 |
| 2008-07-18 05:55:00 | SPY | ETF | 124.5 | 124.5 | 124.5 | 124.5 | 5000.0 |
| 2008-07-18 06:00:00 | SPY | ETF | 124.68 | 124.68 | 124.68 | 124.68 | 1000.0 |
| 2008-07-18 06:05:00 | SPY | ETF | 124.64 | 124.64 | 124.64 | 124.64 | 1000.0 |
| 2008-07-18 06:10:00 | SPY | ETF | 124.62 | 124.63 | 124.62 | 124.63 | 7500.0 |
| 2008-07-18 06:25:00 | SPY | ETF | 124.74 | 124.74 | 124.74 | 124.74 | 500.0 |
| 2008-07-18 06:30:00 | SPY | ETF | 125.04 | 125.3 | 125.01 | 125.3 | 40800.0 |
| 2008-07-18 06:35:00 | SPY | ETF | 125.19 | 125.28 | 125.19 | 125.22 | 77200.0 |
| 2008-07-18 06:40:00 | SPY | ETF | 125.25 | 125.25 | 125.23 | 125.23 | 75000.0 |
| 2008-07-18 06:45:00 | SPY | ETF | 125.35 | 125.5 | 125.35 | 125.44 | 60000.0 |
| 2008-07-18 06:50:00 | SPY | ETF | 125.54 | 125.65 | 125.54 | 125.6 | 257500.0 |
| 2008-07-18 06:55:00 | SPY | ETF | 125.6 | 125.79 | 125.57 | 125.63 | 277300.0 |
| 2008-07-18 07:00:00 | SPY | ETF | 125.58 | 125.65 | 125.54 | 125.64 | 112800.0 |
| 2008-07-18 07:05:00 | SPY | ETF | 125.69 | 125.77 | 125.52 | 125.63 | 553043.0 |
| 2008-07-18 07:10:00 | SPY | ETF | 125.63 | 125.78 | 125.63 | 125.68 | 467850.0 |
| 2008-07-18 07:15:00 | SPY | ETF | 125.66 | 125.79 | 125.66 | 125.78 | 422700.0 |
| 2008-07-18 07:20:00 | SPY | ETF | 125.73 | 125.76 | 125.66 | 125.66 | 16464.0 |
| 2008-07-18 07:25:00 | SPY | ETF | 125.7 | 125.95 | 125.7 | 125.85 | 466742.0 |
| 2008-07-18 07:30:00 | SPY | ETF | 125.85 | 125.92 | 125.83 | 125.86 | 506608.0 |
| 2008-07-18 07:35:00 | SPY | ETF | 125.87 | 125.89 | 125.75 | 125.87 | 292821.0 |
| 2008-07-18 07:40:00 | SPY | ETF | 125.89 | 125.99 | 125.85 | 125.98 | 202973.0 |
| 2008-07-18 07:45:00 | SPY | ETF | 125.97 | 126.08 | 125.87 | 125.9 | 474368.0 |
| 2008-07-18 07:50:00 | SPY | ETF | 125.9 | 125.97 | 125.83 | 125.83 | 221500.0 |
| 2008-07-18 07:55:00 | SPY | ETF | 125.84 | 125.9 | 125.8 | 125.87 | 97219.0 |
| 2008-07-18 08:00:00 | SPY | ETF | 125.86 | 125.96 | 125.26 | 125.95 | 564458.0 |
| 2008-07-18 08:05:00 | SPY | ETF | 125.95 | 125.98 | 125.92 | 125.98 | 352177.0 |
| 2008-07-18 08:10:00 | SPY | ETF | 125.68 | 126.04 | 125.65 | 125.98 | 417155.0 |
| 2008-07-18 08:15:00 | SPY | ETF | 125.95 | 126.04 | 125.95 | 125.99 | 100000.0 |
| 2008-07-18 08:20:00 | SPY | ETF | 125.98 | 126.02 | 125.95 | 125.96 | 931921.0 |
| 2008-07-18 08:25:00 | SPY | ETF | 125.99 | 126.17 | 125.97 | 126.16 | 576555.0 |
| 2008-07-18 08:30:00 | SPY | ETF | 126.15 | 126.19 | 125.96 | 125.98 | 389807.0 |
| 2008-07-18 08:35:00 | SPY | ETF | 126.01 | 126.08 | 125.99 | 126.05 | 202030.0 |
| 2008-07-18 08:40:00 | SPY | ETF | 126.05 | 126.05 | 125.79 | 125.8 | 370078.0 |
| 2008-07-18 08:45:00 | SPY | ETF | 125.83 | 125.86 | 125.73 | 125.74 | 447564.0 |
| 2008-07-18 08:50:00 | SPY | ETF | 125.74 | 126.11 | 125.72 | 126.03 | 490606.0 |
| 2008-07-18 08:55:00 | SPY | ETF | 126.04 | 126.19 | 125.96 | 126.13 | 299621.0 |
| 2008-07-18 09:00:00 | SPY | ETF | 126.14 | 126.23 | 126.11 | 126.19 | 1071753.0 |
| 2008-07-18 09:05:00 | SPY | ETF | 126.22 | 126.26 | 126.14 | 126.14 | 404653.0 |
| 2008-07-18 09:10:00 | SPY | ETF | 126.15 | 126.16 | 126.03 | 126.11 | 520146.0 |
| 2008-07-18 09:15:00 | SPY | ETF | 126.11 | 126.17 | 126.11 | 126.11 | 1850121.0 |
| 2008-07-18 09:20:00 | SPY | ETF | 126.11 | 126.11 | 125.95 | 126.04 | 648738.0 |
| 2008-07-18 09:25:00 | SPY | ETF | 126.03 | 126.2 | 125.99 | 126.18 | 676182.0 |
| 2008-07-18 09:30:00 | SPY | ETF | 126.17 | 126.25 | 125.78 | 125.81 | 7898540.0 |
| 2008-07-18 09:35:00 | SPY | ETF | 125.81 | 125.81 | 125.54 | 125.63 | 5297569.0 |
| 2008-07-18 09:40:00 | SPY | ETF | 125.64 | 126.39 | 125.34 | 125.48 | 9384344.0 |
| 2008-07-18 09:45:00 | SPY | ETF | 125.48 | 125.7 | 125.28 | 125.65 | 6911236.0 |
> showing 50 of 23,667 rows — these rows as CSV