PREVIEW / etf_5min / 2010-01-06
file: by_date/etf_5min/2010/2010-01-06.parquet size: 710 KB rows: 32,660
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-06 04:15:00 | SPY | ETF | 113.32 | 113.36 | 113.32 | 113.36 | 650.0 |
| 2010-01-06 04:20:00 | SPY | ETF | 113.37 | 113.37 | 113.37 | 113.37 | 250.0 |
| 2010-01-06 04:55:00 | SPY | ETF | 113.31 | 113.31 | 113.31 | 113.31 | 118.0 |
| 2010-01-06 05:45:00 | SPY | ETF | 113.28 | 113.28 | 113.28 | 113.28 | 2500.0 |
| 2010-01-06 05:55:00 | SPY | ETF | 113.37 | 113.44 | 113.37 | 113.44 | 15118.0 |
| 2010-01-06 06:15:00 | SPY | ETF | 113.49 | 113.49 | 113.44 | 113.44 | 10100.0 |
| 2010-01-06 06:20:00 | SPY | ETF | 113.35 | 113.35 | 113.35 | 113.35 | 5500.0 |
| 2010-01-06 06:25:00 | SPY | ETF | 113.35 | 113.35 | 113.35 | 113.35 | 4500.0 |
| 2010-01-06 06:40:00 | SPY | ETF | 113.34 | 113.34 | 113.34 | 113.34 | 100.0 |
| 2010-01-06 06:50:00 | SPY | ETF | 113.36 | 113.36 | 113.36 | 113.36 | 200.0 |
| 2010-01-06 07:00:00 | SPY | ETF | 113.39 | 113.39 | 113.38 | 113.39 | 1600.0 |
| 2010-01-06 07:05:00 | SPY | ETF | 113.37 | 113.37 | 113.33 | 113.33 | 6400.0 |
| 2010-01-06 07:10:00 | SPY | ETF | 113.33 | 113.33 | 113.3 | 113.3 | 3933.0 |
| 2010-01-06 07:15:00 | SPY | ETF | 113.32 | 113.32 | 113.26 | 113.26 | 11532.0 |
| 2010-01-06 07:20:00 | SPY | ETF | 113.29 | 113.29 | 113.22 | 113.22 | 36078.0 |
| 2010-01-06 07:25:00 | SPY | ETF | 113.21 | 113.25 | 113.19 | 113.24 | 36240.0 |
| 2010-01-06 07:30:00 | SPY | ETF | 113.24 | 113.3 | 113.23 | 113.3 | 6700.0 |
| 2010-01-06 07:35:00 | SPY | ETF | 113.27 | 113.27 | 113.27 | 113.27 | 500.0 |
| 2010-01-06 07:40:00 | SPY | ETF | 113.27 | 113.29 | 113.27 | 113.29 | 500.0 |
| 2010-01-06 07:45:00 | SPY | ETF | 113.32 | 113.35 | 113.3 | 113.34 | 6500.0 |
| 2010-01-06 07:50:00 | SPY | ETF | 113.35 | 113.37 | 113.35 | 113.37 | 119000.0 |
| 2010-01-06 07:55:00 | SPY | ETF | 113.39 | 113.39 | 113.35 | 113.35 | 5700.0 |
| 2010-01-06 08:00:00 | SPY | ETF | 113.37 | 113.39 | 113.35 | 113.37 | 513805.0 |
| 2010-01-06 08:05:00 | SPY | ETF | 113.37 | 113.4 | 113.36 | 113.4 | 27406.0 |
| 2010-01-06 08:10:00 | SPY | ETF | 113.39 | 113.41 | 113.37 | 113.41 | 728680.0 |
| 2010-01-06 08:15:00 | SPY | ETF | 113.39 | 113.41 | 113.22 | 113.35 | 548596.0 |
| 2010-01-06 08:20:00 | SPY | ETF | 113.36 | 113.39 | 113.27 | 113.38 | 255004.0 |
| 2010-01-06 08:25:00 | SPY | ETF | 113.38 | 113.45 | 113.37 | 113.45 | 330684.0 |
| 2010-01-06 08:30:00 | SPY | ETF | 113.45 | 113.51 | 113.44 | 113.5 | 358017.0 |
| 2010-01-06 08:35:00 | SPY | ETF | 113.5 | 113.5 | 113.47 | 113.47 | 80941.0 |
| 2010-01-06 08:40:00 | SPY | ETF | 113.48 | 113.58 | 113.48 | 113.55 | 236259.0 |
| 2010-01-06 08:45:00 | SPY | ETF | 113.56 | 113.59 | 113.55 | 113.59 | 79904.0 |
| 2010-01-06 08:50:00 | SPY | ETF | 113.59 | 113.6 | 113.57 | 113.57 | 98766.0 |
| 2010-01-06 08:55:00 | SPY | ETF | 113.57 | 113.59 | 113.56 | 113.57 | 26080.0 |
| 2010-01-06 09:00:00 | SPY | ETF | 113.56 | 113.56 | 113.53 | 113.54 | 50373.0 |
| 2010-01-06 09:05:00 | SPY | ETF | 113.54 | 113.57 | 113.53 | 113.55 | 83437.0 |
| 2010-01-06 09:10:00 | SPY | ETF | 113.55 | 113.55 | 113.45 | 113.46 | 213859.0 |
| 2010-01-06 09:15:00 | SPY | ETF | 113.47 | 113.5 | 113.47 | 113.49 | 75873.0 |
| 2010-01-06 09:20:00 | SPY | ETF | 113.49 | 113.5 | 113.47 | 113.47 | 30485.0 |
| 2010-01-06 09:25:00 | SPY | ETF | 113.48 | 113.51 | 113.46 | 113.5 | 92482.0 |
| 2010-01-06 09:30:00 | SPY | ETF | 113.52 | 113.62 | 113.49 | 113.57 | 2612306.0 |
| 2010-01-06 09:35:00 | SPY | ETF | 113.57 | 113.7 | 113.57 | 113.58 | 1954496.0 |
| 2010-01-06 09:40:00 | SPY | ETF | 113.58 | 113.64 | 113.45 | 113.45 | 2993712.0 |
| 2010-01-06 09:45:00 | SPY | ETF | 113.4599 | 113.54 | 113.43 | 113.52 | 1199330.0 |
| 2010-01-06 09:50:00 | SPY | ETF | 113.52 | 113.63 | 113.43 | 113.574 | 2788836.0 |
| 2010-01-06 09:55:00 | SPY | ETF | 113.58 | 113.6 | 113.51 | 113.57 | 1664191.0 |
| 2010-01-06 10:00:00 | SPY | ETF | 113.56 | 113.74 | 113.51 | 113.74 | 2737918.0 |
| 2010-01-06 10:05:00 | SPY | ETF | 113.73 | 113.75 | 113.62 | 113.75 | 2447702.0 |
| 2010-01-06 10:10:00 | SPY | ETF | 113.75 | 113.79 | 113.66 | 113.7 | 1722490.0 |
| 2010-01-06 10:15:00 | SPY | ETF | 113.7 | 113.8 | 113.69 | 113.7525 | 1706936.0 |
> showing 50 of 32,660 rows — these rows as CSV