PREVIEW / etf_5min / 2006-01-10
file: by_date/etf_5min/2006/2006-01-10.parquet size: 168 KB rows: 9,378
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-01-10 07:00:00 | SPY | ETF | 128.43 | 128.44 | 128.43 | 128.44 | 35200.0 |
| 2006-01-10 07:05:00 | SPY | ETF | 128.47 | 128.47 | 128.47 | 128.47 | 16000.0 |
| 2006-01-10 07:10:00 | SPY | ETF | 128.47 | 128.47 | 128.42 | 128.42 | 3400.0 |
| 2006-01-10 07:25:00 | SPY | ETF | 128.42 | 128.42 | 128.42 | 128.42 | 3100.0 |
| 2006-01-10 07:30:00 | SPY | ETF | 128.44 | 128.44 | 128.4 | 128.4 | 4000.0 |
| 2006-01-10 07:40:00 | SPY | ETF | 128.42 | 128.42 | 128.42 | 128.42 | 100.0 |
| 2006-01-10 07:45:00 | SPY | ETF | 128.42 | 128.42 | 128.42 | 128.42 | 1200.0 |
| 2006-01-10 07:50:00 | SPY | ETF | 128.43 | 128.43 | 128.41 | 128.41 | 600.0 |
| 2006-01-10 07:55:00 | SPY | ETF | 128.41 | 128.41 | 128.41 | 128.41 | 200.0 |
| 2006-01-10 08:00:00 | SPY | ETF | 128.4 | 128.44 | 128.37 | 128.38 | 42300.0 |
| 2006-01-10 08:05:00 | SPY | ETF | 128.38 | 128.38 | 128.34 | 128.34 | 9400.0 |
| 2006-01-10 08:10:00 | SPY | ETF | 128.38 | 128.38 | 128.35 | 128.35 | 24300.0 |
| 2006-01-10 08:15:00 | SPY | ETF | 128.34 | 128.35 | 128.34 | 128.35 | 7100.0 |
| 2006-01-10 08:20:00 | SPY | ETF | 128.39 | 128.39 | 128.34 | 128.34 | 30700.0 |
| 2006-01-10 08:25:00 | SPY | ETF | 128.36 | 128.39 | 128.35 | 128.35 | 22100.0 |
| 2006-01-10 08:30:00 | SPY | ETF | 128.38 | 128.42 | 128.36 | 128.36 | 476200.0 |
| 2006-01-10 08:35:00 | SPY | ETF | 128.36 | 128.36 | 128.34 | 128.35 | 39000.0 |
| 2006-01-10 08:40:00 | SPY | ETF | 128.35 | 128.35 | 128.34 | 128.35 | 13200.0 |
| 2006-01-10 08:45:00 | SPY | ETF | 128.35 | 128.35 | 128.35 | 128.35 | 500.0 |
| 2006-01-10 08:50:00 | SPY | ETF | 128.34 | 128.35 | 128.3 | 128.33 | 28200.0 |
| 2006-01-10 08:55:00 | SPY | ETF | 128.33 | 128.34 | 128.33 | 128.34 | 156500.0 |
| 2006-01-10 09:00:00 | SPY | ETF | 128.35 | 128.35 | 128.34 | 128.34 | 2700.0 |
| 2006-01-10 09:05:00 | SPY | ETF | 128.33 | 128.34 | 128.31 | 128.31 | 76600.0 |
| 2006-01-10 09:10:00 | SPY | ETF | 128.31 | 128.31 | 128.24 | 128.28 | 221300.0 |
| 2006-01-10 09:15:00 | SPY | ETF | 128.28 | 128.39 | 128.28 | 128.39 | 57700.0 |
| 2006-01-10 09:20:00 | SPY | ETF | 128.39 | 128.41 | 128.36 | 128.39 | 171300.0 |
| 2006-01-10 09:25:00 | SPY | ETF | 128.38 | 128.41 | 128.34 | 128.4 | 147600.0 |
| 2006-01-10 09:30:00 | SPY | ETF | 128.39 | 128.48 | 128.33 | 128.4 | 1637700.0 |
| 2006-01-10 09:35:00 | SPY | ETF | 128.4 | 128.49 | 128.38 | 128.46 | 896300.0 |
| 2006-01-10 09:40:00 | SPY | ETF | 128.47 | 128.54 | 128.41 | 128.52 | 701200.0 |
| 2006-01-10 09:45:00 | SPY | ETF | 128.51 | 128.51 | 128.41 | 128.46 | 704500.0 |
| 2006-01-10 09:50:00 | SPY | ETF | 128.47 | 128.47 | 128.26 | 128.33 | 1237000.0 |
| 2006-01-10 09:55:00 | SPY | ETF | 128.31 | 128.41 | 128.3 | 128.4 | 1084300.0 |
| 2006-01-10 10:00:00 | SPY | ETF | 128.3901 | 128.58 | 128.38 | 128.52 | 1020600.0 |
| 2006-01-10 10:05:00 | SPY | ETF | 128.51 | 128.52 | 128.4 | 128.44 | 488400.0 |
| 2006-01-10 10:10:00 | SPY | ETF | 128.44 | 128.55 | 128.43 | 128.49 | 453500.0 |
| 2006-01-10 10:15:00 | SPY | ETF | 128.48 | 128.57 | 128.45 | 128.48 | 795000.0 |
| 2006-01-10 10:20:00 | SPY | ETF | 128.48 | 128.6 | 128.44 | 128.59 | 549400.0 |
| 2006-01-10 10:25:00 | SPY | ETF | 128.6 | 128.6 | 128.47 | 128.49 | 470200.0 |
| 2006-01-10 10:30:00 | SPY | ETF | 128.51 | 128.58 | 128.46 | 128.4808 | 558600.0 |
| 2006-01-10 10:35:00 | SPY | ETF | 128.48 | 128.66 | 128.48 | 128.6 | 286600.0 |
| 2006-01-10 10:40:00 | SPY | ETF | 128.61 | 128.62 | 128.52 | 128.52 | 407500.0 |
| 2006-01-10 10:45:00 | SPY | ETF | 128.52 | 128.54 | 128.46 | 128.49 | 686700.0 |
| 2006-01-10 10:50:00 | SPY | ETF | 128.48 | 128.53 | 128.44 | 128.46 | 363200.0 |
| 2006-01-10 10:55:00 | SPY | ETF | 128.46 | 128.51 | 128.44 | 128.51 | 287000.0 |
| 2006-01-10 11:00:00 | SPY | ETF | 128.48 | 128.51 | 128.37 | 128.41 | 382800.0 |
| 2006-01-10 11:05:00 | SPY | ETF | 128.42 | 128.44 | 128.31 | 128.3501 | 894000.0 |
| 2006-01-10 11:10:00 | SPY | ETF | 128.35 | 128.38 | 128.33 | 128.35 | 301300.0 |
| 2006-01-10 11:15:00 | SPY | ETF | 128.35 | 128.42 | 128.33 | 128.42 | 233100.0 |
| 2006-01-10 11:20:00 | SPY | ETF | 128.42 | 128.44 | 128.36 | 128.42 | 197900.0 |
> showing 50 of 9,378 rows — these rows as CSV