PREVIEW / etf_5min / 2019-08-15
file: by_date/etf_5min/2019/2019-08-15.parquet size: 1.6 MB rows: 67,508
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 |
|---|---|---|---|---|---|---|---|
| 2019-08-15 04:00:00 | SPY | ETF | 285.55 | 285.62 | 285.37 | 285.42 | 9156.0 |
| 2019-08-15 04:05:00 | SPY | ETF | 285.38 | 285.68 | 285.38 | 285.68 | 4966.0 |
| 2019-08-15 04:10:00 | SPY | ETF | 285.73 | 285.8 | 285.66 | 285.66 | 3210.0 |
| 2019-08-15 04:15:00 | SPY | ETF | 285.7 | 286.0 | 285.69 | 285.99 | 2449.0 |
| 2019-08-15 04:20:00 | SPY | ETF | 285.93 | 285.93 | 285.65 | 285.73 | 4126.0 |
| 2019-08-15 04:25:00 | SPY | ETF | 285.73 | 286.0 | 285.73 | 286.0 | 4662.0 |
| 2019-08-15 04:30:00 | SPY | ETF | 285.9 | 285.99 | 285.9 | 285.99 | 4400.0 |
| 2019-08-15 04:35:00 | SPY | ETF | 286.21 | 286.22 | 286.05 | 286.12 | 4569.0 |
| 2019-08-15 04:40:00 | SPY | ETF | 286.16 | 286.16 | 286.11 | 286.11 | 3510.0 |
| 2019-08-15 04:45:00 | SPY | ETF | 286.19 | 286.25 | 286.19 | 286.24 | 2679.0 |
| 2019-08-15 04:50:00 | SPY | ETF | 286.15 | 286.15 | 285.97 | 285.98 | 2960.0 |
| 2019-08-15 04:55:00 | SPY | ETF | 286.0 | 286.0 | 285.75 | 285.75 | 2825.0 |
| 2019-08-15 05:00:00 | SPY | ETF | 285.71 | 285.78 | 284.07 | 284.7 | 38167.0 |
| 2019-08-15 05:05:00 | SPY | ETF | 284.5 | 284.66 | 284.01 | 284.34 | 12405.0 |
| 2019-08-15 05:10:00 | SPY | ETF | 284.4 | 284.6 | 284.38 | 284.52 | 8613.0 |
| 2019-08-15 05:15:00 | SPY | ETF | 284.43 | 284.72 | 284.43 | 284.7 | 5132.0 |
| 2019-08-15 05:20:00 | SPY | ETF | 284.6 | 284.7 | 284.54 | 284.7 | 3390.0 |
| 2019-08-15 05:25:00 | SPY | ETF | 284.68 | 284.78 | 284.63 | 284.63 | 3087.0 |
| 2019-08-15 05:30:00 | SPY | ETF | 284.56 | 284.56 | 284.26 | 284.35 | 5393.0 |
| 2019-08-15 05:35:00 | SPY | ETF | 284.39 | 284.45 | 284.26 | 284.26 | 9225.0 |
| 2019-08-15 05:40:00 | SPY | ETF | 284.22 | 284.22 | 283.67 | 283.67 | 40957.0 |
| 2019-08-15 05:45:00 | SPY | ETF | 283.77 | 283.77 | 283.14 | 283.3 | 22011.0 |
| 2019-08-15 05:50:00 | SPY | ETF | 283.21 | 283.74 | 283.21 | 283.59 | 13320.0 |
| 2019-08-15 05:55:00 | SPY | ETF | 283.56 | 283.8 | 283.54 | 283.8 | 6850.0 |
| 2019-08-15 06:00:00 | SPY | ETF | 283.76 | 283.77 | 283.63 | 283.63 | 7669.0 |
| 2019-08-15 06:05:00 | SPY | ETF | 283.57 | 283.57 | 283.1 | 283.17 | 12928.0 |
| 2019-08-15 06:10:00 | SPY | ETF | 283.23 | 283.47 | 283.0 | 283.1 | 24654.0 |
| 2019-08-15 06:15:00 | SPY | ETF | 283.13 | 283.34 | 282.78 | 282.81 | 22019.0 |
| 2019-08-15 06:20:00 | SPY | ETF | 282.83 | 282.85 | 282.4 | 282.51 | 23344.0 |
| 2019-08-15 06:25:00 | SPY | ETF | 282.45 | 282.75 | 282.45 | 282.46 | 13644.0 |
| 2019-08-15 06:30:00 | SPY | ETF | 282.46 | 282.71 | 282.36 | 282.38 | 83288.0 |
| 2019-08-15 06:35:00 | SPY | ETF | 282.38 | 282.38 | 281.72 | 281.76 | 47748.0 |
| 2019-08-15 06:40:00 | SPY | ETF | 281.71 | 282.38 | 281.63 | 282.18 | 27332.0 |
| 2019-08-15 06:45:00 | SPY | ETF | 282.14 | 282.26 | 282.1 | 282.18 | 42971.0 |
| 2019-08-15 06:50:00 | SPY | ETF | 282.13 | 282.35 | 281.95 | 282.2 | 68522.0 |
| 2019-08-15 06:55:00 | SPY | ETF | 282.25 | 282.84 | 282.24 | 282.79 | 32995.0 |
| 2019-08-15 07:00:00 | SPY | ETF | 282.75 | 282.99 | 282.71 | 282.83 | 45438.0 |
| 2019-08-15 07:05:00 | SPY | ETF | 282.83 | 283.85 | 282.76 | 283.53 | 123372.0 |
| 2019-08-15 07:10:00 | SPY | ETF | 283.61 | 283.79 | 283.2 | 283.29 | 69617.0 |
| 2019-08-15 07:15:00 | SPY | ETF | 283.26 | 283.65 | 283.26 | 283.56 | 86149.0 |
| 2019-08-15 07:20:00 | SPY | ETF | 283.55 | 283.79 | 283.47 | 283.63 | 59546.0 |
| 2019-08-15 07:25:00 | SPY | ETF | 283.63 | 285.68 | 283.22 | 285.62 | 258109.0 |
| 2019-08-15 07:30:00 | SPY | ETF | 285.65 | 286.35 | 284.52 | 284.7 | 516613.0 |
| 2019-08-15 07:35:00 | SPY | ETF | 284.72 | 284.88 | 284.19 | 284.58 | 236680.0 |
| 2019-08-15 07:40:00 | SPY | ETF | 284.63 | 285.23 | 284.54 | 284.74 | 120572.0 |
| 2019-08-15 07:45:00 | SPY | ETF | 284.66 | 285.63 | 284.66 | 285.46 | 97810.0 |
| 2019-08-15 07:50:00 | SPY | ETF | 285.45 | 285.69 | 284.79 | 285.48 | 224090.0 |
| 2019-08-15 07:55:00 | SPY | ETF | 285.45 | 285.72 | 285.3 | 285.7 | 139778.0 |
| 2019-08-15 08:00:00 | SPY | ETF | 282.86 | 287.07 | 282.7301 | 286.04 | 613340.0 |
| 2019-08-15 08:05:00 | SPY | ETF | 286.0 | 286.05 | 285.33 | 285.42 | 409712.0 |
> showing 50 of 67,508 rows — these rows as CSV