PREVIEW / etf_5min / 2010-07-06
file: by_date/etf_5min/2010/2010-07-06.parquet size: 841 KB rows: 34,019
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-07-06 04:05:00 | SPY | ETF | 102.7 | 102.7 | 102.7 | 102.7 | 200.0 |
| 2010-07-06 04:10:00 | SPY | ETF | 102.71 | 102.71 | 102.71 | 102.71 | 200.0 |
| 2010-07-06 04:15:00 | SPY | ETF | 102.75 | 102.75 | 102.72 | 102.72 | 852.0 |
| 2010-07-06 04:20:00 | SPY | ETF | 102.71 | 102.72 | 102.7 | 102.72 | 2800.0 |
| 2010-07-06 04:25:00 | SPY | ETF | 102.73 | 102.75 | 102.67 | 102.74 | 600.0 |
| 2010-07-06 04:30:00 | SPY | ETF | 102.72 | 102.72 | 102.72 | 102.72 | 1200.0 |
| 2010-07-06 04:35:00 | SPY | ETF | 102.75 | 102.82 | 102.75 | 102.82 | 2300.0 |
| 2010-07-06 04:40:00 | SPY | ETF | 102.85 | 102.85 | 102.74 | 102.77 | 592.0 |
| 2010-07-06 04:55:00 | SPY | ETF | 102.79 | 102.79 | 102.79 | 102.79 | 300.0 |
| 2010-07-06 05:20:00 | SPY | ETF | 102.83 | 102.83 | 102.83 | 102.83 | 100.0 |
| 2010-07-06 05:45:00 | SPY | ETF | 102.85 | 102.95 | 102.84 | 102.9 | 30800.0 |
| 2010-07-06 05:50:00 | SPY | ETF | 102.96 | 102.99 | 102.93 | 102.99 | 11100.0 |
| 2010-07-06 05:55:00 | SPY | ETF | 103.08 | 103.08 | 103.06 | 103.06 | 2800.0 |
| 2010-07-06 06:00:00 | SPY | ETF | 102.99 | 102.99 | 102.98 | 102.98 | 700.0 |
| 2010-07-06 06:05:00 | SPY | ETF | 102.98 | 103.01 | 102.98 | 103.0 | 3100.0 |
| 2010-07-06 06:10:00 | SPY | ETF | 103.02 | 103.08 | 103.02 | 103.08 | 1000.0 |
| 2010-07-06 06:15:00 | SPY | ETF | 103.05 | 103.05 | 102.98 | 103.05 | 2600.0 |
| 2010-07-06 06:20:00 | SPY | ETF | 103.07 | 103.11 | 103.07 | 103.11 | 3700.0 |
| 2010-07-06 06:25:00 | SPY | ETF | 103.11 | 103.19 | 103.08 | 103.19 | 11200.0 |
| 2010-07-06 06:30:00 | SPY | ETF | 103.19 | 103.2 | 103.16 | 103.19 | 5800.0 |
| 2010-07-06 06:35:00 | SPY | ETF | 103.2 | 103.22 | 103.19 | 103.21 | 28350.0 |
| 2010-07-06 06:40:00 | SPY | ETF | 103.2 | 103.21 | 103.14 | 103.14 | 89200.0 |
| 2010-07-06 06:45:00 | SPY | ETF | 103.16 | 103.18 | 103.15 | 103.17 | 47950.0 |
| 2010-07-06 06:50:00 | SPY | ETF | 103.17 | 103.22 | 103.15 | 103.21 | 25100.0 |
| 2010-07-06 06:55:00 | SPY | ETF | 103.18 | 103.2 | 103.15 | 103.18 | 23850.0 |
| 2010-07-06 07:00:00 | SPY | ETF | 103.17 | 103.2 | 103.16 | 103.17 | 62000.0 |
| 2010-07-06 07:05:00 | SPY | ETF | 103.16 | 103.16 | 103.08 | 103.11 | 19100.0 |
| 2010-07-06 07:10:00 | SPY | ETF | 103.09 | 103.13 | 103.08 | 103.13 | 93012.0 |
| 2010-07-06 07:15:00 | SPY | ETF | 103.13 | 103.2 | 103.13 | 103.13 | 47600.0 |
| 2010-07-06 07:20:00 | SPY | ETF | 103.13 | 103.13 | 103.05 | 103.05 | 130630.0 |
| 2010-07-06 07:25:00 | SPY | ETF | 103.06 | 103.1 | 103.05 | 103.1 | 20448.0 |
| 2010-07-06 07:30:00 | SPY | ETF | 103.04 | 103.04 | 103.0 | 103.02 | 44495.0 |
| 2010-07-06 07:35:00 | SPY | ETF | 103.02 | 103.03 | 103.0 | 103.02 | 61050.0 |
| 2010-07-06 07:40:00 | SPY | ETF | 103.02 | 103.02 | 102.92 | 102.92 | 183301.0 |
| 2010-07-06 07:45:00 | SPY | ETF | 102.92 | 102.99 | 102.92 | 102.96 | 212952.0 |
| 2010-07-06 07:50:00 | SPY | ETF | 102.95 | 103.01 | 102.95 | 103.01 | 104254.0 |
| 2010-07-06 07:55:00 | SPY | ETF | 102.99 | 103.03 | 102.98 | 103.03 | 64411.0 |
| 2010-07-06 08:00:00 | SPY | ETF | 103.0 | 103.1 | 101.99 | 103.08 | 810760.0 |
| 2010-07-06 08:05:00 | SPY | ETF | 103.1 | 103.12 | 103.08 | 103.1 | 117277.0 |
| 2010-07-06 08:10:00 | SPY | ETF | 103.11 | 103.19 | 103.06 | 103.19 | 186761.0 |
| 2010-07-06 08:15:00 | SPY | ETF | 103.18 | 103.28 | 103.18 | 103.2 | 122972.0 |
| 2010-07-06 08:20:00 | SPY | ETF | 103.2 | 103.35 | 103.18 | 103.33 | 127305.0 |
| 2010-07-06 08:25:00 | SPY | ETF | 103.34 | 103.38 | 101.82 | 103.28 | 404529.0 |
| 2010-07-06 08:30:00 | SPY | ETF | 103.28 | 103.34 | 101.57 | 103.26 | 224087.0 |
| 2010-07-06 08:35:00 | SPY | ETF | 103.27 | 103.32 | 103.25 | 103.3 | 139938.0 |
| 2010-07-06 08:40:00 | SPY | ETF | 103.3 | 103.38 | 103.3 | 103.38 | 662820.0 |
| 2010-07-06 08:45:00 | SPY | ETF | 103.38 | 103.43 | 103.36 | 103.41 | 744314.0 |
| 2010-07-06 08:50:00 | SPY | ETF | 103.42 | 103.43 | 103.39 | 103.41 | 189595.0 |
| 2010-07-06 08:55:00 | SPY | ETF | 103.41 | 103.46 | 103.1004 | 103.42 | 225745.0 |
| 2010-07-06 09:00:00 | SPY | ETF | 103.42 | 103.44 | 103.4 | 103.44 | 101654.0 |
> showing 50 of 34,019 rows — these rows as CSV