PREVIEW / etf_5min / 2011-08-29
file: by_date/etf_5min/2011/2011-08-29.parquet size: 893 KB rows: 36,396
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-08-29 04:00:00 | SPY | ETF | 118.7 | 119.17 | 118.7 | 119.17 | 1030.0 |
| 2011-08-29 04:15:00 | SPY | ETF | 119.21 | 119.3 | 119.21 | 119.3 | 580.0 |
| 2011-08-29 04:20:00 | SPY | ETF | 119.26 | 119.26 | 119.26 | 119.26 | 2500.0 |
| 2011-08-29 04:30:00 | SPY | ETF | 119.31 | 119.33 | 119.31 | 119.33 | 683.0 |
| 2011-08-29 04:40:00 | SPY | ETF | 119.24 | 119.24 | 119.24 | 119.24 | 100.0 |
| 2011-08-29 04:45:00 | SPY | ETF | 119.21 | 119.21 | 119.14 | 119.14 | 950.0 |
| 2011-08-29 04:50:00 | SPY | ETF | 119.14 | 119.2 | 119.14 | 119.2 | 9682.0 |
| 2011-08-29 04:55:00 | SPY | ETF | 119.2 | 119.2 | 119.19 | 119.19 | 6470.0 |
| 2011-08-29 05:00:00 | SPY | ETF | 119.33 | 119.33 | 119.33 | 119.33 | 200.0 |
| 2011-08-29 05:10:00 | SPY | ETF | 119.32 | 119.32 | 119.3 | 119.3 | 200.0 |
| 2011-08-29 05:15:00 | SPY | ETF | 119.28 | 119.28 | 119.28 | 119.28 | 100.0 |
| 2011-08-29 05:20:00 | SPY | ETF | 119.35 | 119.35 | 119.3 | 119.3 | 200.0 |
| 2011-08-29 05:25:00 | SPY | ETF | 119.32 | 119.37 | 119.32 | 119.37 | 885.0 |
| 2011-08-29 05:35:00 | SPY | ETF | 119.29 | 119.29 | 119.29 | 119.29 | 100.0 |
| 2011-08-29 05:40:00 | SPY | ETF | 119.32 | 119.32 | 119.32 | 119.32 | 500.0 |
| 2011-08-29 05:55:00 | SPY | ETF | 119.27 | 119.27 | 119.22 | 119.27 | 800.0 |
| 2011-08-29 06:10:00 | SPY | ETF | 119.27 | 119.27 | 119.27 | 119.27 | 200.0 |
| 2011-08-29 06:15:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 200.0 |
| 2011-08-29 06:20:00 | SPY | ETF | 119.32 | 119.32 | 119.32 | 119.32 | 100.0 |
| 2011-08-29 06:25:00 | SPY | ETF | 119.25 | 119.26 | 119.17 | 119.17 | 2200.0 |
| 2011-08-29 06:30:00 | SPY | ETF | 119.15 | 119.15 | 119.1 | 119.1 | 980.0 |
| 2011-08-29 06:35:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 5000.0 |
| 2011-08-29 06:40:00 | SPY | ETF | 119.25 | 119.25 | 119.17 | 119.25 | 10200.0 |
| 2011-08-29 06:45:00 | SPY | ETF | 119.3 | 119.31 | 119.3 | 119.31 | 1400.0 |
| 2011-08-29 06:50:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 200.0 |
| 2011-08-29 06:55:00 | SPY | ETF | 119.32 | 119.32 | 119.31 | 119.31 | 300.0 |
| 2011-08-29 07:00:00 | SPY | ETF | 119.3 | 119.56 | 119.3 | 119.5 | 41490.0 |
| 2011-08-29 07:05:00 | SPY | ETF | 119.52 | 119.65 | 119.51 | 119.6 | 35085.0 |
| 2011-08-29 07:10:00 | SPY | ETF | 119.51 | 119.52 | 119.41 | 119.49 | 106460.0 |
| 2011-08-29 07:15:00 | SPY | ETF | 119.48 | 119.49 | 119.44 | 119.44 | 35050.0 |
| 2011-08-29 07:20:00 | SPY | ETF | 119.43 | 119.47 | 119.41 | 119.41 | 11619.0 |
| 2011-08-29 07:25:00 | SPY | ETF | 119.43 | 119.48 | 119.43 | 119.43 | 13600.0 |
| 2011-08-29 07:30:00 | SPY | ETF | 119.41 | 119.43 | 119.4 | 119.43 | 76075.0 |
| 2011-08-29 07:35:00 | SPY | ETF | 119.43 | 119.47 | 119.43 | 119.43 | 50600.0 |
| 2011-08-29 07:40:00 | SPY | ETF | 119.43 | 119.45 | 119.4 | 119.43 | 18294.0 |
| 2011-08-29 07:45:00 | SPY | ETF | 119.49 | 119.53 | 119.4 | 119.4 | 41349.0 |
| 2011-08-29 07:50:00 | SPY | ETF | 119.41 | 119.43 | 119.33 | 119.35 | 79886.0 |
| 2011-08-29 07:55:00 | SPY | ETF | 119.35 | 119.35 | 119.25 | 119.28 | 35647.0 |
| 2011-08-29 08:00:00 | SPY | ETF | 119.28 | 119.445 | 119.22 | 119.28 | 249739.0 |
| 2011-08-29 08:05:00 | SPY | ETF | 119.27 | 119.32 | 119.25 | 119.31 | 163474.0 |
| 2011-08-29 08:10:00 | SPY | ETF | 119.31 | 119.34 | 118.45 | 119.33 | 724978.0 |
| 2011-08-29 08:15:00 | SPY | ETF | 119.33 | 119.33 | 118.15 | 119.28 | 286755.0 |
| 2011-08-29 08:20:00 | SPY | ETF | 119.28 | 119.39 | 119.28 | 119.34 | 77136.0 |
| 2011-08-29 08:25:00 | SPY | ETF | 119.34 | 119.44 | 118.15 | 119.35 | 100346.0 |
| 2011-08-29 08:30:00 | SPY | ETF | 119.36 | 119.51 | 119.36 | 119.46 | 367493.0 |
| 2011-08-29 08:35:00 | SPY | ETF | 119.45 | 119.48 | 119.35 | 119.45 | 214889.0 |
| 2011-08-29 08:40:00 | SPY | ETF | 119.45 | 119.45 | 119.34 | 119.36 | 58763.0 |
| 2011-08-29 08:45:00 | SPY | ETF | 119.35 | 119.45 | 119.34 | 119.43 | 87762.0 |
| 2011-08-29 08:50:00 | SPY | ETF | 119.43 | 119.56 | 119.43 | 119.54 | 285202.0 |
| 2011-08-29 08:55:00 | SPY | ETF | 119.54 | 119.56 | 119.34 | 119.42 | 104939.0 |
> showing 50 of 36,396 rows — these rows as CSV