PREVIEW / etf_5min / 2010-10-18
file: by_date/etf_5min/2010/2010-10-18.parquet size: 812 KB rows: 34,861
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-10-18 04:00:00 | SPY | ETF | 117.55 | 117.55 | 117.08 | 117.08 | 3400.0 |
| 2010-10-18 04:05:00 | SPY | ETF | 117.08 | 117.08 | 116.97 | 116.97 | 15320.0 |
| 2010-10-18 04:10:00 | SPY | ETF | 116.98 | 116.98 | 116.98 | 116.98 | 500.0 |
| 2010-10-18 04:15:00 | SPY | ETF | 117.01 | 117.17 | 117.01 | 117.17 | 10540.0 |
| 2010-10-18 04:20:00 | SPY | ETF | 117.1 | 117.14 | 117.1 | 117.14 | 2600.0 |
| 2010-10-18 04:30:00 | SPY | ETF | 117.16 | 117.16 | 117.13 | 117.13 | 500.0 |
| 2010-10-18 04:50:00 | SPY | ETF | 117.32 | 117.32 | 117.32 | 117.32 | 100.0 |
| 2010-10-18 05:00:00 | SPY | ETF | 117.29 | 117.29 | 117.29 | 117.29 | 1000.0 |
| 2010-10-18 05:15:00 | SPY | ETF | 117.44 | 117.44 | 117.44 | 117.44 | 1000.0 |
| 2010-10-18 05:20:00 | SPY | ETF | 117.41 | 117.41 | 117.41 | 117.41 | 1000.0 |
| 2010-10-18 05:40:00 | SPY | ETF | 117.44 | 117.44 | 117.44 | 117.44 | 2000.0 |
| 2010-10-18 05:45:00 | SPY | ETF | 117.48 | 117.5 | 117.48 | 117.5 | 2000.0 |
| 2010-10-18 05:50:00 | SPY | ETF | 117.54 | 117.55 | 117.54 | 117.55 | 2100.0 |
| 2010-10-18 05:55:00 | SPY | ETF | 117.49 | 117.53 | 117.49 | 117.53 | 2200.0 |
| 2010-10-18 06:00:00 | SPY | ETF | 117.5 | 117.5 | 117.48 | 117.48 | 900.0 |
| 2010-10-18 06:10:00 | SPY | ETF | 117.45 | 117.45 | 117.42 | 117.42 | 1600.0 |
| 2010-10-18 06:15:00 | SPY | ETF | 117.53 | 117.53 | 117.53 | 117.53 | 200.0 |
| 2010-10-18 06:20:00 | SPY | ETF | 117.6 | 117.64 | 117.6 | 117.64 | 400.0 |
| 2010-10-18 06:25:00 | SPY | ETF | 117.64 | 117.64 | 117.63 | 117.63 | 5800.0 |
| 2010-10-18 06:30:00 | SPY | ETF | 117.63 | 117.63 | 117.63 | 117.63 | 4900.0 |
| 2010-10-18 06:35:00 | SPY | ETF | 117.61 | 117.61 | 117.55 | 117.55 | 3000.0 |
| 2010-10-18 06:40:00 | SPY | ETF | 117.61 | 117.61 | 117.53 | 117.53 | 5800.0 |
| 2010-10-18 06:45:00 | SPY | ETF | 117.58 | 117.6 | 117.58 | 117.6 | 10000.0 |
| 2010-10-18 06:50:00 | SPY | ETF | 117.64 | 117.64 | 117.64 | 117.64 | 100.0 |
| 2010-10-18 06:55:00 | SPY | ETF | 117.58 | 117.58 | 117.53 | 117.56 | 775.0 |
| 2010-10-18 07:00:00 | SPY | ETF | 117.57 | 117.57 | 117.48 | 117.48 | 25790.0 |
| 2010-10-18 07:05:00 | SPY | ETF | 117.52 | 117.52 | 117.48 | 117.52 | 4387.0 |
| 2010-10-18 07:10:00 | SPY | ETF | 117.52 | 117.52 | 117.48 | 117.51 | 9756.0 |
| 2010-10-18 07:15:00 | SPY | ETF | 117.5 | 117.5 | 117.43 | 117.49 | 8360.0 |
| 2010-10-18 07:20:00 | SPY | ETF | 117.46 | 117.49 | 117.43 | 117.49 | 97100.0 |
| 2010-10-18 07:25:00 | SPY | ETF | 117.49 | 117.51 | 117.47 | 117.47 | 46200.0 |
| 2010-10-18 07:30:00 | SPY | ETF | 117.46 | 117.46 | 117.45 | 117.46 | 8670.0 |
| 2010-10-18 07:35:00 | SPY | ETF | 117.48 | 117.54 | 117.48 | 117.52 | 22635.0 |
| 2010-10-18 07:40:00 | SPY | ETF | 117.51 | 117.59 | 117.5 | 117.54 | 14478.0 |
| 2010-10-18 07:45:00 | SPY | ETF | 117.57 | 117.57 | 117.48 | 117.48 | 101750.0 |
| 2010-10-18 07:50:00 | SPY | ETF | 117.49 | 117.49 | 117.41 | 117.41 | 38024.0 |
| 2010-10-18 07:55:00 | SPY | ETF | 117.41 | 117.44 | 117.41 | 117.43 | 34200.0 |
| 2010-10-18 08:00:00 | SPY | ETF | 117.47 | 117.73 | 117.26 | 117.36 | 163037.0 |
| 2010-10-18 08:05:00 | SPY | ETF | 117.37 | 117.49 | 117.37 | 117.48 | 57160.0 |
| 2010-10-18 08:10:00 | SPY | ETF | 117.48 | 117.66 | 117.45 | 117.64 | 170741.0 |
| 2010-10-18 08:15:00 | SPY | ETF | 117.65 | 117.69 | 117.64 | 117.68 | 86661.0 |
| 2010-10-18 08:20:00 | SPY | ETF | 117.68 | 117.78 | 117.64 | 117.73 | 61032.0 |
| 2010-10-18 08:25:00 | SPY | ETF | 117.73 | 117.75 | 117.71 | 117.72 | 57081.0 |
| 2010-10-18 08:30:00 | SPY | ETF | 117.72 | 117.81 | 117.71 | 117.71 | 120812.0 |
| 2010-10-18 08:35:00 | SPY | ETF | 117.72 | 117.72 | 117.67 | 117.7 | 50525.0 |
| 2010-10-18 08:40:00 | SPY | ETF | 117.71 | 117.72 | 117.65 | 117.69 | 34300.0 |
| 2010-10-18 08:45:00 | SPY | ETF | 117.7 | 117.7 | 117.65 | 117.66 | 89095.0 |
| 2010-10-18 08:50:00 | SPY | ETF | 117.66 | 117.76 | 117.66 | 117.75 | 77250.0 |
| 2010-10-18 08:55:00 | SPY | ETF | 117.75 | 117.82 | 117.73 | 117.81 | 66099.0 |
| 2010-10-18 09:00:00 | SPY | ETF | 117.81 | 117.83 | 117.78 | 117.8 | 169638.0 |
> showing 50 of 34,861 rows — these rows as CSV