PREVIEW / etf_5min / 2006-05-01
file: by_date/etf_5min/2006/2006-05-01.parquet size: 188 KB rows: 9,624
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-05-01 06:35:00 | SPY | ETF | 131.36 | 131.36 | 131.36 | 131.36 | 5000.0 |
| 2006-05-01 07:00:00 | SPY | ETF | 131.36 | 131.36 | 131.36 | 131.36 | 700.0 |
| 2006-05-01 07:20:00 | SPY | ETF | 131.37 | 131.37 | 131.37 | 131.37 | 2500.0 |
| 2006-05-01 07:25:00 | SPY | ETF | 131.39 | 131.39 | 131.39 | 131.39 | 1000.0 |
| 2006-05-01 07:35:00 | SPY | ETF | 131.37 | 131.37 | 131.37 | 131.37 | 1000.0 |
| 2006-05-01 08:00:00 | SPY | ETF | 131.38 | 131.47 | 131.36 | 131.39 | 74700.0 |
| 2006-05-01 08:05:00 | SPY | ETF | 131.39 | 131.41 | 131.38 | 131.39 | 260700.0 |
| 2006-05-01 08:10:00 | SPY | ETF | 131.41 | 131.41 | 131.38 | 131.38 | 25700.0 |
| 2006-05-01 08:15:00 | SPY | ETF | 131.37 | 131.37 | 131.35 | 131.36 | 112000.0 |
| 2006-05-01 08:20:00 | SPY | ETF | 131.39 | 131.39 | 131.35 | 131.36 | 6600.0 |
| 2006-05-01 08:25:00 | SPY | ETF | 131.36 | 131.36 | 131.31 | 131.32 | 132800.0 |
| 2006-05-01 08:30:00 | SPY | ETF | 131.33 | 131.34 | 131.29 | 131.32 | 66500.0 |
| 2006-05-01 08:35:00 | SPY | ETF | 131.34 | 131.34 | 131.28 | 131.28 | 9500.0 |
| 2006-05-01 08:40:00 | SPY | ETF | 131.3 | 131.32 | 131.27 | 131.32 | 54800.0 |
| 2006-05-01 08:45:00 | SPY | ETF | 131.32 | 131.35 | 131.31 | 131.35 | 71200.0 |
| 2006-05-01 08:50:00 | SPY | ETF | 131.35 | 131.37 | 131.35 | 131.36 | 157500.0 |
| 2006-05-01 08:55:00 | SPY | ETF | 131.36 | 131.36 | 131.35 | 131.35 | 57700.0 |
| 2006-05-01 09:00:00 | SPY | ETF | 131.36 | 131.36 | 131.33 | 131.33 | 10200.0 |
| 2006-05-01 09:05:00 | SPY | ETF | 131.33 | 131.38 | 131.32 | 131.38 | 22700.0 |
| 2006-05-01 09:10:00 | SPY | ETF | 131.37 | 131.42 | 131.37 | 131.42 | 50200.0 |
| 2006-05-01 09:15:00 | SPY | ETF | 131.42 | 131.46 | 131.4 | 131.42 | 81200.0 |
| 2006-05-01 09:20:00 | SPY | ETF | 131.42 | 131.42 | 131.4 | 131.4 | 22900.0 |
| 2006-05-01 09:25:00 | SPY | ETF | 131.41 | 131.43 | 131.38 | 131.43 | 41700.0 |
| 2006-05-01 09:30:00 | SPY | ETF | 131.47 | 131.63 | 131.45 | 131.55 | 1295000.0 |
| 2006-05-01 09:35:00 | SPY | ETF | 131.54 | 131.69 | 131.49 | 131.6701 | 1004600.0 |
| 2006-05-01 09:40:00 | SPY | ETF | 131.68 | 131.78 | 131.63 | 131.65 | 1382800.0 |
| 2006-05-01 09:45:00 | SPY | ETF | 131.641 | 131.7 | 131.56 | 131.61 | 816600.0 |
| 2006-05-01 09:50:00 | SPY | ETF | 131.6 | 131.69 | 131.59 | 131.66 | 594800.0 |
| 2006-05-01 09:55:00 | SPY | ETF | 131.65 | 131.7 | 131.56 | 131.62 | 699800.0 |
| 2006-05-01 10:00:00 | SPY | ETF | 131.61 | 131.61 | 131.41 | 131.55 | 2219500.0 |
| 2006-05-01 10:05:00 | SPY | ETF | 131.54 | 131.79 | 131.45 | 131.78 | 1609200.0 |
| 2006-05-01 10:10:00 | SPY | ETF | 131.78 | 131.8 | 131.52 | 131.53 | 1523100.0 |
| 2006-05-01 10:15:00 | SPY | ETF | 131.53 | 131.56 | 131.47 | 131.54 | 581300.0 |
| 2006-05-01 10:20:00 | SPY | ETF | 131.53 | 131.55 | 131.44 | 131.5 | 556400.0 |
| 2006-05-01 10:25:00 | SPY | ETF | 131.5 | 131.51 | 131.38 | 131.44 | 602400.0 |
| 2006-05-01 10:30:00 | SPY | ETF | 131.44 | 131.49 | 131.42 | 131.42 | 417000.0 |
| 2006-05-01 10:35:00 | SPY | ETF | 131.44 | 131.48 | 131.29 | 131.32 | 896300.0 |
| 2006-05-01 10:40:00 | SPY | ETF | 131.31 | 131.34 | 131.24 | 131.27 | 718600.0 |
| 2006-05-01 10:45:00 | SPY | ETF | 131.26 | 131.41 | 131.24 | 131.38 | 306500.0 |
| 2006-05-01 10:50:00 | SPY | ETF | 131.39 | 131.44 | 131.34 | 131.38 | 1450600.0 |
| 2006-05-01 10:55:00 | SPY | ETF | 131.38 | 131.47 | 131.36 | 131.43 | 720800.0 |
| 2006-05-01 11:00:00 | SPY | ETF | 131.4 | 131.53 | 131.39 | 131.41 | 432400.0 |
| 2006-05-01 11:05:00 | SPY | ETF | 131.42 | 131.43 | 131.27 | 131.29 | 489900.0 |
| 2006-05-01 11:10:00 | SPY | ETF | 131.27 | 131.32 | 131.22 | 131.31 | 435600.0 |
| 2006-05-01 11:15:00 | SPY | ETF | 131.3 | 131.42 | 131.3 | 131.39 | 302800.0 |
| 2006-05-01 11:20:00 | SPY | ETF | 131.36 | 131.42 | 131.32 | 131.38 | 325500.0 |
| 2006-05-01 11:25:00 | SPY | ETF | 131.38 | 131.41 | 131.31 | 131.38 | 249900.0 |
| 2006-05-01 11:30:00 | SPY | ETF | 131.37 | 131.52 | 131.29 | 131.48 | 654500.0 |
| 2006-05-01 11:35:00 | SPY | ETF | 131.48 | 131.53 | 131.44 | 131.44 | 493300.0 |
| 2006-05-01 11:40:00 | SPY | ETF | 131.43 | 131.44 | 131.32 | 131.35 | 459200.0 |
> showing 50 of 9,624 rows — these rows as CSV