PREVIEW / etf_5min / 2007-01-18
file: by_date/etf_5min/2007/2007-01-18.parquet size: 290 KB rows: 13,603
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-18 04:15:00 | SPY | ETF | 143.26 | 143.26 | 143.26 | 143.26 | 400.0 |
| 2007-01-18 05:15:00 | SPY | ETF | 143.28 | 143.28 | 143.28 | 143.28 | 10000.0 |
| 2007-01-18 05:20:00 | SPY | ETF | 143.3 | 143.3 | 143.3 | 143.3 | 5000.0 |
| 2007-01-18 06:05:00 | SPY | ETF | 143.26 | 143.26 | 143.26 | 143.26 | 10000.0 |
| 2007-01-18 07:00:00 | SPY | ETF | 143.11 | 143.11 | 143.1 | 143.1 | 1600.0 |
| 2007-01-18 07:05:00 | SPY | ETF | 143.17 | 143.17 | 143.17 | 143.17 | 3000.0 |
| 2007-01-18 07:20:00 | SPY | ETF | 143.13 | 143.13 | 143.13 | 143.13 | 1500.0 |
| 2007-01-18 07:30:00 | SPY | ETF | 143.15 | 143.15 | 143.15 | 143.15 | 108400.0 |
| 2007-01-18 07:35:00 | SPY | ETF | 143.15 | 143.15 | 143.1 | 143.1 | 91100.0 |
| 2007-01-18 07:40:00 | SPY | ETF | 143.07 | 143.07 | 143.07 | 143.07 | 50200.0 |
| 2007-01-18 07:45:00 | SPY | ETF | 143.13 | 143.13 | 143.13 | 143.13 | 2500.0 |
| 2007-01-18 07:50:00 | SPY | ETF | 143.1 | 143.1 | 143.1 | 143.1 | 2400.0 |
| 2007-01-18 08:00:00 | SPY | ETF | 143.05 | 143.16 | 143.05 | 143.05 | 417400.0 |
| 2007-01-18 08:05:00 | SPY | ETF | 143.07 | 143.07 | 143.05 | 143.05 | 11000.0 |
| 2007-01-18 08:10:00 | SPY | ETF | 143.07 | 143.11 | 143.07 | 143.11 | 400.0 |
| 2007-01-18 08:15:00 | SPY | ETF | 143.14 | 143.15 | 143.1 | 143.1 | 9800.0 |
| 2007-01-18 08:20:00 | SPY | ETF | 143.08 | 143.08 | 143.04 | 143.04 | 39400.0 |
| 2007-01-18 08:25:00 | SPY | ETF | 143.08 | 143.17 | 143.05 | 143.17 | 94500.0 |
| 2007-01-18 08:30:00 | SPY | ETF | 143.12 | 143.27 | 143.02 | 143.16 | 1115400.0 |
| 2007-01-18 08:35:00 | SPY | ETF | 143.13 | 143.2 | 143.07 | 143.2 | 99600.0 |
| 2007-01-18 08:40:00 | SPY | ETF | 143.2 | 143.28 | 143.15 | 143.17 | 1471400.0 |
| 2007-01-18 08:45:00 | SPY | ETF | 143.17 | 143.2 | 143.17 | 143.2 | 42500.0 |
| 2007-01-18 08:50:00 | SPY | ETF | 143.22 | 143.27 | 143.2 | 143.24 | 381300.0 |
| 2007-01-18 08:55:00 | SPY | ETF | 143.23 | 143.28 | 143.23 | 143.27 | 461200.0 |
| 2007-01-18 09:00:00 | SPY | ETF | 143.27 | 143.41 | 143.27 | 143.33 | 418000.0 |
| 2007-01-18 09:05:00 | SPY | ETF | 143.32 | 143.33 | 143.26 | 143.33 | 178300.0 |
| 2007-01-18 09:10:00 | SPY | ETF | 143.33 | 143.34 | 143.25 | 143.28 | 203600.0 |
| 2007-01-18 09:15:00 | SPY | ETF | 143.27 | 143.27 | 143.25 | 143.25 | 10500.0 |
| 2007-01-18 09:20:00 | SPY | ETF | 143.26 | 143.26 | 143.25 | 143.25 | 6000.0 |
| 2007-01-18 09:25:00 | SPY | ETF | 143.25 | 143.25 | 143.18 | 143.18 | 90200.0 |
| 2007-01-18 09:30:00 | SPY | ETF | 143.17 | 143.22 | 143.05 | 143.1 | 1677500.0 |
| 2007-01-18 09:35:00 | SPY | ETF | 143.11 | 143.15 | 143.02 | 143.03 | 1020700.0 |
| 2007-01-18 09:40:00 | SPY | ETF | 143.02 | 143.19 | 142.98 | 143.07 | 1489000.0 |
| 2007-01-18 09:45:00 | SPY | ETF | 143.07 | 143.18 | 143.02 | 143.06 | 1126100.0 |
| 2007-01-18 09:50:00 | SPY | ETF | 143.06 | 143.26 | 143.05 | 143.21 | 1256200.0 |
| 2007-01-18 09:55:00 | SPY | ETF | 143.22 | 143.22 | 143.06 | 143.06 | 1035400.0 |
| 2007-01-18 10:00:00 | SPY | ETF | 143.06 | 143.16 | 142.81 | 142.84 | 4979500.0 |
| 2007-01-18 10:05:00 | SPY | ETF | 142.84 | 143.08 | 142.63 | 142.76 | 3371000.0 |
| 2007-01-18 10:10:00 | SPY | ETF | 142.75 | 142.9 | 142.45 | 142.53 | 2106400.0 |
| 2007-01-18 10:15:00 | SPY | ETF | 142.54 | 142.64 | 142.45 | 142.57 | 1474700.0 |
| 2007-01-18 10:20:00 | SPY | ETF | 142.57 | 142.74 | 142.56 | 142.65 | 905100.0 |
| 2007-01-18 10:25:00 | SPY | ETF | 142.65 | 142.74 | 142.63 | 142.69 | 1750100.0 |
| 2007-01-18 10:30:00 | SPY | ETF | 142.68 | 142.74 | 142.51 | 142.54 | 829500.0 |
| 2007-01-18 10:35:00 | SPY | ETF | 142.54 | 142.75 | 142.48 | 142.7 | 1043300.0 |
| 2007-01-18 10:40:00 | SPY | ETF | 142.7 | 142.82 | 142.66 | 142.71 | 813900.0 |
| 2007-01-18 10:45:00 | SPY | ETF | 142.71 | 142.74 | 142.64 | 142.66 | 420600.0 |
| 2007-01-18 10:50:00 | SPY | ETF | 142.6501 | 142.71 | 142.53 | 142.69 | 657200.0 |
| 2007-01-18 10:55:00 | SPY | ETF | 142.69 | 142.71 | 142.59 | 142.67 | 596900.0 |
| 2007-01-18 11:00:00 | SPY | ETF | 142.68 | 142.79 | 142.65 | 142.75 | 757800.0 |
| 2007-01-18 11:05:00 | SPY | ETF | 142.74 | 142.93 | 142.72 | 142.84 | 1647500.0 |
> showing 50 of 13,603 rows — these rows as CSV