PREVIEW / etf_5min / 2008-02-22
file: by_date/etf_5min/2008/2008-02-22.parquet size: 450 KB rows: 22,164
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-02-22 05:10:00 | SPY | ETF | 134.64 | 134.64 | 134.64 | 134.64 | 100.0 |
| 2008-02-22 05:35:00 | SPY | ETF | 134.86 | 134.86 | 134.86 | 134.86 | 4000.0 |
| 2008-02-22 06:50:00 | SPY | ETF | 134.51 | 134.53 | 134.49 | 134.49 | 97900.0 |
| 2008-02-22 06:55:00 | SPY | ETF | 134.5 | 134.52 | 134.49 | 134.52 | 46000.0 |
| 2008-02-22 07:00:00 | SPY | ETF | 134.52 | 134.59 | 134.52 | 134.52 | 16000.0 |
| 2008-02-22 07:05:00 | SPY | ETF | 134.52 | 134.53 | 134.5 | 134.52 | 27100.0 |
| 2008-02-22 07:10:00 | SPY | ETF | 134.52 | 134.7 | 134.52 | 134.69 | 39600.0 |
| 2008-02-22 07:15:00 | SPY | ETF | 134.7 | 134.7 | 134.67 | 134.68 | 31500.0 |
| 2008-02-22 07:20:00 | SPY | ETF | 134.68 | 134.68 | 134.64 | 134.64 | 6600.0 |
| 2008-02-22 07:25:00 | SPY | ETF | 134.64 | 134.64 | 134.57 | 134.59 | 51800.0 |
| 2008-02-22 07:30:00 | SPY | ETF | 134.6 | 134.6 | 134.5 | 134.5 | 1000.0 |
| 2008-02-22 07:35:00 | SPY | ETF | 134.5 | 134.5 | 134.44 | 134.45 | 78300.0 |
| 2008-02-22 07:40:00 | SPY | ETF | 134.4 | 134.47 | 134.4 | 134.47 | 4200.0 |
| 2008-02-22 07:45:00 | SPY | ETF | 134.47 | 134.47 | 134.37 | 134.4 | 86900.0 |
| 2008-02-22 07:50:00 | SPY | ETF | 134.36 | 134.49 | 134.36 | 134.46 | 11000.0 |
| 2008-02-22 07:55:00 | SPY | ETF | 134.47 | 134.54 | 134.46 | 134.52 | 3300.0 |
| 2008-02-22 08:00:00 | SPY | ETF | 134.52 | 134.58 | 134.52 | 134.55 | 115200.0 |
| 2008-02-22 08:05:00 | SPY | ETF | 134.53 | 134.79 | 134.53 | 134.75 | 95500.0 |
| 2008-02-22 08:10:00 | SPY | ETF | 134.75 | 134.78 | 134.7 | 134.7 | 26400.0 |
| 2008-02-22 08:15:00 | SPY | ETF | 134.7 | 134.84 | 134.63 | 134.71 | 141900.0 |
| 2008-02-22 08:20:00 | SPY | ETF | 134.7 | 134.77 | 134.7 | 134.77 | 40700.0 |
| 2008-02-22 08:25:00 | SPY | ETF | 134.76 | 134.92 | 134.75 | 134.81 | 90400.0 |
| 2008-02-22 08:30:00 | SPY | ETF | 134.78 | 134.94 | 134.77 | 134.93 | 95100.0 |
| 2008-02-22 08:35:00 | SPY | ETF | 134.95 | 135.12 | 134.93 | 135.11 | 457900.0 |
| 2008-02-22 08:40:00 | SPY | ETF | 135.1 | 135.15 | 135.08 | 135.11 | 244600.0 |
| 2008-02-22 08:45:00 | SPY | ETF | 135.11 | 135.14 | 135.08 | 135.08 | 35700.0 |
| 2008-02-22 08:50:00 | SPY | ETF | 135.08 | 135.11 | 135.07 | 135.1 | 126900.0 |
| 2008-02-22 08:55:00 | SPY | ETF | 135.11 | 135.27 | 135.11 | 135.22 | 206800.0 |
| 2008-02-22 09:00:00 | SPY | ETF | 135.23 | 135.24 | 135.12 | 135.12 | 206400.0 |
| 2008-02-22 09:05:00 | SPY | ETF | 135.12 | 135.19 | 135.11 | 135.18 | 80500.0 |
| 2008-02-22 09:10:00 | SPY | ETF | 135.18 | 135.18 | 135.07 | 135.07 | 77300.0 |
| 2008-02-22 09:15:00 | SPY | ETF | 135.07 | 135.07 | 135.01 | 135.03 | 100500.0 |
| 2008-02-22 09:20:00 | SPY | ETF | 135.02 | 135.04 | 135.0 | 135.0 | 32600.0 |
| 2008-02-22 09:25:00 | SPY | ETF | 135.0 | 135.02 | 134.96 | 134.98 | 317800.0 |
| 2008-02-22 09:30:00 | SPY | ETF | 134.97 | 135.0 | 134.75 | 134.77 | 1732336.0 |
| 2008-02-22 09:35:00 | SPY | ETF | 134.78 | 135.07 | 134.76 | 134.82 | 2355732.0 |
| 2008-02-22 09:40:00 | SPY | ETF | 134.82 | 134.84 | 134.54 | 134.55 | 2740684.0 |
| 2008-02-22 09:45:00 | SPY | ETF | 134.55 | 134.74 | 134.51 | 134.67 | 2786295.0 |
| 2008-02-22 09:50:00 | SPY | ETF | 134.67 | 134.67 | 134.41 | 134.5 | 3610952.0 |
| 2008-02-22 09:55:00 | SPY | ETF | 134.5 | 134.53 | 134.3 | 134.47 | 2142206.0 |
| 2008-02-22 10:00:00 | SPY | ETF | 134.47 | 134.47 | 134.13 | 134.16 | 2413952.0 |
| 2008-02-22 10:05:00 | SPY | ETF | 134.16 | 134.18 | 133.85 | 134.0 | 5210876.0 |
| 2008-02-22 10:10:00 | SPY | ETF | 133.99 | 134.04 | 133.77 | 134.03 | 3000702.0 |
| 2008-02-22 10:15:00 | SPY | ETF | 134.03 | 134.05 | 133.82 | 134.0 | 2245412.0 |
| 2008-02-22 10:20:00 | SPY | ETF | 133.99 | 133.99 | 133.58 | 133.65 | 3791122.0 |
| 2008-02-22 10:25:00 | SPY | ETF | 133.65 | 133.97 | 133.65 | 133.85 | 3211504.0 |
| 2008-02-22 10:30:00 | SPY | ETF | 133.86 | 133.93 | 133.34 | 133.34 | 4247377.0 |
| 2008-02-22 10:35:00 | SPY | ETF | 133.3412 | 133.54 | 133.33 | 133.341 | 2186836.0 |
| 2008-02-22 10:40:00 | SPY | ETF | 133.34 | 133.6 | 133.24 | 133.59 | 3693703.0 |
| 2008-02-22 10:45:00 | SPY | ETF | 133.59 | 133.73 | 133.51 | 133.66 | 2462485.0 |
> showing 50 of 22,164 rows — these rows as CSV