PREVIEW / etf_5min / 2015-03-13
file: by_date/etf_5min/2015/2015-03-13.parquet size: 1.1 MB rows: 47,729
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-13 04:35:00 | SPY | ETF | 207.16 | 207.3 | 207.16 | 207.3 | 4200.0 |
| 2015-03-13 04:40:00 | SPY | ETF | 207.2 | 207.2 | 207.2 | 207.2 | 200.0 |
| 2015-03-13 05:10:00 | SPY | ETF | 207.12 | 207.12 | 207.12 | 207.12 | 100.0 |
| 2015-03-13 05:20:00 | SPY | ETF | 207.19 | 207.19 | 207.19 | 207.19 | 300.0 |
| 2015-03-13 06:00:00 | SPY | ETF | 207.01 | 207.01 | 207.01 | 207.01 | 100.0 |
| 2015-03-13 06:05:00 | SPY | ETF | 206.96 | 206.96 | 206.96 | 206.96 | 300.0 |
| 2015-03-13 06:10:00 | SPY | ETF | 207.0 | 207.0 | 207.0 | 207.0 | 600.0 |
| 2015-03-13 06:15:00 | SPY | ETF | 206.97 | 206.97 | 206.82 | 206.82 | 3260.0 |
| 2015-03-13 06:20:00 | SPY | ETF | 206.85 | 206.85 | 206.85 | 206.85 | 100.0 |
| 2015-03-13 06:25:00 | SPY | ETF | 206.88 | 206.88 | 206.88 | 206.88 | 200.0 |
| 2015-03-13 06:30:00 | SPY | ETF | 206.94 | 206.98 | 206.94 | 206.98 | 375.0 |
| 2015-03-13 06:35:00 | SPY | ETF | 206.97 | 206.97 | 206.97 | 206.97 | 1900.0 |
| 2015-03-13 06:40:00 | SPY | ETF | 207.03 | 207.07 | 207.03 | 207.03 | 2820.0 |
| 2015-03-13 06:45:00 | SPY | ETF | 207.11 | 207.17 | 207.11 | 207.17 | 800.0 |
| 2015-03-13 06:50:00 | SPY | ETF | 207.17 | 207.27 | 207.17 | 207.24 | 18042.0 |
| 2015-03-13 06:55:00 | SPY | ETF | 207.26 | 207.29 | 207.24 | 207.29 | 2800.0 |
| 2015-03-13 07:00:00 | SPY | ETF | 207.19 | 207.22 | 207.14 | 207.17 | 6500.0 |
| 2015-03-13 07:05:00 | SPY | ETF | 207.18 | 207.23 | 207.18 | 207.19 | 8880.0 |
| 2015-03-13 07:10:00 | SPY | ETF | 207.24 | 207.27 | 207.24 | 207.25 | 4922.0 |
| 2015-03-13 07:15:00 | SPY | ETF | 207.29 | 207.29 | 207.18 | 207.18 | 400.0 |
| 2015-03-13 07:20:00 | SPY | ETF | 207.16 | 207.22 | 207.16 | 207.21 | 552.0 |
| 2015-03-13 07:25:00 | SPY | ETF | 207.22 | 207.22 | 207.12 | 207.12 | 5625.0 |
| 2015-03-13 07:30:00 | SPY | ETF | 207.14 | 207.14 | 207.11 | 207.12 | 16491.0 |
| 2015-03-13 07:35:00 | SPY | ETF | 207.11 | 207.11 | 206.99 | 206.99 | 9700.0 |
| 2015-03-13 07:40:00 | SPY | ETF | 206.98 | 206.98 | 206.88 | 206.88 | 21560.0 |
| 2015-03-13 07:45:00 | SPY | ETF | 206.86 | 206.86 | 206.77 | 206.79 | 50580.0 |
| 2015-03-13 07:50:00 | SPY | ETF | 206.76 | 206.76 | 206.61 | 206.65 | 88375.0 |
| 2015-03-13 07:55:00 | SPY | ETF | 206.7 | 206.72 | 206.52 | 206.52 | 80564.0 |
| 2015-03-13 08:00:00 | SPY | ETF | 206.51 | 207.29 | 206.46 | 206.65 | 81258.0 |
| 2015-03-13 08:05:00 | SPY | ETF | 207.34 | 207.34 | 206.62 | 206.64 | 32331.0 |
| 2015-03-13 08:10:00 | SPY | ETF | 206.63 | 206.67 | 206.62 | 206.62 | 9701.0 |
| 2015-03-13 08:15:00 | SPY | ETF | 206.61 | 206.61 | 206.45 | 206.49 | 31958.0 |
| 2015-03-13 08:20:00 | SPY | ETF | 206.48 | 206.53 | 206.37 | 206.42 | 87154.0 |
| 2015-03-13 08:25:00 | SPY | ETF | 206.44 | 206.49 | 206.43 | 206.48 | 116764.0 |
| 2015-03-13 08:30:00 | SPY | ETF | 206.48 | 206.73 | 206.48 | 206.73 | 154680.0 |
| 2015-03-13 08:35:00 | SPY | ETF | 206.7 | 206.76 | 206.66 | 206.66 | 34879.0 |
| 2015-03-13 08:40:00 | SPY | ETF | 206.69 | 206.75 | 206.69 | 206.72 | 35225.0 |
| 2015-03-13 08:45:00 | SPY | ETF | 206.72 | 206.73 | 206.51 | 206.55 | 71184.0 |
| 2015-03-13 08:50:00 | SPY | ETF | 206.54 | 206.56 | 206.45 | 206.47 | 44954.0 |
| 2015-03-13 08:55:00 | SPY | ETF | 206.54 | 206.69 | 206.53 | 206.64 | 78373.0 |
| 2015-03-13 09:00:00 | SPY | ETF | 206.63 | 206.63 | 206.51 | 206.57 | 79396.0 |
| 2015-03-13 09:05:00 | SPY | ETF | 206.55 | 206.83 | 206.53 | 206.78 | 67130.0 |
| 2015-03-13 09:10:00 | SPY | ETF | 206.79 | 206.86 | 206.75 | 206.8 | 81821.0 |
| 2015-03-13 09:15:00 | SPY | ETF | 206.8 | 206.86 | 206.75 | 206.83 | 48589.0 |
| 2015-03-13 09:20:00 | SPY | ETF | 206.83 | 206.83 | 206.66 | 206.68 | 151363.0 |
| 2015-03-13 09:25:00 | SPY | ETF | 206.69 | 206.79 | 206.67 | 206.79 | 57460.0 |
| 2015-03-13 09:30:00 | SPY | ETF | 206.77 | 206.8 | 206.3 | 206.51 | 3690664.0 |
| 2015-03-13 09:35:00 | SPY | ETF | 206.51 | 206.69 | 206.22 | 206.5849 | 3179547.0 |
| 2015-03-13 09:40:00 | SPY | ETF | 206.59 | 206.75 | 206.43 | 206.75 | 1395520.0 |
| 2015-03-13 09:45:00 | SPY | ETF | 206.75 | 206.93 | 206.619 | 206.86 | 1759170.0 |
> showing 50 of 47,729 rows — these rows as CSV