PREVIEW / etf_5min / 2010-05-06
file: by_date/etf_5min/2010/2010-05-06.parquet size: 1013 KB rows: 41,161
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-06 04:15:00 | SPY | ETF | 116.86 | 116.86 | 116.86 | 116.86 | 200.0 |
| 2010-05-06 04:30:00 | SPY | ETF | 117.1 | 117.1 | 117.1 | 117.1 | 100.0 |
| 2010-05-06 04:35:00 | SPY | ETF | 117.2 | 117.2 | 117.2 | 117.2 | 200.0 |
| 2010-05-06 04:50:00 | SPY | ETF | 117.15 | 117.15 | 117.15 | 117.15 | 700.0 |
| 2010-05-06 05:15:00 | SPY | ETF | 117.23 | 117.23 | 117.23 | 117.23 | 4000.0 |
| 2010-05-06 05:30:00 | SPY | ETF | 117.0 | 117.1 | 117.0 | 117.05 | 2200.0 |
| 2010-05-06 05:40:00 | SPY | ETF | 117.0 | 117.0 | 117.0 | 117.0 | 100.0 |
| 2010-05-06 05:50:00 | SPY | ETF | 117.07 | 117.07 | 117.06 | 117.06 | 2400.0 |
| 2010-05-06 05:55:00 | SPY | ETF | 117.01 | 117.08 | 117.01 | 117.08 | 2400.0 |
| 2010-05-06 06:00:00 | SPY | ETF | 117.2 | 117.23 | 117.2 | 117.23 | 9000.0 |
| 2010-05-06 06:05:00 | SPY | ETF | 117.28 | 117.28 | 117.28 | 117.28 | 2000.0 |
| 2010-05-06 06:10:00 | SPY | ETF | 117.29 | 117.29 | 117.29 | 117.29 | 100.0 |
| 2010-05-06 06:20:00 | SPY | ETF | 117.28 | 117.28 | 117.28 | 117.28 | 200.0 |
| 2010-05-06 06:25:00 | SPY | ETF | 117.28 | 117.3 | 117.28 | 117.3 | 22500.0 |
| 2010-05-06 06:35:00 | SPY | ETF | 117.33 | 117.33 | 117.33 | 117.33 | 5000.0 |
| 2010-05-06 06:40:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 15000.0 |
| 2010-05-06 06:45:00 | SPY | ETF | 117.3 | 117.3 | 117.3 | 117.3 | 100.0 |
| 2010-05-06 06:50:00 | SPY | ETF | 117.35 | 117.35 | 117.35 | 117.35 | 150.0 |
| 2010-05-06 06:55:00 | SPY | ETF | 117.31 | 117.31 | 117.3 | 117.3 | 1000.0 |
| 2010-05-06 07:00:00 | SPY | ETF | 117.33 | 117.33 | 117.27 | 117.27 | 9500.0 |
| 2010-05-06 07:05:00 | SPY | ETF | 117.27 | 117.28 | 117.15 | 117.15 | 11950.0 |
| 2010-05-06 07:10:00 | SPY | ETF | 117.13 | 117.2 | 117.07 | 117.2 | 63700.0 |
| 2010-05-06 07:15:00 | SPY | ETF | 117.21 | 117.29 | 117.13 | 117.23 | 40290.0 |
| 2010-05-06 07:20:00 | SPY | ETF | 117.28 | 117.28 | 117.24 | 117.24 | 4400.0 |
| 2010-05-06 07:25:00 | SPY | ETF | 117.26 | 117.29 | 117.14 | 117.24 | 42800.0 |
| 2010-05-06 07:30:00 | SPY | ETF | 117.18 | 117.26 | 117.13 | 117.15 | 107600.0 |
| 2010-05-06 07:35:00 | SPY | ETF | 117.15 | 117.23 | 117.14 | 117.14 | 54099.0 |
| 2010-05-06 07:40:00 | SPY | ETF | 117.15 | 117.15 | 117.03 | 117.1 | 36604.0 |
| 2010-05-06 07:45:00 | SPY | ETF | 117.1 | 117.1 | 116.75 | 116.88 | 306805.0 |
| 2010-05-06 07:50:00 | SPY | ETF | 116.88 | 117.05 | 116.88 | 117.04 | 126175.0 |
| 2010-05-06 07:55:00 | SPY | ETF | 117.02 | 117.02 | 116.79 | 116.79 | 161810.0 |
| 2010-05-06 08:00:00 | SPY | ETF | 116.8 | 116.99 | 116.78 | 116.97 | 129822.0 |
| 2010-05-06 08:05:00 | SPY | ETF | 116.97 | 116.97 | 116.65 | 116.88 | 211964.0 |
| 2010-05-06 08:10:00 | SPY | ETF | 116.89 | 116.89 | 116.7 | 116.74 | 184779.0 |
| 2010-05-06 08:15:00 | SPY | ETF | 116.74 | 116.76 | 116.6 | 116.6 | 824746.0 |
| 2010-05-06 08:20:00 | SPY | ETF | 116.6 | 116.62 | 116.51 | 116.62 | 499800.0 |
| 2010-05-06 08:25:00 | SPY | ETF | 116.63 | 116.86 | 116.6 | 116.84 | 1165213.0 |
| 2010-05-06 08:30:00 | SPY | ETF | 116.8 | 116.97 | 116.69 | 116.7 | 587576.0 |
| 2010-05-06 08:35:00 | SPY | ETF | 116.71 | 116.82 | 116.64 | 116.76 | 432421.0 |
| 2010-05-06 08:40:00 | SPY | ETF | 116.75 | 116.75 | 116.39 | 116.39 | 774913.0 |
| 2010-05-06 08:45:00 | SPY | ETF | 116.38 | 116.58 | 116.3 | 116.55 | 1786947.0 |
| 2010-05-06 08:50:00 | SPY | ETF | 116.54 | 116.59 | 116.13 | 116.21 | 1557177.0 |
| 2010-05-06 08:55:00 | SPY | ETF | 116.21 | 117.32 | 116.06 | 116.12 | 843499.0 |
| 2010-05-06 09:00:00 | SPY | ETF | 116.11 | 116.39 | 116.11 | 116.3 | 529404.0 |
| 2010-05-06 09:05:00 | SPY | ETF | 116.32 | 116.62 | 116.32 | 116.34 | 611620.0 |
| 2010-05-06 09:10:00 | SPY | ETF | 116.34 | 116.4 | 116.08 | 116.17 | 830940.0 |
| 2010-05-06 09:15:00 | SPY | ETF | 116.17 | 116.3 | 116.05 | 116.07 | 602242.0 |
| 2010-05-06 09:20:00 | SPY | ETF | 116.07 | 116.4 | 116.02 | 116.38 | 539241.0 |
| 2010-05-06 09:25:00 | SPY | ETF | 116.37 | 116.4 | 116.22 | 116.25 | 728818.0 |
| 2010-05-06 09:30:00 | SPY | ETF | 116.26 | 116.5 | 116.25 | 116.42 | 7187270.0 |
> showing 50 of 41,161 rows — these rows as CSV