PREVIEW / etf_5min / 2010-01-19
file: by_date/etf_5min/2010/2010-01-19.parquet size: 768 KB rows: 33,038
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-19 04:15:00 | SPY | ETF | 113.69 | 113.69 | 113.69 | 113.69 | 112.0 |
| 2010-01-19 04:25:00 | SPY | ETF | 113.67 | 113.67 | 113.67 | 113.67 | 100.0 |
| 2010-01-19 04:35:00 | SPY | ETF | 113.61 | 113.61 | 113.61 | 113.61 | 3000.0 |
| 2010-01-19 04:40:00 | SPY | ETF | 113.49 | 113.52 | 113.49 | 113.52 | 2322.0 |
| 2010-01-19 05:25:00 | SPY | ETF | 113.64 | 113.64 | 113.64 | 113.64 | 5800.0 |
| 2010-01-19 05:45:00 | SPY | ETF | 113.66 | 113.66 | 113.64 | 113.64 | 10890.0 |
| 2010-01-19 05:50:00 | SPY | ETF | 113.57 | 113.57 | 113.57 | 113.57 | 300.0 |
| 2010-01-19 05:55:00 | SPY | ETF | 113.55 | 113.55 | 113.55 | 113.55 | 300.0 |
| 2010-01-19 06:05:00 | SPY | ETF | 113.55 | 113.57 | 113.55 | 113.57 | 10000.0 |
| 2010-01-19 06:15:00 | SPY | ETF | 113.49 | 113.49 | 113.49 | 113.49 | 100.0 |
| 2010-01-19 06:20:00 | SPY | ETF | 113.49 | 113.5 | 113.49 | 113.5 | 1000.0 |
| 2010-01-19 06:30:00 | SPY | ETF | 113.5 | 113.51 | 113.5 | 113.51 | 7500.0 |
| 2010-01-19 06:45:00 | SPY | ETF | 113.42 | 113.42 | 113.36 | 113.36 | 4100.0 |
| 2010-01-19 06:50:00 | SPY | ETF | 113.35 | 113.36 | 113.35 | 113.36 | 1125.0 |
| 2010-01-19 07:00:00 | SPY | ETF | 113.54 | 113.54 | 113.49 | 113.49 | 1200.0 |
| 2010-01-19 07:05:00 | SPY | ETF | 113.49 | 113.49 | 113.48 | 113.48 | 1300.0 |
| 2010-01-19 07:10:00 | SPY | ETF | 113.49 | 113.49 | 113.49 | 113.49 | 1000.0 |
| 2010-01-19 07:15:00 | SPY | ETF | 113.52 | 113.52 | 113.51 | 113.51 | 25500.0 |
| 2010-01-19 07:20:00 | SPY | ETF | 113.48 | 113.48 | 113.42 | 113.44 | 12500.0 |
| 2010-01-19 07:25:00 | SPY | ETF | 113.45 | 113.5 | 113.37 | 113.39 | 33700.0 |
| 2010-01-19 07:30:00 | SPY | ETF | 113.42 | 113.42 | 113.39 | 113.42 | 5100.0 |
| 2010-01-19 07:35:00 | SPY | ETF | 113.41 | 113.46 | 113.4 | 113.46 | 65600.0 |
| 2010-01-19 07:40:00 | SPY | ETF | 113.46 | 113.46 | 113.4 | 113.42 | 32100.0 |
| 2010-01-19 07:45:00 | SPY | ETF | 113.42 | 113.43 | 113.37 | 113.37 | 187851.0 |
| 2010-01-19 07:50:00 | SPY | ETF | 113.38 | 113.41 | 113.38 | 113.38 | 7966.0 |
| 2010-01-19 07:55:00 | SPY | ETF | 113.38 | 113.38 | 113.36 | 113.38 | 37000.0 |
| 2010-01-19 08:00:00 | SPY | ETF | 113.38 | 113.68 | 113.08 | 113.19 | 1835394.0 |
| 2010-01-19 08:05:00 | SPY | ETF | 113.19 | 113.34 | 113.17 | 113.29 | 600860.0 |
| 2010-01-19 08:10:00 | SPY | ETF | 113.3 | 113.31 | 113.28 | 113.3 | 65068.0 |
| 2010-01-19 08:15:00 | SPY | ETF | 113.29 | 113.31 | 113.21 | 113.3 | 248710.0 |
| 2010-01-19 08:20:00 | SPY | ETF | 113.3 | 113.57 | 113.29 | 113.52 | 407782.0 |
| 2010-01-19 08:25:00 | SPY | ETF | 113.52 | 113.6 | 113.48 | 113.54 | 835817.0 |
| 2010-01-19 08:30:00 | SPY | ETF | 113.53 | 113.7 | 113.53 | 113.59 | 244559.0 |
| 2010-01-19 08:35:00 | SPY | ETF | 113.61 | 113.72 | 113.61 | 113.71 | 259172.0 |
| 2010-01-19 08:40:00 | SPY | ETF | 113.71 | 113.72 | 113.6 | 113.61 | 233673.0 |
| 2010-01-19 08:45:00 | SPY | ETF | 113.61 | 113.66 | 113.55 | 113.58 | 683508.0 |
| 2010-01-19 08:50:00 | SPY | ETF | 113.57 | 113.62 | 113.56 | 113.59 | 108110.0 |
| 2010-01-19 08:55:00 | SPY | ETF | 113.58 | 113.59 | 113.52 | 113.52 | 150286.0 |
| 2010-01-19 09:00:00 | SPY | ETF | 113.52 | 113.54 | 113.52 | 113.54 | 56677.0 |
| 2010-01-19 09:05:00 | SPY | ETF | 113.54 | 113.57 | 113.5 | 113.57 | 213366.0 |
| 2010-01-19 09:10:00 | SPY | ETF | 113.57 | 113.63 | 113.57 | 113.61 | 85658.0 |
| 2010-01-19 09:15:00 | SPY | ETF | 113.61 | 113.61 | 113.53 | 113.53 | 84077.0 |
| 2010-01-19 09:20:00 | SPY | ETF | 113.52 | 113.64 | 113.5 | 113.56 | 418755.0 |
| 2010-01-19 09:25:00 | SPY | ETF | 113.57 | 113.6 | 113.54 | 113.6 | 250728.0 |
| 2010-01-19 09:30:00 | SPY | ETF | 113.62 | 113.86 | 113.59 | 113.79 | 3901000.0 |
| 2010-01-19 09:35:00 | SPY | ETF | 113.79 | 113.9 | 113.78 | 113.83 | 3157877.0 |
| 2010-01-19 09:40:00 | SPY | ETF | 113.84 | 114.09 | 113.82 | 114.01 | 4866281.0 |
| 2010-01-19 09:45:00 | SPY | ETF | 114.02 | 114.23 | 114.01 | 114.19 | 4809553.0 |
| 2010-01-19 09:50:00 | SPY | ETF | 114.1883 | 114.32 | 114.15 | 114.21 | 4120885.0 |
| 2010-01-19 09:55:00 | SPY | ETF | 114.21 | 114.33 | 114.15 | 114.2 | 2904043.0 |
> showing 50 of 33,038 rows — these rows as CSV