PREVIEW / etf_5min / 2007-08-10
file: by_date/etf_5min/2007/2007-08-10.parquet size: 423 KB rows: 19,759
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-08-10 04:05:00 | SPY | ETF | 144.85 | 144.85 | 144.85 | 144.85 | 3000.0 |
| 2007-08-10 04:10:00 | SPY | ETF | 144.85 | 144.85 | 144.85 | 144.85 | 700.0 |
| 2007-08-10 04:30:00 | SPY | ETF | 145.25 | 145.25 | 145.25 | 145.25 | 2000.0 |
| 2007-08-10 04:35:00 | SPY | ETF | 145.22 | 145.22 | 145.22 | 145.22 | 300.0 |
| 2007-08-10 04:40:00 | SPY | ETF | 145.3 | 145.4 | 145.3 | 145.4 | 2300.0 |
| 2007-08-10 05:00:00 | SPY | ETF | 145.15 | 145.15 | 145.15 | 145.15 | 1000.0 |
| 2007-08-10 05:15:00 | SPY | ETF | 145.02 | 145.02 | 145.02 | 145.02 | 200.0 |
| 2007-08-10 05:50:00 | SPY | ETF | 144.71 | 144.71 | 144.71 | 144.71 | 1000.0 |
| 2007-08-10 06:00:00 | SPY | ETF | 144.51 | 144.61 | 144.51 | 144.61 | 6900.0 |
| 2007-08-10 06:05:00 | SPY | ETF | 144.5 | 144.5 | 144.5 | 144.5 | 100.0 |
| 2007-08-10 06:10:00 | SPY | ETF | 144.46 | 144.48 | 144.46 | 144.48 | 8500.0 |
| 2007-08-10 06:15:00 | SPY | ETF | 144.46 | 144.46 | 144.36 | 144.36 | 3500.0 |
| 2007-08-10 06:20:00 | SPY | ETF | 144.24 | 144.24 | 144.2 | 144.2 | 800.0 |
| 2007-08-10 06:25:00 | SPY | ETF | 144.33 | 144.5 | 144.33 | 144.5 | 2500.0 |
| 2007-08-10 06:30:00 | SPY | ETF | 144.44 | 144.44 | 144.18 | 144.18 | 35000.0 |
| 2007-08-10 06:35:00 | SPY | ETF | 144.2 | 144.2 | 144.07 | 144.1 | 12600.0 |
| 2007-08-10 06:40:00 | SPY | ETF | 144.21 | 144.21 | 144.21 | 144.21 | 25000.0 |
| 2007-08-10 06:45:00 | SPY | ETF | 144.16 | 144.16 | 144.05 | 144.05 | 30000.0 |
| 2007-08-10 06:50:00 | SPY | ETF | 144.08 | 144.08 | 144.0 | 144.0 | 7500.0 |
| 2007-08-10 06:55:00 | SPY | ETF | 144.01 | 144.08 | 144.0 | 144.08 | 88200.0 |
| 2007-08-10 07:00:00 | SPY | ETF | 144.11 | 144.13 | 143.81 | 143.81 | 182600.0 |
| 2007-08-10 07:05:00 | SPY | ETF | 143.81 | 143.81 | 143.53 | 143.6 | 130100.0 |
| 2007-08-10 07:10:00 | SPY | ETF | 143.65 | 143.76 | 143.63 | 143.65 | 700300.0 |
| 2007-08-10 07:15:00 | SPY | ETF | 143.68 | 143.75 | 143.6 | 143.65 | 382100.0 |
| 2007-08-10 07:20:00 | SPY | ETF | 143.65 | 143.67 | 143.59 | 143.59 | 303900.0 |
| 2007-08-10 07:25:00 | SPY | ETF | 143.6 | 143.65 | 143.57 | 143.62 | 292500.0 |
| 2007-08-10 07:30:00 | SPY | ETF | 143.65 | 143.9 | 143.64 | 143.9 | 308300.0 |
| 2007-08-10 07:35:00 | SPY | ETF | 143.87 | 144.01 | 143.58 | 143.59 | 308500.0 |
| 2007-08-10 07:40:00 | SPY | ETF | 143.57 | 143.62 | 143.36 | 143.36 | 392800.0 |
| 2007-08-10 07:45:00 | SPY | ETF | 143.35 | 143.45 | 143.26 | 143.28 | 360000.0 |
| 2007-08-10 07:50:00 | SPY | ETF | 143.27 | 143.37 | 143.15 | 143.15 | 697800.0 |
| 2007-08-10 07:55:00 | SPY | ETF | 143.15 | 143.19 | 142.93 | 143.0 | 565500.0 |
| 2007-08-10 08:00:00 | SPY | ETF | 143.0 | 144.87 | 142.96 | 143.31 | 1998200.0 |
| 2007-08-10 08:05:00 | SPY | ETF | 143.32 | 143.49 | 143.2 | 143.23 | 1012600.0 |
| 2007-08-10 08:10:00 | SPY | ETF | 143.28 | 143.51 | 143.28 | 143.47 | 217300.0 |
| 2007-08-10 08:15:00 | SPY | ETF | 143.49 | 143.84 | 143.27 | 143.65 | 579300.0 |
| 2007-08-10 08:20:00 | SPY | ETF | 143.63 | 143.76 | 143.5 | 143.73 | 1000800.0 |
| 2007-08-10 08:25:00 | SPY | ETF | 143.73 | 144.16 | 143.73 | 143.86 | 2435800.0 |
| 2007-08-10 08:30:00 | SPY | ETF | 143.85 | 144.35 | 143.8 | 144.15 | 1955900.0 |
| 2007-08-10 08:35:00 | SPY | ETF | 144.15 | 144.16 | 143.49 | 143.54 | 2202900.0 |
| 2007-08-10 08:40:00 | SPY | ETF | 143.57 | 143.91 | 143.57 | 143.77 | 398000.0 |
| 2007-08-10 08:45:00 | SPY | ETF | 143.79 | 143.79 | 143.58 | 143.6 | 629000.0 |
| 2007-08-10 08:50:00 | SPY | ETF | 143.62 | 145.0 | 143.57 | 143.69 | 739800.0 |
| 2007-08-10 08:55:00 | SPY | ETF | 143.71 | 144.06 | 143.65 | 143.91 | 1150300.0 |
| 2007-08-10 09:00:00 | SPY | ETF | 143.93 | 145.05 | 143.86 | 143.97 | 1123400.0 |
| 2007-08-10 09:05:00 | SPY | ETF | 143.97 | 150.2046 | 143.75 | 143.88 | 1654100.0 |
| 2007-08-10 09:10:00 | SPY | ETF | 150.2046 | 150.2046 | 143.74 | 144.06 | 531200.0 |
| 2007-08-10 09:15:00 | SPY | ETF | 144.06 | 144.49 | 144.06 | 144.34 | 2035100.0 |
| 2007-08-10 09:20:00 | SPY | ETF | 144.35 | 144.72 | 144.25 | 144.43 | 1777790.0 |
| 2007-08-10 09:25:00 | SPY | ETF | 144.45 | 144.5 | 144.05 | 144.23 | 633490.0 |
> showing 50 of 19,759 rows — these rows as CSV