PREVIEW / etf_5min / 2009-11-11
file: by_date/etf_5min/2009/2009-11-11.parquet size: 728 KB rows: 31,448
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-11 04:10:00 | SPY | ETF | 110.29 | 110.29 | 110.29 | 110.29 | 650.0 |
| 2009-11-11 04:15:00 | SPY | ETF | 110.24 | 110.24 | 110.24 | 110.24 | 100.0 |
| 2009-11-11 04:25:00 | SPY | ETF | 110.28 | 110.44 | 110.28 | 110.44 | 600.0 |
| 2009-11-11 04:30:00 | SPY | ETF | 110.44 | 110.44 | 110.44 | 110.44 | 100.0 |
| 2009-11-11 04:35:00 | SPY | ETF | 110.42 | 110.43 | 110.42 | 110.43 | 500.0 |
| 2009-11-11 04:40:00 | SPY | ETF | 110.44 | 110.5 | 110.44 | 110.5 | 500.0 |
| 2009-11-11 04:45:00 | SPY | ETF | 110.54 | 110.59 | 110.54 | 110.59 | 600.0 |
| 2009-11-11 04:50:00 | SPY | ETF | 110.64 | 110.64 | 110.64 | 110.64 | 150.0 |
| 2009-11-11 04:55:00 | SPY | ETF | 110.66 | 110.66 | 110.66 | 110.66 | 200.0 |
| 2009-11-11 05:00:00 | SPY | ETF | 110.58 | 110.58 | 110.58 | 110.58 | 100.0 |
| 2009-11-11 05:05:00 | SPY | ETF | 110.57 | 110.57 | 110.57 | 110.57 | 200.0 |
| 2009-11-11 05:30:00 | SPY | ETF | 110.48 | 110.48 | 110.42 | 110.42 | 400.0 |
| 2009-11-11 05:35:00 | SPY | ETF | 110.47 | 110.47 | 110.47 | 110.47 | 200.0 |
| 2009-11-11 05:45:00 | SPY | ETF | 110.48 | 110.48 | 110.48 | 110.48 | 200.0 |
| 2009-11-11 05:55:00 | SPY | ETF | 110.43 | 110.43 | 110.42 | 110.43 | 1215.0 |
| 2009-11-11 06:00:00 | SPY | ETF | 110.48 | 110.48 | 110.48 | 110.48 | 100.0 |
| 2009-11-11 06:15:00 | SPY | ETF | 110.47 | 110.47 | 110.47 | 110.47 | 400.0 |
| 2009-11-11 06:20:00 | SPY | ETF | 110.43 | 110.43 | 110.43 | 110.43 | 500.0 |
| 2009-11-11 06:25:00 | SPY | ETF | 110.44 | 110.44 | 110.44 | 110.44 | 3400.0 |
| 2009-11-11 06:30:00 | SPY | ETF | 110.42 | 110.47 | 110.42 | 110.47 | 1019.0 |
| 2009-11-11 06:35:00 | SPY | ETF | 110.41 | 110.41 | 110.41 | 110.41 | 300.0 |
| 2009-11-11 06:45:00 | SPY | ETF | 110.44 | 110.44 | 110.44 | 110.44 | 100.0 |
| 2009-11-11 06:50:00 | SPY | ETF | 110.44 | 110.44 | 110.44 | 110.44 | 1000.0 |
| 2009-11-11 06:55:00 | SPY | ETF | 110.48 | 110.6 | 110.48 | 110.52 | 17000.0 |
| 2009-11-11 07:00:00 | SPY | ETF | 110.52 | 110.53 | 110.49 | 110.51 | 25019.0 |
| 2009-11-11 07:05:00 | SPY | ETF | 110.5 | 110.61 | 110.49 | 110.61 | 19200.0 |
| 2009-11-11 07:10:00 | SPY | ETF | 110.58 | 110.61 | 110.58 | 110.59 | 43730.0 |
| 2009-11-11 07:15:00 | SPY | ETF | 110.6 | 110.62 | 110.58 | 110.62 | 23261.0 |
| 2009-11-11 07:20:00 | SPY | ETF | 110.61 | 110.61 | 110.56 | 110.56 | 18750.0 |
| 2009-11-11 07:25:00 | SPY | ETF | 110.58 | 110.58 | 110.48 | 110.51 | 39220.0 |
| 2009-11-11 07:30:00 | SPY | ETF | 110.54 | 110.54 | 110.5 | 110.5 | 9811.0 |
| 2009-11-11 07:35:00 | SPY | ETF | 110.48 | 110.54 | 110.45 | 110.5 | 90320.0 |
| 2009-11-11 07:40:00 | SPY | ETF | 110.46 | 110.47 | 110.45 | 110.47 | 17854.0 |
| 2009-11-11 07:45:00 | SPY | ETF | 110.47 | 110.47 | 110.41 | 110.45 | 21450.0 |
| 2009-11-11 07:50:00 | SPY | ETF | 110.45 | 110.46 | 110.42 | 110.46 | 135901.0 |
| 2009-11-11 07:55:00 | SPY | ETF | 110.45 | 110.45 | 110.39 | 110.4 | 106530.0 |
| 2009-11-11 08:00:00 | SPY | ETF | 110.57 | 110.57 | 110.37 | 110.4 | 180368.0 |
| 2009-11-11 08:05:00 | SPY | ETF | 110.4 | 110.44 | 110.39 | 110.42 | 98412.0 |
| 2009-11-11 08:10:00 | SPY | ETF | 110.42 | 110.47 | 110.41 | 110.45 | 102431.0 |
| 2009-11-11 08:15:00 | SPY | ETF | 110.44 | 110.46 | 110.43 | 110.45 | 58917.0 |
| 2009-11-11 08:20:00 | SPY | ETF | 110.45 | 110.45 | 110.35 | 110.35 | 132310.0 |
| 2009-11-11 08:25:00 | SPY | ETF | 110.35 | 110.39 | 110.35 | 110.37 | 51914.0 |
| 2009-11-11 08:30:00 | SPY | ETF | 110.37 | 110.41 | 110.35 | 110.37 | 143564.0 |
| 2009-11-11 08:35:00 | SPY | ETF | 110.37 | 110.4 | 110.34 | 110.34 | 164313.0 |
| 2009-11-11 08:40:00 | SPY | ETF | 110.34 | 110.39 | 110.34 | 110.38 | 108095.0 |
| 2009-11-11 08:45:00 | SPY | ETF | 110.38 | 110.43 | 110.37 | 110.41 | 247999.0 |
| 2009-11-11 08:50:00 | SPY | ETF | 110.41 | 110.41 | 110.38 | 110.39 | 101096.0 |
| 2009-11-11 08:55:00 | SPY | ETF | 110.39 | 110.39 | 110.33 | 110.35 | 95783.0 |
| 2009-11-11 09:00:00 | SPY | ETF | 110.35 | 110.36 | 110.32 | 110.36 | 73269.0 |
| 2009-11-11 09:05:00 | SPY | ETF | 110.36 | 110.4 | 110.35 | 110.39 | 122360.0 |
> showing 50 of 31,448 rows — these rows as CSV