PREVIEW / etf_5min / 2006-10-13
file: by_date/etf_5min/2006/2006-10-13.parquet size: 236 KB rows: 11,718
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-10-13 06:15:00 | SPY | ETF | 136.35 | 136.35 | 136.35 | 136.35 | 1000.0 |
| 2006-10-13 06:45:00 | SPY | ETF | 136.23 | 136.23 | 136.23 | 136.23 | 10000.0 |
| 2006-10-13 07:25:00 | SPY | ETF | 136.24 | 136.24 | 136.2 | 136.2 | 13900.0 |
| 2006-10-13 07:30:00 | SPY | ETF | 136.23 | 136.23 | 136.2 | 136.2 | 5000.0 |
| 2006-10-13 07:35:00 | SPY | ETF | 136.19 | 136.25 | 136.18 | 136.25 | 5000.0 |
| 2006-10-13 07:40:00 | SPY | ETF | 136.22 | 136.22 | 136.22 | 136.22 | 2000.0 |
| 2006-10-13 07:45:00 | SPY | ETF | 136.21 | 136.21 | 136.21 | 136.21 | 700.0 |
| 2006-10-13 07:55:00 | SPY | ETF | 136.24 | 136.24 | 136.2 | 136.23 | 420200.0 |
| 2006-10-13 08:00:00 | SPY | ETF | 136.22 | 136.31 | 136.18 | 136.2 | 145000.0 |
| 2006-10-13 08:05:00 | SPY | ETF | 136.2 | 136.2 | 136.2 | 136.2 | 4400.0 |
| 2006-10-13 08:10:00 | SPY | ETF | 136.19 | 136.23 | 136.19 | 136.22 | 92400.0 |
| 2006-10-13 08:15:00 | SPY | ETF | 136.22 | 136.22 | 136.2 | 136.21 | 17300.0 |
| 2006-10-13 08:20:00 | SPY | ETF | 136.21 | 136.25 | 136.21 | 136.25 | 16200.0 |
| 2006-10-13 08:25:00 | SPY | ETF | 136.24 | 136.24 | 136.2 | 136.22 | 25200.0 |
| 2006-10-13 08:30:00 | SPY | ETF | 136.2 | 136.23 | 136.1 | 136.14 | 974300.0 |
| 2006-10-13 08:35:00 | SPY | ETF | 136.14 | 136.17 | 136.14 | 136.15 | 150300.0 |
| 2006-10-13 08:40:00 | SPY | ETF | 136.14 | 136.16 | 136.11 | 136.14 | 82000.0 |
| 2006-10-13 08:45:00 | SPY | ETF | 136.13 | 136.13 | 136.08 | 136.09 | 19600.0 |
| 2006-10-13 08:50:00 | SPY | ETF | 136.11 | 136.11 | 136.09 | 136.1 | 138800.0 |
| 2006-10-13 08:55:00 | SPY | ETF | 136.1 | 136.12 | 136.1 | 136.12 | 7200.0 |
| 2006-10-13 09:00:00 | SPY | ETF | 136.13 | 136.17 | 136.13 | 136.17 | 19500.0 |
| 2006-10-13 09:05:00 | SPY | ETF | 136.16 | 136.19 | 136.15 | 136.15 | 8900.0 |
| 2006-10-13 09:10:00 | SPY | ETF | 136.17 | 136.27 | 136.17 | 136.24 | 50600.0 |
| 2006-10-13 09:15:00 | SPY | ETF | 136.25 | 136.25 | 136.22 | 136.22 | 66300.0 |
| 2006-10-13 09:20:00 | SPY | ETF | 136.25 | 136.25 | 136.2 | 136.21 | 14700.0 |
| 2006-10-13 09:25:00 | SPY | ETF | 136.22 | 136.23 | 136.15 | 136.15 | 65100.0 |
| 2006-10-13 09:30:00 | SPY | ETF | 136.16 | 136.25 | 136.11 | 136.1309 | 918500.0 |
| 2006-10-13 09:35:00 | SPY | ETF | 136.13 | 136.23 | 136.11 | 136.22 | 1436900.0 |
| 2006-10-13 09:40:00 | SPY | ETF | 136.2 | 136.32 | 136.2 | 136.28 | 890200.0 |
| 2006-10-13 09:45:00 | SPY | ETF | 136.29 | 136.33 | 136.25 | 136.3 | 712700.0 |
| 2006-10-13 09:50:00 | SPY | ETF | 136.28 | 136.3 | 136.2099 | 136.22 | 1020800.0 |
| 2006-10-13 09:55:00 | SPY | ETF | 136.21 | 136.29 | 136.14 | 136.16 | 666300.0 |
| 2006-10-13 10:00:00 | SPY | ETF | 136.16 | 136.27 | 136.05 | 136.06 | 1574900.0 |
| 2006-10-13 10:05:00 | SPY | ETF | 136.06 | 136.1 | 136.04 | 136.08 | 1283900.0 |
| 2006-10-13 10:10:00 | SPY | ETF | 136.08 | 136.14 | 136.08 | 136.13 | 517600.0 |
| 2006-10-13 10:15:00 | SPY | ETF | 136.13 | 136.23 | 136.11 | 136.17 | 1023700.0 |
| 2006-10-13 10:20:00 | SPY | ETF | 136.17 | 136.18 | 136.11 | 136.12 | 569200.0 |
| 2006-10-13 10:25:00 | SPY | ETF | 136.12 | 136.18 | 136.08 | 136.16 | 695400.0 |
| 2006-10-13 10:30:00 | SPY | ETF | 136.16 | 136.2 | 136.14 | 136.18 | 535300.0 |
| 2006-10-13 10:35:00 | SPY | ETF | 136.18 | 136.25 | 136.17 | 136.2 | 959300.0 |
| 2006-10-13 10:40:00 | SPY | ETF | 136.2 | 136.29 | 136.18 | 136.27 | 607600.0 |
| 2006-10-13 10:45:00 | SPY | ETF | 136.26 | 136.29 | 136.14 | 136.18 | 1023200.0 |
| 2006-10-13 10:50:00 | SPY | ETF | 136.18 | 136.25 | 136.17 | 136.22 | 476800.0 |
| 2006-10-13 10:55:00 | SPY | ETF | 136.23 | 136.25 | 136.17 | 136.22 | 324200.0 |
| 2006-10-13 11:00:00 | SPY | ETF | 136.21 | 136.22 | 136.15 | 136.15 | 434900.0 |
| 2006-10-13 11:05:00 | SPY | ETF | 136.15 | 136.19 | 136.12 | 136.19 | 333800.0 |
| 2006-10-13 11:10:00 | SPY | ETF | 136.18 | 136.22 | 136.14 | 136.22 | 739600.0 |
| 2006-10-13 11:15:00 | SPY | ETF | 136.21 | 136.25 | 136.19 | 136.22 | 307500.0 |
| 2006-10-13 11:20:00 | SPY | ETF | 136.23 | 136.23 | 136.12 | 136.12 | 183300.0 |
| 2006-10-13 11:25:00 | SPY | ETF | 136.14 | 136.19 | 136.08 | 136.17 | 574700.0 |
> showing 50 of 11,718 rows — these rows as CSV