PREVIEW / etf_5min / 2008-03-05
file: by_date/etf_5min/2008/2008-03-05.parquet size: 469 KB rows: 22,863
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-03-05 04:15:00 | SPY | ETF | 132.86 | 132.86 | 132.86 | 132.86 | 100.0 |
| 2008-03-05 05:35:00 | SPY | ETF | 133.2 | 133.2 | 133.2 | 133.2 | 5000.0 |
| 2008-03-05 05:50:00 | SPY | ETF | 133.15 | 133.16 | 133.15 | 133.16 | 8000.0 |
| 2008-03-05 06:00:00 | SPY | ETF | 133.25 | 133.25 | 133.25 | 133.25 | 100.0 |
| 2008-03-05 06:10:00 | SPY | ETF | 133.38 | 133.38 | 133.38 | 133.38 | 500.0 |
| 2008-03-05 06:20:00 | SPY | ETF | 133.42 | 133.46 | 133.42 | 133.46 | 1000.0 |
| 2008-03-05 06:35:00 | SPY | ETF | 133.49 | 133.49 | 133.49 | 133.49 | 2000.0 |
| 2008-03-05 06:45:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 2500.0 |
| 2008-03-05 06:50:00 | SPY | ETF | 133.6 | 133.64 | 133.56 | 133.56 | 49500.0 |
| 2008-03-05 06:55:00 | SPY | ETF | 133.65 | 133.68 | 133.65 | 133.68 | 105000.0 |
| 2008-03-05 07:00:00 | SPY | ETF | 133.69 | 133.76 | 133.6 | 133.76 | 127800.0 |
| 2008-03-05 07:05:00 | SPY | ETF | 133.71 | 133.71 | 133.53 | 133.53 | 70800.0 |
| 2008-03-05 07:10:00 | SPY | ETF | 133.5 | 133.53 | 133.45 | 133.48 | 11600.0 |
| 2008-03-05 07:15:00 | SPY | ETF | 133.5 | 133.68 | 133.47 | 133.68 | 37900.0 |
| 2008-03-05 07:20:00 | SPY | ETF | 133.69 | 133.69 | 133.64 | 133.68 | 76300.0 |
| 2008-03-05 07:25:00 | SPY | ETF | 133.63 | 133.63 | 133.55 | 133.62 | 13500.0 |
| 2008-03-05 07:30:00 | SPY | ETF | 133.63 | 133.68 | 133.56 | 133.56 | 13400.0 |
| 2008-03-05 07:35:00 | SPY | ETF | 133.57 | 133.6 | 133.52 | 133.54 | 12700.0 |
| 2008-03-05 07:40:00 | SPY | ETF | 133.5 | 133.52 | 133.45 | 133.47 | 12400.0 |
| 2008-03-05 07:45:00 | SPY | ETF | 133.48 | 133.54 | 133.41 | 133.54 | 29800.0 |
| 2008-03-05 07:50:00 | SPY | ETF | 133.46 | 133.66 | 133.46 | 133.61 | 126200.0 |
| 2008-03-05 07:55:00 | SPY | ETF | 133.61 | 133.84 | 133.61 | 133.77 | 487300.0 |
| 2008-03-05 08:00:00 | SPY | ETF | 133.77 | 133.81 | 133.53 | 133.78 | 799100.0 |
| 2008-03-05 08:05:00 | SPY | ETF | 133.77 | 133.78 | 133.65 | 133.7 | 194500.0 |
| 2008-03-05 08:10:00 | SPY | ETF | 133.7 | 133.77 | 133.7 | 133.77 | 340000.0 |
| 2008-03-05 08:15:00 | SPY | ETF | 133.79 | 133.8 | 133.1 | 133.5 | 999800.0 |
| 2008-03-05 08:20:00 | SPY | ETF | 133.5 | 133.52 | 133.28 | 133.4 | 347000.0 |
| 2008-03-05 08:25:00 | SPY | ETF | 133.4 | 133.6 | 133.33 | 133.36 | 129698.0 |
| 2008-03-05 08:30:00 | SPY | ETF | 133.36 | 133.42 | 133.18 | 133.27 | 1118500.0 |
| 2008-03-05 08:35:00 | SPY | ETF | 133.25 | 133.38 | 133.24 | 133.3 | 149700.0 |
| 2008-03-05 08:40:00 | SPY | ETF | 133.29 | 133.36 | 133.25 | 133.34 | 106700.0 |
| 2008-03-05 08:45:00 | SPY | ETF | 133.34 | 133.35 | 133.24 | 133.3 | 135800.0 |
| 2008-03-05 08:50:00 | SPY | ETF | 133.29 | 133.33 | 133.22 | 133.28 | 142900.0 |
| 2008-03-05 08:55:00 | SPY | ETF | 133.28 | 133.41 | 133.28 | 133.35 | 356100.0 |
| 2008-03-05 09:00:00 | SPY | ETF | 133.31 | 133.39 | 133.28 | 133.38 | 303300.0 |
| 2008-03-05 09:05:00 | SPY | ETF | 133.38 | 133.52 | 132.99 | 133.51 | 218300.0 |
| 2008-03-05 09:10:00 | SPY | ETF | 133.51 | 133.54 | 133.46 | 133.48 | 148500.0 |
| 2008-03-05 09:15:00 | SPY | ETF | 133.46 | 133.54 | 133.42 | 133.47 | 124000.0 |
| 2008-03-05 09:20:00 | SPY | ETF | 133.45 | 133.5 | 133.4 | 133.42 | 61100.0 |
| 2008-03-05 09:25:00 | SPY | ETF | 133.41 | 133.42 | 133.34 | 133.4 | 137900.0 |
| 2008-03-05 09:30:00 | SPY | ETF | 133.41 | 133.5 | 133.25 | 133.46 | 4789786.0 |
| 2008-03-05 09:35:00 | SPY | ETF | 133.46 | 133.64 | 133.36 | 133.48 | 2575063.0 |
| 2008-03-05 09:40:00 | SPY | ETF | 133.48 | 133.52 | 133.17 | 133.36 | 2982168.0 |
| 2008-03-05 09:45:00 | SPY | ETF | 133.35 | 133.66 | 133.35 | 133.63 | 2026400.0 |
| 2008-03-05 09:50:00 | SPY | ETF | 133.63 | 133.78 | 133.58 | 133.64 | 3732594.0 |
| 2008-03-05 09:55:00 | SPY | ETF | 133.641 | 133.74 | 133.6 | 133.68 | 2168509.0 |
| 2008-03-05 10:00:00 | SPY | ETF | 133.68 | 134.39 | 133.63 | 134.33 | 11010327.0 |
| 2008-03-05 10:05:00 | SPY | ETF | 134.34 | 134.34 | 134.08 | 134.19 | 3639090.0 |
| 2008-03-05 10:10:00 | SPY | ETF | 134.19 | 134.29 | 134.06 | 134.24 | 2800695.0 |
| 2008-03-05 10:15:00 | SPY | ETF | 134.2101 | 134.51 | 134.18 | 134.41 | 5636207.0 |
> showing 50 of 22,863 rows — these rows as CSV