PREVIEW / etf_5min / 2009-11-13
file: by_date/etf_5min/2009/2009-11-13.parquet size: 708 KB rows: 30,139
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-13 04:05:00 | SPY | ETF | 109.56 | 109.56 | 109.56 | 109.56 | 100.0 |
| 2009-11-13 04:15:00 | SPY | ETF | 109.54 | 109.57 | 109.52 | 109.57 | 1750.0 |
| 2009-11-13 04:20:00 | SPY | ETF | 109.6 | 109.6 | 109.6 | 109.6 | 100.0 |
| 2009-11-13 04:35:00 | SPY | ETF | 109.52 | 109.52 | 109.52 | 109.52 | 100.0 |
| 2009-11-13 04:40:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 500.0 |
| 2009-11-13 05:10:00 | SPY | ETF | 109.45 | 109.45 | 109.45 | 109.45 | 500.0 |
| 2009-11-13 05:25:00 | SPY | ETF | 109.49 | 109.49 | 109.49 | 109.49 | 100.0 |
| 2009-11-13 05:45:00 | SPY | ETF | 109.47 | 109.47 | 109.47 | 109.47 | 300.0 |
| 2009-11-13 06:05:00 | SPY | ETF | 109.57 | 109.57 | 109.57 | 109.57 | 1000.0 |
| 2009-11-13 06:10:00 | SPY | ETF | 109.59 | 109.59 | 109.59 | 109.59 | 200.0 |
| 2009-11-13 06:15:00 | SPY | ETF | 109.6 | 109.61 | 109.6 | 109.61 | 2100.0 |
| 2009-11-13 06:25:00 | SPY | ETF | 109.7 | 109.7 | 109.7 | 109.7 | 100.0 |
| 2009-11-13 06:30:00 | SPY | ETF | 109.6 | 109.65 | 109.6 | 109.65 | 1100.0 |
| 2009-11-13 06:40:00 | SPY | ETF | 109.64 | 109.64 | 109.64 | 109.64 | 100.0 |
| 2009-11-13 06:45:00 | SPY | ETF | 109.6 | 109.6 | 109.59 | 109.6 | 1798.0 |
| 2009-11-13 06:50:00 | SPY | ETF | 109.6 | 109.67 | 109.59 | 109.67 | 2152.0 |
| 2009-11-13 06:55:00 | SPY | ETF | 109.6 | 109.6 | 109.6 | 109.6 | 500.0 |
| 2009-11-13 07:00:00 | SPY | ETF | 109.66 | 109.66 | 109.58 | 109.59 | 39462.0 |
| 2009-11-13 07:05:00 | SPY | ETF | 109.59 | 109.6 | 109.53 | 109.53 | 152800.0 |
| 2009-11-13 07:10:00 | SPY | ETF | 109.54 | 109.54 | 109.48 | 109.49 | 24082.0 |
| 2009-11-13 07:15:00 | SPY | ETF | 109.49 | 109.51 | 109.48 | 109.51 | 14680.0 |
| 2009-11-13 07:20:00 | SPY | ETF | 109.52 | 109.52 | 109.39 | 109.41 | 16950.0 |
| 2009-11-13 07:25:00 | SPY | ETF | 109.41 | 109.42 | 109.35 | 109.35 | 25975.0 |
| 2009-11-13 07:30:00 | SPY | ETF | 109.35 | 109.53 | 109.35 | 109.53 | 385066.0 |
| 2009-11-13 07:35:00 | SPY | ETF | 109.54 | 109.54 | 109.48 | 109.48 | 63200.0 |
| 2009-11-13 07:40:00 | SPY | ETF | 109.46 | 109.5 | 109.43 | 109.43 | 54300.0 |
| 2009-11-13 07:45:00 | SPY | ETF | 109.43 | 109.46 | 109.43 | 109.43 | 22200.0 |
| 2009-11-13 07:50:00 | SPY | ETF | 109.43 | 109.47 | 109.4 | 109.42 | 5403.0 |
| 2009-11-13 07:55:00 | SPY | ETF | 109.41 | 109.42 | 109.4 | 109.42 | 34608.0 |
| 2009-11-13 08:00:00 | SPY | ETF | 109.58 | 109.58 | 109.34 | 109.36 | 1052492.0 |
| 2009-11-13 08:05:00 | SPY | ETF | 109.35 | 109.36 | 109.3 | 109.34 | 64151.0 |
| 2009-11-13 08:10:00 | SPY | ETF | 109.35 | 109.39 | 109.34 | 109.37 | 53809.0 |
| 2009-11-13 08:15:00 | SPY | ETF | 109.37 | 109.46 | 109.37 | 109.44 | 47571.0 |
| 2009-11-13 08:20:00 | SPY | ETF | 109.43 | 109.46 | 109.42 | 109.43 | 102270.0 |
| 2009-11-13 08:25:00 | SPY | ETF | 109.43 | 109.45 | 109.42 | 109.43 | 32119.0 |
| 2009-11-13 08:30:00 | SPY | ETF | 109.45 | 109.53 | 109.32 | 109.51 | 540049.0 |
| 2009-11-13 08:35:00 | SPY | ETF | 109.51 | 109.55 | 109.51 | 109.54 | 166307.0 |
| 2009-11-13 08:40:00 | SPY | ETF | 109.55 | 109.56 | 109.53 | 109.54 | 50500.0 |
| 2009-11-13 08:45:00 | SPY | ETF | 109.54 | 109.57 | 109.53 | 109.54 | 58018.0 |
| 2009-11-13 08:50:00 | SPY | ETF | 109.54 | 109.54 | 109.49 | 109.49 | 50325.0 |
| 2009-11-13 08:55:00 | SPY | ETF | 109.5 | 109.52 | 108.99 | 109.52 | 83650.0 |
| 2009-11-13 09:00:00 | SPY | ETF | 109.52 | 109.57 | 109.36 | 109.38 | 231156.0 |
| 2009-11-13 09:05:00 | SPY | ETF | 109.38 | 109.45 | 109.38 | 109.39 | 82252.0 |
| 2009-11-13 09:10:00 | SPY | ETF | 109.38 | 109.38 | 109.25 | 109.29 | 254411.0 |
| 2009-11-13 09:15:00 | SPY | ETF | 109.29 | 109.31 | 109.28 | 109.3 | 64298.0 |
| 2009-11-13 09:20:00 | SPY | ETF | 109.29 | 109.3 | 109.24 | 109.28 | 152237.0 |
| 2009-11-13 09:25:00 | SPY | ETF | 109.28 | 109.34 | 109.27 | 109.32 | 186201.0 |
| 2009-11-13 09:30:00 | SPY | ETF | 109.31 | 109.38 | 109.16 | 109.1774 | 3540320.0 |
| 2009-11-13 09:35:00 | SPY | ETF | 109.18 | 109.26 | 109.109 | 109.22 | 2912421.0 |
| 2009-11-13 09:40:00 | SPY | ETF | 109.22 | 109.29 | 109.06 | 109.14 | 3517051.0 |
> showing 50 of 30,139 rows — these rows as CSV