PREVIEW / etf_5min / 2010-01-26
file: by_date/etf_5min/2010/2010-01-26.parquet size: 797 KB rows: 33,095
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-26 04:05:00 | SPY | ETF | 109.09 | 109.09 | 109.09 | 109.09 | 100.0 |
| 2010-01-26 04:10:00 | SPY | ETF | 109.09 | 109.09 | 109.09 | 109.09 | 1000.0 |
| 2010-01-26 04:15:00 | SPY | ETF | 109.13 | 109.14 | 109.11 | 109.11 | 3736.0 |
| 2010-01-26 04:20:00 | SPY | ETF | 109.27 | 109.27 | 109.27 | 109.27 | 200.0 |
| 2010-01-26 04:25:00 | SPY | ETF | 109.26 | 109.26 | 109.24 | 109.24 | 200.0 |
| 2010-01-26 04:30:00 | SPY | ETF | 109.11 | 109.22 | 109.11 | 109.22 | 400.0 |
| 2010-01-26 04:45:00 | SPY | ETF | 109.09 | 109.09 | 109.09 | 109.09 | 1500.0 |
| 2010-01-26 04:50:00 | SPY | ETF | 109.03 | 109.07 | 109.0 | 109.07 | 1400.0 |
| 2010-01-26 05:05:00 | SPY | ETF | 108.94 | 108.94 | 108.94 | 108.94 | 200.0 |
| 2010-01-26 05:10:00 | SPY | ETF | 108.84 | 108.84 | 108.83 | 108.83 | 523.0 |
| 2010-01-26 05:15:00 | SPY | ETF | 108.9 | 108.9 | 108.86 | 108.86 | 5100.0 |
| 2010-01-26 05:20:00 | SPY | ETF | 108.86 | 108.86 | 108.86 | 108.86 | 1200.0 |
| 2010-01-26 05:25:00 | SPY | ETF | 108.91 | 108.91 | 108.89 | 108.89 | 2000.0 |
| 2010-01-26 05:30:00 | SPY | ETF | 108.86 | 108.86 | 108.86 | 108.86 | 1000.0 |
| 2010-01-26 05:40:00 | SPY | ETF | 108.93 | 108.99 | 108.93 | 108.99 | 650.0 |
| 2010-01-26 05:45:00 | SPY | ETF | 109.0 | 109.02 | 109.0 | 109.02 | 400.0 |
| 2010-01-26 05:50:00 | SPY | ETF | 109.0 | 109.0 | 109.0 | 109.0 | 100.0 |
| 2010-01-26 05:55:00 | SPY | ETF | 109.04 | 109.08 | 109.04 | 109.08 | 400.0 |
| 2010-01-26 06:05:00 | SPY | ETF | 109.07 | 109.07 | 109.07 | 109.07 | 100.0 |
| 2010-01-26 06:20:00 | SPY | ETF | 109.08 | 109.08 | 109.08 | 109.08 | 100.0 |
| 2010-01-26 06:25:00 | SPY | ETF | 109.07 | 109.07 | 109.07 | 109.07 | 500.0 |
| 2010-01-26 06:30:00 | SPY | ETF | 109.0 | 109.08 | 109.0 | 109.07 | 15100.0 |
| 2010-01-26 06:35:00 | SPY | ETF | 109.06 | 109.06 | 109.05 | 109.05 | 400.0 |
| 2010-01-26 06:40:00 | SPY | ETF | 109.07 | 109.12 | 109.07 | 109.12 | 8064.0 |
| 2010-01-26 06:45:00 | SPY | ETF | 109.12 | 109.12 | 109.12 | 109.12 | 1500.0 |
| 2010-01-26 06:50:00 | SPY | ETF | 109.17 | 109.17 | 109.09 | 109.1 | 30210.0 |
| 2010-01-26 06:55:00 | SPY | ETF | 109.15 | 109.16 | 109.11 | 109.11 | 5365.0 |
| 2010-01-26 07:00:00 | SPY | ETF | 109.11 | 109.14 | 109.1 | 109.11 | 63549.0 |
| 2010-01-26 07:05:00 | SPY | ETF | 109.09 | 109.16 | 109.05 | 109.13 | 68506.0 |
| 2010-01-26 07:10:00 | SPY | ETF | 109.05 | 109.14 | 109.05 | 109.1 | 28158.0 |
| 2010-01-26 07:15:00 | SPY | ETF | 109.12 | 109.19 | 109.12 | 109.15 | 4350.0 |
| 2010-01-26 07:20:00 | SPY | ETF | 109.11 | 109.2 | 109.07 | 109.2 | 10402.0 |
| 2010-01-26 07:25:00 | SPY | ETF | 109.16 | 109.2 | 109.15 | 109.2 | 6400.0 |
| 2010-01-26 07:30:00 | SPY | ETF | 109.2 | 109.41 | 109.2 | 109.37 | 78200.0 |
| 2010-01-26 07:35:00 | SPY | ETF | 109.41 | 109.41 | 109.32 | 109.41 | 106336.0 |
| 2010-01-26 07:40:00 | SPY | ETF | 109.39 | 109.46 | 109.39 | 109.41 | 64925.0 |
| 2010-01-26 07:45:00 | SPY | ETF | 109.41 | 109.48 | 109.4 | 109.42 | 83600.0 |
| 2010-01-26 07:50:00 | SPY | ETF | 109.43 | 109.51 | 109.38 | 109.46 | 182491.0 |
| 2010-01-26 07:55:00 | SPY | ETF | 109.46 | 109.47 | 109.38 | 109.47 | 67899.0 |
| 2010-01-26 08:00:00 | SPY | ETF | 109.45 | 109.56 | 109.42 | 109.55 | 104940.0 |
| 2010-01-26 08:05:00 | SPY | ETF | 109.55 | 109.64 | 109.51 | 109.58 | 263797.0 |
| 2010-01-26 08:10:00 | SPY | ETF | 109.58 | 109.62 | 109.57 | 109.57 | 82776.0 |
| 2010-01-26 08:15:00 | SPY | ETF | 109.57 | 109.61 | 109.48 | 109.5 | 266576.0 |
| 2010-01-26 08:20:00 | SPY | ETF | 109.51 | 109.52 | 109.32 | 109.36 | 420938.0 |
| 2010-01-26 08:25:00 | SPY | ETF | 109.36 | 109.4 | 109.31 | 109.33 | 191724.0 |
| 2010-01-26 08:30:00 | SPY | ETF | 109.32 | 109.37 | 109.3 | 109.37 | 134176.0 |
| 2010-01-26 08:35:00 | SPY | ETF | 109.38 | 109.48 | 108.7 | 109.45 | 262090.0 |
| 2010-01-26 08:40:00 | SPY | ETF | 109.46 | 109.47 | 109.4 | 109.41 | 85090.0 |
| 2010-01-26 08:45:00 | SPY | ETF | 109.41 | 109.42 | 109.38 | 109.41 | 31611.0 |
| 2010-01-26 08:50:00 | SPY | ETF | 109.41 | 109.41 | 109.36 | 109.37 | 48379.0 |
> showing 50 of 33,095 rows — these rows as CSV