PREVIEW / etf_5min / 2011-02-18
file: by_date/etf_5min/2011/2011-02-18.parquet size: 855 KB rows: 36,170
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-18 04:10:00 | SPY | ETF | 134.19 | 134.19 | 134.19 | 134.19 | 100.0 |
| 2011-02-18 04:25:00 | SPY | ETF | 134.14 | 134.15 | 134.14 | 134.15 | 7094.0 |
| 2011-02-18 04:30:00 | SPY | ETF | 134.14 | 134.14 | 134.14 | 134.14 | 300.0 |
| 2011-02-18 04:45:00 | SPY | ETF | 134.1 | 134.1 | 134.1 | 134.1 | 900.0 |
| 2011-02-18 04:50:00 | SPY | ETF | 134.1 | 134.1 | 134.1 | 134.1 | 600.0 |
| 2011-02-18 05:10:00 | SPY | ETF | 134.01 | 134.01 | 133.96 | 133.98 | 5050.0 |
| 2011-02-18 05:15:00 | SPY | ETF | 134.01 | 134.01 | 134.0 | 134.0 | 1000.0 |
| 2011-02-18 05:35:00 | SPY | ETF | 133.99 | 133.99 | 133.99 | 133.99 | 2000.0 |
| 2011-02-18 05:50:00 | SPY | ETF | 134.01 | 134.05 | 134.01 | 134.04 | 6500.0 |
| 2011-02-18 06:45:00 | SPY | ETF | 134.09 | 134.09 | 134.08 | 134.08 | 400.0 |
| 2011-02-18 06:50:00 | SPY | ETF | 134.08 | 134.08 | 134.08 | 134.08 | 1000.0 |
| 2011-02-18 06:55:00 | SPY | ETF | 134.08 | 134.08 | 134.08 | 134.08 | 31000.0 |
| 2011-02-18 07:00:00 | SPY | ETF | 134.09 | 134.11 | 134.08 | 134.11 | 9300.0 |
| 2011-02-18 07:05:00 | SPY | ETF | 134.17 | 134.18 | 134.17 | 134.18 | 2200.0 |
| 2011-02-18 07:15:00 | SPY | ETF | 134.16 | 134.16 | 134.15 | 134.15 | 27500.0 |
| 2011-02-18 07:20:00 | SPY | ETF | 134.18 | 134.18 | 134.18 | 134.18 | 5000.0 |
| 2011-02-18 07:25:00 | SPY | ETF | 134.19 | 134.19 | 134.17 | 134.18 | 7900.0 |
| 2011-02-18 07:30:00 | SPY | ETF | 134.18 | 134.2 | 134.18 | 134.2 | 8890.0 |
| 2011-02-18 07:35:00 | SPY | ETF | 134.2 | 134.2 | 134.2 | 134.2 | 9095.0 |
| 2011-02-18 07:40:00 | SPY | ETF | 134.22 | 134.24 | 134.21 | 134.21 | 157950.0 |
| 2011-02-18 07:45:00 | SPY | ETF | 134.21 | 134.22 | 134.2 | 134.22 | 32600.0 |
| 2011-02-18 07:50:00 | SPY | ETF | 134.2 | 134.2 | 134.18 | 134.18 | 7200.0 |
| 2011-02-18 07:55:00 | SPY | ETF | 134.18 | 134.2 | 134.18 | 134.19 | 6500.0 |
| 2011-02-18 08:00:00 | SPY | ETF | 134.1 | 134.2 | 134.01 | 134.18 | 56884.0 |
| 2011-02-18 08:05:00 | SPY | ETF | 134.16 | 134.18 | 133.92 | 134.16 | 31775.0 |
| 2011-02-18 08:10:00 | SPY | ETF | 134.18 | 134.4 | 133.85 | 134.4 | 53534.0 |
| 2011-02-18 08:15:00 | SPY | ETF | 134.21 | 134.23 | 134.2 | 134.22 | 58166.0 |
| 2011-02-18 08:20:00 | SPY | ETF | 134.22 | 134.25 | 134.22 | 134.23 | 8800.0 |
| 2011-02-18 08:25:00 | SPY | ETF | 134.21 | 134.22 | 134.18 | 134.2 | 10366.0 |
| 2011-02-18 08:30:00 | SPY | ETF | 134.2 | 134.21 | 134.17 | 134.18 | 33800.0 |
| 2011-02-18 08:35:00 | SPY | ETF | 134.18 | 134.2 | 134.16 | 134.19 | 122482.0 |
| 2011-02-18 08:40:00 | SPY | ETF | 134.2 | 134.24 | 134.2 | 134.24 | 121890.0 |
| 2011-02-18 08:45:00 | SPY | ETF | 134.24 | 134.29 | 134.23 | 134.28 | 57250.0 |
| 2011-02-18 08:50:00 | SPY | ETF | 134.29 | 134.3 | 134.25 | 134.27 | 108530.0 |
| 2011-02-18 08:55:00 | SPY | ETF | 134.28 | 134.28 | 134.26 | 134.26 | 24766.0 |
| 2011-02-18 09:00:00 | SPY | ETF | 134.27 | 134.36 | 134.27 | 134.34 | 34100.0 |
| 2011-02-18 09:05:00 | SPY | ETF | 134.34 | 134.35 | 134.31 | 134.32 | 51050.0 |
| 2011-02-18 09:10:00 | SPY | ETF | 134.32 | 134.33 | 134.3 | 134.31 | 18683.0 |
| 2011-02-18 09:15:00 | SPY | ETF | 134.31 | 134.33 | 134.28 | 134.32 | 46261.0 |
| 2011-02-18 09:20:00 | SPY | ETF | 134.32 | 134.33 | 134.28 | 134.29 | 60275.0 |
| 2011-02-18 09:25:00 | SPY | ETF | 134.29 | 134.38 | 134.29 | 134.37 | 648113.0 |
| 2011-02-18 09:30:00 | SPY | ETF | 134.37 | 134.37 | 134.23 | 134.24 | 3488859.0 |
| 2011-02-18 09:35:00 | SPY | ETF | 134.25 | 134.28 | 134.15 | 134.23 | 2639712.0 |
| 2011-02-18 09:40:00 | SPY | ETF | 134.24 | 134.25 | 134.15 | 134.21 | 1525749.0 |
| 2011-02-18 09:45:00 | SPY | ETF | 134.21 | 134.29 | 134.13 | 134.285 | 2246271.0 |
| 2011-02-18 09:50:00 | SPY | ETF | 134.29 | 134.33 | 134.2401 | 134.27 | 1742979.0 |
| 2011-02-18 09:55:00 | SPY | ETF | 134.28 | 134.33 | 134.23 | 134.3 | 1385393.0 |
| 2011-02-18 10:00:00 | SPY | ETF | 134.3 | 134.43 | 134.28 | 134.32 | 1857953.0 |
| 2011-02-18 10:05:00 | SPY | ETF | 134.3299 | 134.35 | 134.27 | 134.29 | 1312516.0 |
| 2011-02-18 10:10:00 | SPY | ETF | 134.28 | 134.29 | 134.2 | 134.2297 | 1468840.0 |
> showing 50 of 36,170 rows — these rows as CSV