PREVIEW / etf_5min / 2008-11-25
file: by_date/etf_5min/2008/2008-11-25.parquet size: 575 KB rows: 27,413
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-11-25 04:15:00 | SPY | ETF | 84.33 | 84.46 | 84.33 | 84.46 | 300.0 |
| 2008-11-25 04:20:00 | SPY | ETF | 84.41 | 84.41 | 84.41 | 84.41 | 100.0 |
| 2008-11-25 04:30:00 | SPY | ETF | 84.69 | 84.69 | 84.69 | 84.69 | 100.0 |
| 2008-11-25 04:40:00 | SPY | ETF | 84.69 | 84.69 | 84.69 | 84.69 | 100.0 |
| 2008-11-25 04:50:00 | SPY | ETF | 84.75 | 84.77 | 84.75 | 84.77 | 200.0 |
| 2008-11-25 05:00:00 | SPY | ETF | 84.82 | 84.82 | 84.82 | 84.82 | 100.0 |
| 2008-11-25 05:05:00 | SPY | ETF | 84.66 | 84.66 | 84.55 | 84.55 | 200.0 |
| 2008-11-25 05:10:00 | SPY | ETF | 84.44 | 84.48 | 84.33 | 84.33 | 400.0 |
| 2008-11-25 05:15:00 | SPY | ETF | 84.44 | 84.56 | 84.44 | 84.56 | 200.0 |
| 2008-11-25 05:25:00 | SPY | ETF | 84.77 | 84.77 | 84.77 | 84.77 | 100.0 |
| 2008-11-25 05:30:00 | SPY | ETF | 84.71 | 84.71 | 84.71 | 84.71 | 500.0 |
| 2008-11-25 05:35:00 | SPY | ETF | 84.86 | 84.93 | 84.86 | 84.93 | 1000.0 |
| 2008-11-25 05:40:00 | SPY | ETF | 85.08 | 85.08 | 84.95 | 84.95 | 1255.0 |
| 2008-11-25 05:50:00 | SPY | ETF | 84.81 | 84.81 | 84.81 | 84.81 | 885.0 |
| 2008-11-25 05:55:00 | SPY | ETF | 84.78 | 84.81 | 84.77 | 84.77 | 785.0 |
| 2008-11-25 06:05:00 | SPY | ETF | 84.82 | 84.82 | 84.82 | 84.82 | 100.0 |
| 2008-11-25 06:10:00 | SPY | ETF | 84.93 | 84.93 | 84.93 | 84.93 | 1600.0 |
| 2008-11-25 06:15:00 | SPY | ETF | 84.96 | 84.96 | 84.96 | 84.96 | 700.0 |
| 2008-11-25 06:20:00 | SPY | ETF | 84.91 | 85.01 | 84.91 | 85.01 | 1585.0 |
| 2008-11-25 06:25:00 | SPY | ETF | 85.04 | 85.38 | 85.04 | 85.38 | 14767.0 |
| 2008-11-25 06:30:00 | SPY | ETF | 85.41 | 85.58 | 85.41 | 85.58 | 2840.0 |
| 2008-11-25 06:35:00 | SPY | ETF | 85.46 | 85.46 | 85.46 | 85.46 | 5000.0 |
| 2008-11-25 06:40:00 | SPY | ETF | 85.5 | 85.88 | 85.48 | 85.88 | 17600.0 |
| 2008-11-25 06:45:00 | SPY | ETF | 85.89 | 86.33 | 85.89 | 86.33 | 6700.0 |
| 2008-11-25 06:50:00 | SPY | ETF | 86.28 | 86.28 | 86.09 | 86.22 | 14300.0 |
| 2008-11-25 06:55:00 | SPY | ETF | 86.28 | 86.36 | 86.13 | 86.28 | 8500.0 |
| 2008-11-25 07:00:00 | SPY | ETF | 86.3 | 86.35 | 86.1 | 86.1 | 61297.0 |
| 2008-11-25 07:05:00 | SPY | ETF | 86.1 | 86.12 | 85.92 | 85.92 | 23100.0 |
| 2008-11-25 07:10:00 | SPY | ETF | 85.95 | 86.01 | 85.9 | 86.01 | 70550.0 |
| 2008-11-25 07:15:00 | SPY | ETF | 85.99 | 86.01 | 85.85 | 85.86 | 123738.0 |
| 2008-11-25 07:20:00 | SPY | ETF | 85.86 | 85.95 | 85.76 | 85.76 | 186815.0 |
| 2008-11-25 07:25:00 | SPY | ETF | 85.76 | 85.82 | 85.65 | 85.65 | 115377.0 |
| 2008-11-25 07:30:00 | SPY | ETF | 85.67 | 85.77 | 85.67 | 85.77 | 67346.0 |
| 2008-11-25 07:35:00 | SPY | ETF | 85.77 | 85.8 | 85.67 | 85.7 | 117173.0 |
| 2008-11-25 07:40:00 | SPY | ETF | 85.7 | 85.71 | 85.42 | 85.42 | 78504.0 |
| 2008-11-25 07:45:00 | SPY | ETF | 85.4 | 85.42 | 85.05 | 85.12 | 163364.0 |
| 2008-11-25 07:50:00 | SPY | ETF | 85.12 | 85.2 | 85.11 | 85.16 | 66096.0 |
| 2008-11-25 07:55:00 | SPY | ETF | 85.19 | 85.27 | 85.15 | 85.15 | 71450.0 |
| 2008-11-25 08:00:00 | SPY | ETF | 85.13 | 85.16 | 84.79 | 84.8 | 233922.0 |
| 2008-11-25 08:05:00 | SPY | ETF | 84.81 | 84.92 | 84.78 | 84.91 | 204927.0 |
| 2008-11-25 08:10:00 | SPY | ETF | 84.91 | 85.0 | 84.88 | 84.97 | 159714.0 |
| 2008-11-25 08:15:00 | SPY | ETF | 84.97 | 86.84 | 84.97 | 86.83 | 4598037.0 |
| 2008-11-25 08:20:00 | SPY | ETF | 86.82 | 86.92 | 84.7 | 86.31 | 1877990.0 |
| 2008-11-25 08:25:00 | SPY | ETF | 86.31 | 86.64 | 86.09 | 86.39 | 1448019.0 |
| 2008-11-25 08:30:00 | SPY | ETF | 86.39 | 87.21 | 86.22 | 87.21 | 2181720.0 |
| 2008-11-25 08:35:00 | SPY | ETF | 87.21 | 87.51 | 87.13 | 87.28 | 2194806.0 |
| 2008-11-25 08:40:00 | SPY | ETF | 87.28 | 87.59 | 87.2 | 87.32 | 1321021.0 |
| 2008-11-25 08:45:00 | SPY | ETF | 87.32 | 87.4 | 87.11 | 87.19 | 1068471.0 |
| 2008-11-25 08:50:00 | SPY | ETF | 87.19 | 87.73 | 87.18 | 87.72 | 671631.0 |
| 2008-11-25 08:55:00 | SPY | ETF | 87.72 | 87.75 | 87.25 | 87.27 | 1562440.0 |
> showing 50 of 27,413 rows — these rows as CSV