PREVIEW / etf_5min / 2005-07-05
file: by_date/etf_5min/2005/2005-07-05.parquet size: 119 KB rows: 6,418
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-05 07:00:00 | SPY | ETF | 119.24 | 119.26 | 119.24 | 119.26 | 32900.0 |
| 2005-07-05 07:05:00 | SPY | ETF | 119.26 | 119.26 | 119.26 | 119.26 | 500.0 |
| 2005-07-05 07:10:00 | SPY | ETF | 119.25 | 119.26 | 119.25 | 119.26 | 4500.0 |
| 2005-07-05 07:30:00 | SPY | ETF | 119.29 | 119.29 | 119.29 | 119.29 | 37800.0 |
| 2005-07-05 07:40:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 3300.0 |
| 2005-07-05 07:45:00 | SPY | ETF | 119.22 | 119.24 | 119.22 | 119.24 | 1100.0 |
| 2005-07-05 07:50:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 100.0 |
| 2005-07-05 08:00:00 | SPY | ETF | 119.24 | 119.24 | 119.23 | 119.23 | 2600.0 |
| 2005-07-05 08:05:00 | SPY | ETF | 119.2 | 119.2 | 119.15 | 119.16 | 76100.0 |
| 2005-07-05 08:10:00 | SPY | ETF | 119.15 | 119.16 | 119.15 | 119.16 | 66900.0 |
| 2005-07-05 08:15:00 | SPY | ETF | 119.16 | 119.19 | 119.16 | 119.16 | 16100.0 |
| 2005-07-05 08:20:00 | SPY | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 7500.0 |
| 2005-07-05 08:30:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 5000.0 |
| 2005-07-05 08:35:00 | SPY | ETF | 119.2 | 119.21 | 119.2 | 119.21 | 7000.0 |
| 2005-07-05 08:40:00 | SPY | ETF | 119.21 | 119.21 | 119.21 | 119.21 | 200.0 |
| 2005-07-05 08:45:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 10200.0 |
| 2005-07-05 08:50:00 | SPY | ETF | 119.2 | 119.2 | 119.18 | 119.18 | 1800.0 |
| 2005-07-05 08:55:00 | SPY | ETF | 119.18 | 119.2 | 119.17 | 119.2 | 12900.0 |
| 2005-07-05 09:05:00 | SPY | ETF | 119.22 | 119.22 | 119.21 | 119.21 | 5100.0 |
| 2005-07-05 09:10:00 | SPY | ETF | 119.21 | 119.21 | 119.21 | 119.21 | 5100.0 |
| 2005-07-05 09:15:00 | SPY | ETF | 119.22 | 119.22 | 119.22 | 119.22 | 1000.0 |
| 2005-07-05 09:20:00 | SPY | ETF | 119.2 | 119.21 | 119.2 | 119.21 | 1600.0 |
| 2005-07-05 09:25:00 | SPY | ETF | 119.2 | 119.24 | 119.2 | 119.24 | 3500.0 |
| 2005-07-05 09:30:00 | SPY | ETF | 119.25 | 119.32 | 119.2 | 119.23 | 1036500.0 |
| 2005-07-05 09:35:00 | SPY | ETF | 119.23 | 119.31 | 119.19 | 119.3 | 1994200.0 |
| 2005-07-05 09:40:00 | SPY | ETF | 119.3 | 119.35 | 119.21 | 119.27 | 425000.0 |
| 2005-07-05 09:45:00 | SPY | ETF | 119.28 | 119.39 | 119.25 | 119.37 | 708100.0 |
| 2005-07-05 09:50:00 | SPY | ETF | 119.37 | 119.37 | 119.27 | 119.33 | 496200.0 |
| 2005-07-05 09:55:00 | SPY | ETF | 119.34 | 119.39 | 119.31 | 119.35 | 399800.0 |
| 2005-07-05 10:00:00 | SPY | ETF | 119.36 | 119.49 | 119.29 | 119.47 | 534200.0 |
| 2005-07-05 10:05:00 | SPY | ETF | 119.47 | 119.59 | 119.42 | 119.57 | 839200.0 |
| 2005-07-05 10:10:00 | SPY | ETF | 119.57 | 119.79 | 119.56 | 119.76 | 2424600.0 |
| 2005-07-05 10:15:00 | SPY | ETF | 119.74 | 119.81 | 119.71 | 119.72 | 1101700.0 |
| 2005-07-05 10:20:00 | SPY | ETF | 119.72 | 119.78 | 119.7 | 119.73 | 1284800.0 |
| 2005-07-05 10:25:00 | SPY | ETF | 119.73 | 119.93 | 119.7 | 119.92 | 981900.0 |
| 2005-07-05 10:30:00 | SPY | ETF | 119.92 | 120.12 | 119.81 | 120.06 | 2049300.0 |
| 2005-07-05 10:35:00 | SPY | ETF | 120.07 | 120.07 | 119.99 | 120.01 | 813100.0 |
| 2005-07-05 10:40:00 | SPY | ETF | 120.01 | 120.08 | 120.0 | 120.03 | 442200.0 |
| 2005-07-05 10:45:00 | SPY | ETF | 120.03 | 120.2 | 120.03 | 120.16 | 1323300.0 |
| 2005-07-05 10:50:00 | SPY | ETF | 120.17 | 120.19 | 120.1 | 120.12 | 1432300.0 |
| 2005-07-05 10:55:00 | SPY | ETF | 120.11 | 120.22 | 120.1 | 120.18 | 364900.0 |
| 2005-07-05 11:00:00 | SPY | ETF | 120.18 | 120.28 | 120.05 | 120.15 | 644100.0 |
| 2005-07-05 11:05:00 | SPY | ETF | 120.15 | 120.19 | 120.06 | 120.06 | 375500.0 |
| 2005-07-05 11:10:00 | SPY | ETF | 120.08 | 120.25 | 120.05 | 120.13 | 291200.0 |
| 2005-07-05 11:15:00 | SPY | ETF | 120.13 | 120.14 | 120.09 | 120.11 | 285100.0 |
| 2005-07-05 11:20:00 | SPY | ETF | 120.11 | 120.14 | 120.08 | 120.12 | 195000.0 |
| 2005-07-05 11:25:00 | SPY | ETF | 120.12 | 120.23 | 120.07 | 120.2 | 522000.0 |
| 2005-07-05 11:30:00 | SPY | ETF | 120.21 | 120.27 | 120.12 | 120.15 | 267500.0 |
| 2005-07-05 11:35:00 | SPY | ETF | 120.14 | 120.16 | 120.11 | 120.12 | 147200.0 |
| 2005-07-05 11:40:00 | SPY | ETF | 120.15 | 120.15 | 120.08 | 120.08 | 206600.0 |
> showing 50 of 6,418 rows — these rows as CSV