PREVIEW / etf_5min / 2013-11-13
file: by_date/etf_5min/2013/2013-11-13.parquet size: 973 KB rows: 40,615
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-13 04:00:00 | SPY | ETF | 176.8 | 176.85 | 176.74 | 176.74 | 1060.0 |
| 2013-11-13 04:05:00 | SPY | ETF | 176.76 | 176.76 | 176.65 | 176.65 | 1900.0 |
| 2013-11-13 04:10:00 | SPY | ETF | 176.68 | 176.75 | 176.68 | 176.68 | 1099.0 |
| 2013-11-13 04:15:00 | SPY | ETF | 176.7 | 176.75 | 176.7 | 176.75 | 700.0 |
| 2013-11-13 04:20:00 | SPY | ETF | 176.72 | 176.78 | 176.72 | 176.78 | 400.0 |
| 2013-11-13 04:25:00 | SPY | ETF | 176.79 | 176.81 | 176.79 | 176.8 | 600.0 |
| 2013-11-13 04:30:00 | SPY | ETF | 176.83 | 176.83 | 176.75 | 176.78 | 600.0 |
| 2013-11-13 04:35:00 | SPY | ETF | 176.75 | 176.75 | 176.72 | 176.72 | 400.0 |
| 2013-11-13 04:40:00 | SPY | ETF | 176.7 | 176.7 | 176.66 | 176.66 | 734.0 |
| 2013-11-13 04:45:00 | SPY | ETF | 176.66 | 176.66 | 176.66 | 176.66 | 100.0 |
| 2013-11-13 04:50:00 | SPY | ETF | 176.66 | 176.72 | 176.66 | 176.71 | 3937.0 |
| 2013-11-13 04:55:00 | SPY | ETF | 176.72 | 176.75 | 176.71 | 176.75 | 500.0 |
| 2013-11-13 05:00:00 | SPY | ETF | 176.73 | 176.84 | 176.73 | 176.84 | 10000.0 |
| 2013-11-13 05:05:00 | SPY | ETF | 176.86 | 176.87 | 176.84 | 176.84 | 3019.0 |
| 2013-11-13 05:15:00 | SPY | ETF | 176.87 | 176.91 | 176.87 | 176.91 | 1100.0 |
| 2013-11-13 05:20:00 | SPY | ETF | 176.9 | 176.9 | 176.9 | 176.9 | 2000.0 |
| 2013-11-13 05:25:00 | SPY | ETF | 176.87 | 176.87 | 176.81 | 176.81 | 3864.0 |
| 2013-11-13 05:30:00 | SPY | ETF | 176.78 | 176.8 | 176.78 | 176.78 | 4400.0 |
| 2013-11-13 05:40:00 | SPY | ETF | 176.8 | 176.8 | 176.8 | 176.8 | 100.0 |
| 2013-11-13 05:50:00 | SPY | ETF | 176.75 | 176.75 | 176.72 | 176.72 | 600.0 |
| 2013-11-13 05:55:00 | SPY | ETF | 176.75 | 176.75 | 176.75 | 176.75 | 100.0 |
| 2013-11-13 06:00:00 | SPY | ETF | 176.72 | 176.72 | 176.66 | 176.66 | 550.0 |
| 2013-11-13 06:05:00 | SPY | ETF | 176.69 | 176.69 | 176.69 | 176.69 | 100.0 |
| 2013-11-13 06:10:00 | SPY | ETF | 176.72 | 176.72 | 176.72 | 176.72 | 200.0 |
| 2013-11-13 06:15:00 | SPY | ETF | 176.75 | 176.78 | 176.75 | 176.76 | 500.0 |
| 2013-11-13 06:20:00 | SPY | ETF | 176.75 | 176.75 | 176.75 | 176.75 | 200.0 |
| 2013-11-13 06:25:00 | SPY | ETF | 176.75 | 176.75 | 176.72 | 176.72 | 15200.0 |
| 2013-11-13 06:30:00 | SPY | ETF | 176.7 | 176.7 | 176.63 | 176.66 | 46670.0 |
| 2013-11-13 06:35:00 | SPY | ETF | 176.68 | 176.69 | 176.68 | 176.69 | 30600.0 |
| 2013-11-13 06:40:00 | SPY | ETF | 176.67 | 176.67 | 176.66 | 176.66 | 11200.0 |
| 2013-11-13 06:45:00 | SPY | ETF | 176.66 | 176.66 | 176.56 | 176.56 | 24985.0 |
| 2013-11-13 06:50:00 | SPY | ETF | 176.56 | 176.56 | 176.53 | 176.56 | 19400.0 |
| 2013-11-13 06:55:00 | SPY | ETF | 176.52 | 176.52 | 176.5 | 176.52 | 27400.0 |
| 2013-11-13 07:00:00 | SPY | ETF | 176.54 | 176.55 | 176.52 | 176.55 | 8500.0 |
| 2013-11-13 07:05:00 | SPY | ETF | 176.54 | 176.57 | 176.54 | 176.57 | 11000.0 |
| 2013-11-13 07:10:00 | SPY | ETF | 176.57 | 176.57 | 176.51 | 176.57 | 21100.0 |
| 2013-11-13 07:15:00 | SPY | ETF | 176.56 | 176.6 | 176.55 | 176.55 | 3300.0 |
| 2013-11-13 07:20:00 | SPY | ETF | 176.56 | 176.58 | 176.53 | 176.53 | 2400.0 |
| 2013-11-13 07:25:00 | SPY | ETF | 176.52 | 176.55 | 176.5 | 176.51 | 34846.0 |
| 2013-11-13 07:30:00 | SPY | ETF | 176.5 | 176.5 | 176.34 | 176.34 | 100168.0 |
| 2013-11-13 07:35:00 | SPY | ETF | 176.37 | 176.42 | 176.34 | 176.36 | 137915.0 |
| 2013-11-13 07:40:00 | SPY | ETF | 176.34 | 176.4 | 176.31 | 176.31 | 24600.0 |
| 2013-11-13 07:45:00 | SPY | ETF | 176.31 | 176.37 | 176.3 | 176.36 | 15795.0 |
| 2013-11-13 07:50:00 | SPY | ETF | 176.37 | 176.42 | 176.36 | 176.4 | 18750.0 |
| 2013-11-13 07:55:00 | SPY | ETF | 176.37 | 176.4 | 176.35 | 176.39 | 28100.0 |
| 2013-11-13 08:00:00 | SPY | ETF | 176.4 | 176.56 | 176.25 | 176.27 | 105792.0 |
| 2013-11-13 08:05:00 | SPY | ETF | 176.25 | 176.25 | 176.09 | 176.1 | 143763.0 |
| 2013-11-13 08:10:00 | SPY | ETF | 176.08 | 176.13 | 176.04 | 176.04 | 290826.0 |
| 2013-11-13 08:15:00 | SPY | ETF | 176.05 | 176.2 | 176.04 | 176.19 | 131150.0 |
| 2013-11-13 08:20:00 | SPY | ETF | 176.15 | 176.25 | 176.14 | 176.16 | 59175.0 |
> showing 50 of 40,615 rows — these rows as CSV