PREVIEW / etf_5min / 2008-12-26
file: by_date/etf_5min/2008/2008-12-26.parquet size: 544 KB rows: 23,359
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-12-26 07:00:00 | SPY | ETF | 87.04 | 87.06 | 87.02 | 87.06 | 21100.0 |
| 2008-12-26 07:05:00 | SPY | ETF | 87.06 | 87.06 | 87.06 | 87.06 | 100.0 |
| 2008-12-26 07:10:00 | SPY | ETF | 86.98 | 86.98 | 86.98 | 86.98 | 100.0 |
| 2008-12-26 07:20:00 | SPY | ETF | 87.05 | 87.05 | 87.04 | 87.04 | 1904.0 |
| 2008-12-26 07:25:00 | SPY | ETF | 87.07 | 87.08 | 87.07 | 87.08 | 600.0 |
| 2008-12-26 07:30:00 | SPY | ETF | 87.05 | 87.07 | 87.05 | 87.07 | 1400.0 |
| 2008-12-26 07:35:00 | SPY | ETF | 87.08 | 87.16 | 87.08 | 87.1 | 5900.0 |
| 2008-12-26 07:40:00 | SPY | ETF | 87.18 | 87.3 | 87.16 | 87.3 | 13808.0 |
| 2008-12-26 07:45:00 | SPY | ETF | 87.31 | 87.37 | 87.31 | 87.34 | 21626.0 |
| 2008-12-26 07:50:00 | SPY | ETF | 87.3 | 87.32 | 87.28 | 87.29 | 7209.0 |
| 2008-12-26 07:55:00 | SPY | ETF | 87.29 | 87.3 | 87.2 | 87.21 | 37106.0 |
| 2008-12-26 08:00:00 | SPY | ETF | 87.21 | 87.23 | 87.17 | 87.2 | 26272.0 |
| 2008-12-26 08:05:00 | SPY | ETF | 87.2 | 87.3 | 87.2 | 87.29 | 62112.0 |
| 2008-12-26 08:10:00 | SPY | ETF | 87.3 | 87.34 | 87.3 | 87.32 | 22656.0 |
| 2008-12-26 08:15:00 | SPY | ETF | 87.33 | 87.33 | 87.28 | 87.31 | 32057.0 |
| 2008-12-26 08:20:00 | SPY | ETF | 87.29 | 87.29 | 87.24 | 87.25 | 9204.0 |
| 2008-12-26 08:25:00 | SPY | ETF | 87.25 | 87.32 | 87.25 | 87.32 | 23000.0 |
| 2008-12-26 08:30:00 | SPY | ETF | 87.3 | 87.33 | 87.19 | 87.26 | 73923.0 |
| 2008-12-26 08:35:00 | SPY | ETF | 87.25 | 87.29 | 87.23 | 87.23 | 22500.0 |
| 2008-12-26 08:40:00 | SPY | ETF | 87.23 | 87.23 | 87.18 | 87.19 | 53863.0 |
| 2008-12-26 08:45:00 | SPY | ETF | 87.18 | 87.22 | 87.17 | 87.22 | 43317.0 |
| 2008-12-26 08:50:00 | SPY | ETF | 87.22 | 87.25 | 87.21 | 87.22 | 28338.0 |
| 2008-12-26 08:55:00 | SPY | ETF | 87.23 | 87.24 | 87.2 | 87.2 | 8898.0 |
| 2008-12-26 09:00:00 | SPY | ETF | 87.18 | 87.21 | 87.18 | 87.2 | 126200.0 |
| 2008-12-26 09:05:00 | SPY | ETF | 87.2 | 87.23 | 87.19 | 87.19 | 21304.0 |
| 2008-12-26 09:10:00 | SPY | ETF | 87.19 | 87.21 | 87.19 | 87.19 | 12924.0 |
| 2008-12-26 09:15:00 | SPY | ETF | 87.2 | 87.21 | 87.18 | 87.19 | 5635.0 |
| 2008-12-26 09:20:00 | SPY | ETF | 87.2 | 87.2 | 87.17 | 87.17 | 14631.0 |
| 2008-12-26 09:25:00 | SPY | ETF | 87.17 | 87.24 | 87.16 | 87.23 | 200905.0 |
| 2008-12-26 09:30:00 | SPY | ETF | 87.24 | 87.3 | 87.15 | 87.21 | 1802324.0 |
| 2008-12-26 09:35:00 | SPY | ETF | 87.2 | 87.26 | 87.14 | 87.2 | 1067816.0 |
| 2008-12-26 09:40:00 | SPY | ETF | 87.2 | 87.22 | 87.09 | 87.12 | 1485206.0 |
| 2008-12-26 09:45:00 | SPY | ETF | 87.12 | 87.12 | 87.0 | 87.08 | 1139518.0 |
| 2008-12-26 09:50:00 | SPY | ETF | 87.09 | 87.09 | 86.94 | 86.96 | 774113.0 |
| 2008-12-26 09:55:00 | SPY | ETF | 86.96 | 87.03 | 86.91 | 86.94 | 931851.0 |
| 2008-12-26 10:00:00 | SPY | ETF | 86.93 | 87.1 | 86.93 | 87.04 | 791897.0 |
| 2008-12-26 10:05:00 | SPY | ETF | 87.04 | 87.05 | 86.9912 | 86.9912 | 310758.0 |
| 2008-12-26 10:10:00 | SPY | ETF | 87.0 | 87.15 | 86.98 | 87.1 | 1443238.0 |
| 2008-12-26 10:15:00 | SPY | ETF | 87.1 | 87.14 | 87.07 | 87.1 | 948517.0 |
| 2008-12-26 10:20:00 | SPY | ETF | 87.1 | 87.11 | 87.01 | 87.05 | 961458.0 |
| 2008-12-26 10:25:00 | SPY | ETF | 87.06 | 87.06 | 86.93 | 86.96 | 721578.0 |
| 2008-12-26 10:30:00 | SPY | ETF | 86.95 | 87.0 | 86.94 | 86.96 | 563645.0 |
| 2008-12-26 10:35:00 | SPY | ETF | 86.96 | 86.97 | 86.83 | 86.88 | 1289672.0 |
| 2008-12-26 10:40:00 | SPY | ETF | 86.88 | 86.91 | 86.81 | 86.82 | 776718.0 |
| 2008-12-26 10:45:00 | SPY | ETF | 86.83 | 86.84 | 86.77 | 86.79 | 760671.0 |
| 2008-12-26 10:50:00 | SPY | ETF | 86.8 | 86.83 | 86.76 | 86.82 | 577473.0 |
| 2008-12-26 10:55:00 | SPY | ETF | 86.82 | 86.88 | 86.8 | 86.87 | 1105419.0 |
| 2008-12-26 11:00:00 | SPY | ETF | 86.87 | 86.92 | 86.83 | 86.91 | 691351.0 |
| 2008-12-26 11:05:00 | SPY | ETF | 86.91 | 86.95 | 86.91 | 86.94 | 695833.0 |
| 2008-12-26 11:10:00 | SPY | ETF | 86.93 | 86.94 | 86.77 | 86.82 | 1457777.0 |
> showing 50 of 23,359 rows — these rows as CSV