PREVIEW / etf_5min / 2007-07-06
file: by_date/etf_5min/2007/2007-07-06.parquet size: 302 KB rows: 16,299
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-07-06 06:35:00 | SPY | ETF | 152.46 | 152.46 | 152.46 | 152.46 | 17500.0 |
| 2007-07-06 06:40:00 | SPY | ETF | 152.49 | 152.49 | 152.49 | 152.49 | 2000.0 |
| 2007-07-06 07:10:00 | SPY | ETF | 152.4 | 152.4 | 152.4 | 152.4 | 100.0 |
| 2007-07-06 07:20:00 | SPY | ETF | 152.43 | 152.46 | 152.43 | 152.46 | 1500.0 |
| 2007-07-06 07:25:00 | SPY | ETF | 152.46 | 152.49 | 152.46 | 152.49 | 8700.0 |
| 2007-07-06 07:30:00 | SPY | ETF | 152.49 | 152.49 | 152.42 | 152.42 | 600.0 |
| 2007-07-06 07:35:00 | SPY | ETF | 152.44 | 152.44 | 152.39 | 152.39 | 18900.0 |
| 2007-07-06 07:40:00 | SPY | ETF | 152.41 | 152.41 | 152.33 | 152.33 | 24600.0 |
| 2007-07-06 07:50:00 | SPY | ETF | 152.34 | 152.35 | 152.34 | 152.34 | 25100.0 |
| 2007-07-06 07:55:00 | SPY | ETF | 152.34 | 152.39 | 152.34 | 152.34 | 35500.0 |
| 2007-07-06 08:00:00 | SPY | ETF | 152.39 | 152.42 | 152.39 | 152.42 | 12300.0 |
| 2007-07-06 08:05:00 | SPY | ETF | 152.41 | 152.5 | 152.41 | 152.46 | 18000.0 |
| 2007-07-06 08:10:00 | SPY | ETF | 152.49 | 152.49 | 152.37 | 152.43 | 69000.0 |
| 2007-07-06 08:15:00 | SPY | ETF | 152.44 | 152.48 | 152.4 | 152.4 | 67600.0 |
| 2007-07-06 08:20:00 | SPY | ETF | 152.39 | 152.41 | 152.36 | 152.38 | 146200.0 |
| 2007-07-06 08:25:00 | SPY | ETF | 152.39 | 152.47 | 152.39 | 152.47 | 63600.0 |
| 2007-07-06 08:30:00 | SPY | ETF | 152.49 | 152.67 | 152.03 | 152.12 | 1885700.0 |
| 2007-07-06 08:35:00 | SPY | ETF | 152.15 | 152.31 | 152.04 | 152.23 | 754000.0 |
| 2007-07-06 08:40:00 | SPY | ETF | 152.23 | 152.26 | 152.11 | 152.19 | 748400.0 |
| 2007-07-06 08:45:00 | SPY | ETF | 152.19 | 152.24 | 152.16 | 152.23 | 426300.0 |
| 2007-07-06 08:50:00 | SPY | ETF | 152.22 | 152.22 | 152.12 | 152.13 | 85100.0 |
| 2007-07-06 08:55:00 | SPY | ETF | 152.16 | 152.3 | 152.16 | 152.18 | 307600.0 |
| 2007-07-06 09:00:00 | SPY | ETF | 152.24 | 152.3 | 152.17 | 152.27 | 395400.0 |
| 2007-07-06 09:05:00 | SPY | ETF | 152.28 | 152.32 | 152.26 | 152.3 | 35300.0 |
| 2007-07-06 09:10:00 | SPY | ETF | 152.31 | 152.4 | 152.3 | 152.39 | 118500.0 |
| 2007-07-06 09:15:00 | SPY | ETF | 152.39 | 152.42 | 152.33 | 152.4 | 92200.0 |
| 2007-07-06 09:20:00 | SPY | ETF | 152.4 | 152.43 | 152.36 | 152.4 | 204600.0 |
| 2007-07-06 09:25:00 | SPY | ETF | 152.37 | 152.41 | 152.37 | 152.38 | 57500.0 |
| 2007-07-06 09:30:00 | SPY | ETF | 152.38 | 152.44 | 152.24 | 152.24 | 2455561.0 |
| 2007-07-06 09:35:00 | SPY | ETF | 152.23 | 152.27 | 152.14 | 152.18 | 1504409.0 |
| 2007-07-06 09:40:00 | SPY | ETF | 152.17 | 152.23 | 152.1 | 152.15 | 964798.0 |
| 2007-07-06 09:45:00 | SPY | ETF | 152.14 | 152.15 | 151.96 | 152.09 | 2580000.0 |
| 2007-07-06 09:50:00 | SPY | ETF | 152.095 | 152.13 | 151.97 | 152.03 | 2547736.0 |
| 2007-07-06 09:55:00 | SPY | ETF | 152.02 | 152.14 | 151.93 | 152.08 | 1640700.0 |
| 2007-07-06 10:00:00 | SPY | ETF | 152.08 | 152.315 | 152.07 | 152.22 | 1163657.0 |
| 2007-07-06 10:05:00 | SPY | ETF | 152.22 | 152.42 | 152.22 | 152.335 | 1110600.0 |
| 2007-07-06 10:10:00 | SPY | ETF | 152.35 | 152.36 | 152.29 | 152.32 | 764500.0 |
| 2007-07-06 10:15:00 | SPY | ETF | 152.33 | 152.52 | 152.31 | 152.45 | 931400.0 |
| 2007-07-06 10:20:00 | SPY | ETF | 152.45 | 152.48 | 152.32 | 152.44 | 883000.0 |
| 2007-07-06 10:25:00 | SPY | ETF | 152.42 | 152.57 | 152.4 | 152.57 | 979700.0 |
| 2007-07-06 10:30:00 | SPY | ETF | 152.57 | 152.62 | 152.48 | 152.525 | 1975908.0 |
| 2007-07-06 10:35:00 | SPY | ETF | 152.52 | 152.53 | 152.38 | 152.43 | 1259280.0 |
| 2007-07-06 10:40:00 | SPY | ETF | 152.43 | 152.45 | 152.32 | 152.44 | 2329514.0 |
| 2007-07-06 10:45:00 | SPY | ETF | 152.44 | 152.55 | 152.44 | 152.495 | 570100.0 |
| 2007-07-06 10:50:00 | SPY | ETF | 152.5 | 152.55 | 152.5 | 152.54 | 498000.0 |
| 2007-07-06 10:55:00 | SPY | ETF | 152.54 | 152.55 | 152.35 | 152.39 | 2191028.0 |
| 2007-07-06 11:00:00 | SPY | ETF | 152.4 | 152.53 | 152.35 | 152.52 | 752100.0 |
| 2007-07-06 11:05:00 | SPY | ETF | 152.52 | 152.66 | 152.51 | 152.605 | 1032800.0 |
| 2007-07-06 11:10:00 | SPY | ETF | 152.61 | 152.72 | 152.59 | 152.6 | 604600.0 |
| 2007-07-06 11:15:00 | SPY | ETF | 152.6 | 152.67 | 152.58 | 152.62 | 568300.0 |
> showing 50 of 16,299 rows — these rows as CSV