PREVIEW / etf_5min / 2011-10-05
file: by_date/etf_5min/2011/2011-10-05.parquet size: 949 KB rows: 39,004
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-05 04:00:00 | SPY | ETF | 111.53 | 111.69 | 111.53 | 111.69 | 1519.0 |
| 2011-10-05 04:05:00 | SPY | ETF | 111.56 | 111.56 | 111.56 | 111.56 | 100.0 |
| 2011-10-05 04:10:00 | SPY | ETF | 111.57 | 111.57 | 111.57 | 111.57 | 500.0 |
| 2011-10-05 04:15:00 | SPY | ETF | 111.61 | 111.61 | 111.61 | 111.61 | 100.0 |
| 2011-10-05 04:25:00 | SPY | ETF | 111.8 | 111.8 | 111.8 | 111.8 | 400.0 |
| 2011-10-05 04:35:00 | SPY | ETF | 111.99 | 112.03 | 111.98 | 112.03 | 2700.0 |
| 2011-10-05 04:40:00 | SPY | ETF | 112.0 | 112.0 | 111.91 | 111.91 | 220.0 |
| 2011-10-05 04:45:00 | SPY | ETF | 112.02 | 112.02 | 111.91 | 111.91 | 1500.0 |
| 2011-10-05 04:50:00 | SPY | ETF | 112.02 | 112.02 | 112.02 | 112.02 | 100.0 |
| 2011-10-05 04:55:00 | SPY | ETF | 112.02 | 112.09 | 112.02 | 112.09 | 750.0 |
| 2011-10-05 05:15:00 | SPY | ETF | 111.93 | 111.93 | 111.78 | 111.78 | 200.0 |
| 2011-10-05 05:20:00 | SPY | ETF | 111.86 | 111.93 | 111.86 | 111.93 | 325.0 |
| 2011-10-05 05:35:00 | SPY | ETF | 111.71 | 111.71 | 111.71 | 111.71 | 300.0 |
| 2011-10-05 05:45:00 | SPY | ETF | 111.56 | 111.6 | 111.56 | 111.6 | 580.0 |
| 2011-10-05 05:55:00 | SPY | ETF | 111.74 | 111.86 | 111.74 | 111.86 | 3500.0 |
| 2011-10-05 06:05:00 | SPY | ETF | 111.83 | 111.97 | 111.8 | 111.97 | 3625.0 |
| 2011-10-05 06:10:00 | SPY | ETF | 112.0 | 112.09 | 111.97 | 112.09 | 400.0 |
| 2011-10-05 06:15:00 | SPY | ETF | 112.24 | 112.46 | 112.24 | 112.43 | 3100.0 |
| 2011-10-05 06:20:00 | SPY | ETF | 112.46 | 112.46 | 112.36 | 112.36 | 650.0 |
| 2011-10-05 06:25:00 | SPY | ETF | 112.45 | 112.56 | 112.45 | 112.52 | 2370.0 |
| 2011-10-05 06:30:00 | SPY | ETF | 112.51 | 112.51 | 112.37 | 112.39 | 34700.0 |
| 2011-10-05 06:35:00 | SPY | ETF | 112.39 | 112.56 | 112.39 | 112.55 | 18600.0 |
| 2011-10-05 06:40:00 | SPY | ETF | 112.58 | 113.11 | 112.58 | 113.04 | 110105.0 |
| 2011-10-05 06:45:00 | SPY | ETF | 113.01 | 113.01 | 112.84 | 112.92 | 19100.0 |
| 2011-10-05 06:50:00 | SPY | ETF | 113.0 | 113.0 | 112.8 | 112.8 | 26600.0 |
| 2011-10-05 06:55:00 | SPY | ETF | 112.81 | 112.96 | 112.79 | 112.87 | 32970.0 |
| 2011-10-05 07:00:00 | SPY | ETF | 112.89 | 112.92 | 112.75 | 112.79 | 258856.0 |
| 2011-10-05 07:05:00 | SPY | ETF | 112.79 | 112.88 | 112.77 | 112.77 | 20790.0 |
| 2011-10-05 07:10:00 | SPY | ETF | 112.76 | 112.9 | 112.76 | 112.89 | 70805.0 |
| 2011-10-05 07:15:00 | SPY | ETF | 112.9 | 112.97 | 112.77 | 112.77 | 32620.0 |
| 2011-10-05 07:20:00 | SPY | ETF | 112.82 | 112.82 | 112.65 | 112.65 | 59880.0 |
| 2011-10-05 07:25:00 | SPY | ETF | 112.65 | 112.72 | 112.63 | 112.68 | 85870.0 |
| 2011-10-05 07:30:00 | SPY | ETF | 112.64 | 112.72 | 112.5 | 112.71 | 124971.0 |
| 2011-10-05 07:35:00 | SPY | ETF | 112.66 | 112.69 | 112.45 | 112.51 | 58985.0 |
| 2011-10-05 07:40:00 | SPY | ETF | 112.5 | 112.61 | 112.49 | 112.5 | 58605.0 |
| 2011-10-05 07:45:00 | SPY | ETF | 112.5 | 112.53 | 112.42 | 112.46 | 183745.0 |
| 2011-10-05 07:50:00 | SPY | ETF | 112.47 | 112.52 | 112.4 | 112.51 | 122520.0 |
| 2011-10-05 07:55:00 | SPY | ETF | 112.51 | 112.55 | 112.4 | 112.44 | 32580.0 |
| 2011-10-05 08:00:00 | SPY | ETF | 112.43 | 112.64 | 111.38 | 112.48 | 359083.0 |
| 2011-10-05 08:05:00 | SPY | ETF | 112.49 | 112.54 | 112.43 | 112.44 | 168625.0 |
| 2011-10-05 08:10:00 | SPY | ETF | 112.44 | 112.55 | 112.39 | 112.55 | 361546.0 |
| 2011-10-05 08:15:00 | SPY | ETF | 112.57 | 112.89 | 112.39 | 112.84 | 850055.0 |
| 2011-10-05 08:20:00 | SPY | ETF | 112.85 | 112.85 | 112.45 | 112.48 | 248313.0 |
| 2011-10-05 08:25:00 | SPY | ETF | 112.47 | 112.51 | 112.26 | 112.35 | 496629.0 |
| 2011-10-05 08:30:00 | SPY | ETF | 112.34 | 112.35 | 112.05 | 112.19 | 368147.0 |
| 2011-10-05 08:35:00 | SPY | ETF | 112.2 | 112.37 | 112.19 | 112.25 | 1104422.0 |
| 2011-10-05 08:40:00 | SPY | ETF | 112.26 | 112.44 | 112.21 | 112.34 | 177381.0 |
| 2011-10-05 08:45:00 | SPY | ETF | 112.35 | 112.35 | 112.21 | 112.3 | 201731.0 |
| 2011-10-05 08:50:00 | SPY | ETF | 112.32 | 112.4 | 112.02 | 112.1 | 379026.0 |
| 2011-10-05 08:55:00 | SPY | ETF | 112.13 | 112.14 | 111.95 | 112.01 | 448856.0 |
> showing 50 of 39,004 rows — these rows as CSV