PREVIEW / etf_5min / 2006-02-03
file: by_date/etf_5min/2006/2006-02-03.parquet size: 181 KB rows: 9,154
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-03 06:35:00 | SPY | ETF | 127.17 | 127.17 | 127.17 | 127.17 | 4800.0 |
| 2006-02-03 06:45:00 | SPY | ETF | 127.16 | 127.16 | 127.16 | 127.16 | 2400.0 |
| 2006-02-03 07:00:00 | SPY | ETF | 127.18 | 127.18 | 127.18 | 127.18 | 100.0 |
| 2006-02-03 07:05:00 | SPY | ETF | 127.17 | 127.17 | 127.17 | 127.17 | 100.0 |
| 2006-02-03 07:15:00 | SPY | ETF | 127.19 | 127.21 | 127.19 | 127.21 | 4300.0 |
| 2006-02-03 07:25:00 | SPY | ETF | 127.14 | 127.14 | 127.07 | 127.07 | 14100.0 |
| 2006-02-03 07:35:00 | SPY | ETF | 127.1 | 127.1 | 127.1 | 127.1 | 1500.0 |
| 2006-02-03 07:45:00 | SPY | ETF | 127.13 | 127.13 | 127.13 | 127.13 | 500.0 |
| 2006-02-03 07:50:00 | SPY | ETF | 127.17 | 127.17 | 127.17 | 127.17 | 800.0 |
| 2006-02-03 07:55:00 | SPY | ETF | 127.15 | 127.18 | 127.15 | 127.18 | 75800.0 |
| 2006-02-03 08:00:00 | SPY | ETF | 127.2 | 127.27 | 127.14 | 127.25 | 1218000.0 |
| 2006-02-03 08:05:00 | SPY | ETF | 127.26 | 127.26 | 127.0 | 127.0 | 241500.0 |
| 2006-02-03 08:10:00 | SPY | ETF | 127.16 | 127.23 | 127.16 | 127.23 | 12300.0 |
| 2006-02-03 08:15:00 | SPY | ETF | 127.22 | 127.22 | 127.18 | 127.2 | 431000.0 |
| 2006-02-03 08:20:00 | SPY | ETF | 127.2 | 127.24 | 127.19 | 127.2 | 55700.0 |
| 2006-02-03 08:25:00 | SPY | ETF | 127.2 | 127.29 | 127.19 | 127.26 | 281400.0 |
| 2006-02-03 08:30:00 | SPY | ETF | 127.22 | 127.39 | 127.04 | 127.05 | 1150900.0 |
| 2006-02-03 08:35:00 | SPY | ETF | 127.04 | 127.29 | 126.76 | 126.94 | 1030800.0 |
| 2006-02-03 08:40:00 | SPY | ETF | 126.95 | 127.31 | 126.93 | 126.98 | 1555300.0 |
| 2006-02-03 08:45:00 | SPY | ETF | 126.98 | 127.0 | 126.84 | 126.85 | 581600.0 |
| 2006-02-03 08:50:00 | SPY | ETF | 126.84 | 126.98 | 126.84 | 126.88 | 137000.0 |
| 2006-02-03 08:55:00 | SPY | ETF | 126.88 | 126.88 | 126.63 | 126.66 | 416200.0 |
| 2006-02-03 09:00:00 | SPY | ETF | 126.69 | 126.77 | 126.51 | 126.56 | 660600.0 |
| 2006-02-03 09:05:00 | SPY | ETF | 126.56 | 126.64 | 126.53 | 126.59 | 475400.0 |
| 2006-02-03 09:10:00 | SPY | ETF | 126.58 | 126.6 | 126.55 | 126.56 | 333400.0 |
| 2006-02-03 09:15:00 | SPY | ETF | 126.56 | 126.56 | 126.49 | 126.51 | 109900.0 |
| 2006-02-03 09:20:00 | SPY | ETF | 126.51 | 126.56 | 126.51 | 126.53 | 119800.0 |
| 2006-02-03 09:25:00 | SPY | ETF | 126.52 | 126.63 | 126.52 | 126.62 | 459000.0 |
| 2006-02-03 09:30:00 | SPY | ETF | 126.58 | 126.63 | 126.43 | 126.48 | 1546500.0 |
| 2006-02-03 09:35:00 | SPY | ETF | 126.48 | 126.55 | 126.45 | 126.54 | 975400.0 |
| 2006-02-03 09:40:00 | SPY | ETF | 126.54 | 126.66 | 126.49 | 126.61 | 1415600.0 |
| 2006-02-03 09:45:00 | SPY | ETF | 126.61 | 126.65 | 126.52 | 126.59 | 1503400.0 |
| 2006-02-03 09:50:00 | SPY | ETF | 126.59 | 126.62 | 126.36 | 126.38 | 1727500.0 |
| 2006-02-03 09:55:00 | SPY | ETF | 126.36 | 126.48 | 126.2 | 126.25 | 4173400.0 |
| 2006-02-03 10:00:00 | SPY | ETF | 126.25 | 126.4 | 126.14 | 126.36 | 2113000.0 |
| 2006-02-03 10:05:00 | SPY | ETF | 126.36 | 126.49 | 126.3 | 126.31 | 3935000.0 |
| 2006-02-03 10:10:00 | SPY | ETF | 126.3 | 126.45 | 126.26 | 126.27 | 617700.0 |
| 2006-02-03 10:15:00 | SPY | ETF | 126.28 | 126.44 | 126.25 | 126.38 | 724300.0 |
| 2006-02-03 10:20:00 | SPY | ETF | 126.37 | 126.4 | 126.23 | 126.34 | 680900.0 |
| 2006-02-03 10:25:00 | SPY | ETF | 126.35 | 126.43 | 126.33 | 126.37 | 590700.0 |
| 2006-02-03 10:30:00 | SPY | ETF | 126.37 | 126.42 | 126.22 | 126.25 | 329300.0 |
| 2006-02-03 10:35:00 | SPY | ETF | 126.25 | 126.31 | 126.16 | 126.29 | 2708700.0 |
| 2006-02-03 10:40:00 | SPY | ETF | 126.3 | 126.32 | 126.23 | 126.27 | 590800.0 |
| 2006-02-03 10:45:00 | SPY | ETF | 126.26 | 126.53 | 126.22 | 126.42 | 1163500.0 |
| 2006-02-03 10:50:00 | SPY | ETF | 126.42 | 126.63 | 126.38 | 126.6 | 2652100.0 |
| 2006-02-03 10:55:00 | SPY | ETF | 126.59 | 126.67 | 126.54 | 126.63 | 1599100.0 |
| 2006-02-03 11:00:00 | SPY | ETF | 126.62 | 126.7 | 126.56 | 126.57 | 1096000.0 |
| 2006-02-03 11:05:00 | SPY | ETF | 126.57 | 126.59 | 126.48 | 126.5799 | 640100.0 |
| 2006-02-03 11:10:00 | SPY | ETF | 126.57 | 126.62 | 126.49 | 126.51 | 201100.0 |
| 2006-02-03 11:15:00 | SPY | ETF | 126.51 | 126.51 | 126.38 | 126.42 | 466600.0 |
> showing 50 of 9,154 rows — these rows as CSV