PREVIEW / etf_5min / 2011-07-08
file: by_date/etf_5min/2011/2011-07-08.parquet size: 868 KB rows: 36,623
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-07-08 04:15:00 | SPY | ETF | 135.62 | 135.64 | 135.62 | 135.64 | 800.0 |
| 2011-07-08 04:45:00 | SPY | ETF | 135.37 | 135.37 | 135.37 | 135.37 | 100.0 |
| 2011-07-08 04:55:00 | SPY | ETF | 135.65 | 135.65 | 135.65 | 135.65 | 100.0 |
| 2011-07-08 05:15:00 | SPY | ETF | 135.54 | 135.54 | 135.54 | 135.54 | 100.0 |
| 2011-07-08 05:20:00 | SPY | ETF | 135.49 | 135.49 | 135.49 | 135.49 | 100.0 |
| 2011-07-08 05:25:00 | SPY | ETF | 135.46 | 135.46 | 135.46 | 135.46 | 100.0 |
| 2011-07-08 05:30:00 | SPY | ETF | 135.37 | 135.37 | 135.33 | 135.33 | 500.0 |
| 2011-07-08 05:40:00 | SPY | ETF | 135.33 | 135.33 | 135.33 | 135.33 | 200.0 |
| 2011-07-08 05:55:00 | SPY | ETF | 135.24 | 135.24 | 135.2 | 135.2 | 800.0 |
| 2011-07-08 06:00:00 | SPY | ETF | 135.34 | 135.34 | 135.34 | 135.34 | 500.0 |
| 2011-07-08 06:05:00 | SPY | ETF | 135.39 | 135.39 | 135.31 | 135.31 | 1000.0 |
| 2011-07-08 06:15:00 | SPY | ETF | 135.35 | 135.35 | 135.35 | 135.35 | 100.0 |
| 2011-07-08 06:20:00 | SPY | ETF | 135.26 | 135.27 | 135.26 | 135.27 | 700.0 |
| 2011-07-08 06:25:00 | SPY | ETF | 135.35 | 135.35 | 135.35 | 135.35 | 2900.0 |
| 2011-07-08 06:45:00 | SPY | ETF | 135.49 | 135.49 | 135.49 | 135.49 | 200.0 |
| 2011-07-08 06:50:00 | SPY | ETF | 135.42 | 135.49 | 135.42 | 135.49 | 1200.0 |
| 2011-07-08 06:55:00 | SPY | ETF | 135.49 | 135.52 | 135.49 | 135.52 | 200.0 |
| 2011-07-08 07:00:00 | SPY | ETF | 135.5 | 135.5 | 135.46 | 135.46 | 1800.0 |
| 2011-07-08 07:05:00 | SPY | ETF | 135.5 | 135.53 | 135.47 | 135.49 | 12800.0 |
| 2011-07-08 07:10:00 | SPY | ETF | 135.49 | 135.52 | 135.49 | 135.52 | 1400.0 |
| 2011-07-08 07:15:00 | SPY | ETF | 135.51 | 135.63 | 135.51 | 135.59 | 10500.0 |
| 2011-07-08 07:20:00 | SPY | ETF | 135.57 | 135.58 | 135.51 | 135.53 | 12800.0 |
| 2011-07-08 07:25:00 | SPY | ETF | 135.53 | 135.6 | 135.52 | 135.54 | 17350.0 |
| 2011-07-08 07:30:00 | SPY | ETF | 135.55 | 135.59 | 135.52 | 135.55 | 35600.0 |
| 2011-07-08 07:35:00 | SPY | ETF | 135.55 | 135.58 | 135.55 | 135.55 | 11700.0 |
| 2011-07-08 07:40:00 | SPY | ETF | 135.54 | 135.55 | 135.52 | 135.55 | 8894.0 |
| 2011-07-08 07:45:00 | SPY | ETF | 135.54 | 135.6 | 135.54 | 135.6 | 62500.0 |
| 2011-07-08 07:50:00 | SPY | ETF | 135.57 | 135.6 | 135.54 | 135.57 | 93400.0 |
| 2011-07-08 07:55:00 | SPY | ETF | 135.57 | 135.57 | 135.46 | 135.49 | 151084.0 |
| 2011-07-08 08:00:00 | SPY | ETF | 135.54 | 135.57 | 135.5 | 135.51 | 765315.0 |
| 2011-07-08 08:05:00 | SPY | ETF | 135.5 | 135.57 | 135.49 | 135.57 | 77000.0 |
| 2011-07-08 08:10:00 | SPY | ETF | 135.58 | 135.68 | 135.5117 | 135.63 | 851000.0 |
| 2011-07-08 08:15:00 | SPY | ETF | 135.63 | 135.72 | 135.6 | 135.7 | 1331860.0 |
| 2011-07-08 08:20:00 | SPY | ETF | 135.7 | 135.87 | 135.68 | 135.77 | 426951.0 |
| 2011-07-08 08:25:00 | SPY | ETF | 135.76 | 135.87 | 135.51 | 135.87 | 1532401.0 |
| 2011-07-08 08:30:00 | SPY | ETF | 135.87 | 135.87 | 133.96 | 133.98 | 11350748.0 |
| 2011-07-08 08:35:00 | SPY | ETF | 133.99 | 134.12 | 133.85 | 134.12 | 2632558.0 |
| 2011-07-08 08:40:00 | SPY | ETF | 134.12 | 134.24 | 133.89 | 134.13 | 1105779.0 |
| 2011-07-08 08:45:00 | SPY | ETF | 134.13 | 134.16 | 134.05 | 134.1 | 612401.0 |
| 2011-07-08 08:50:00 | SPY | ETF | 134.1 | 134.17 | 133.95 | 134.0 | 630071.0 |
| 2011-07-08 08:55:00 | SPY | ETF | 134.0 | 134.01 | 133.68 | 133.8 | 1145809.0 |
| 2011-07-08 09:00:00 | SPY | ETF | 133.81 | 133.81 | 133.51 | 133.57 | 2069134.0 |
| 2011-07-08 09:05:00 | SPY | ETF | 133.57 | 133.78 | 133.53 | 133.77 | 1315246.0 |
| 2011-07-08 09:10:00 | SPY | ETF | 133.76 | 133.9 | 133.73 | 133.81 | 435324.0 |
| 2011-07-08 09:15:00 | SPY | ETF | 133.82 | 133.89 | 133.8 | 133.88 | 391510.0 |
| 2011-07-08 09:20:00 | SPY | ETF | 133.87 | 133.91 | 133.8 | 133.82 | 303271.0 |
| 2011-07-08 09:25:00 | SPY | ETF | 133.83 | 133.86 | 133.76 | 133.83 | 616841.0 |
| 2011-07-08 09:30:00 | SPY | ETF | 133.83 | 134.13 | 133.82 | 134.12 | 7351988.0 |
| 2011-07-08 09:35:00 | SPY | ETF | 134.12 | 134.13 | 133.98 | 134.06 | 3353428.0 |
| 2011-07-08 09:40:00 | SPY | ETF | 134.07 | 134.19 | 133.985 | 134.18 | 3631373.0 |
> showing 50 of 36,623 rows — these rows as CSV