PREVIEW / etf_5min / 2010-02-10
file: by_date/etf_5min/2010/2010-02-10.parquet size: 757 KB rows: 31,504
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-02-10 04:05:00 | SPY | ETF | 106.93 | 106.93 | 106.93 | 106.93 | 2000.0 |
| 2010-02-10 04:15:00 | SPY | ETF | 106.89 | 106.89 | 106.83 | 106.83 | 200.0 |
| 2010-02-10 04:40:00 | SPY | ETF | 106.95 | 106.95 | 106.95 | 106.95 | 300.0 |
| 2010-02-10 04:45:00 | SPY | ETF | 106.98 | 107.06 | 106.98 | 107.06 | 1700.0 |
| 2010-02-10 04:50:00 | SPY | ETF | 107.04 | 107.04 | 107.04 | 107.04 | 2500.0 |
| 2010-02-10 04:55:00 | SPY | ETF | 107.11 | 107.11 | 107.11 | 107.11 | 400.0 |
| 2010-02-10 05:00:00 | SPY | ETF | 107.12 | 107.12 | 107.12 | 107.12 | 400.0 |
| 2010-02-10 05:05:00 | SPY | ETF | 107.14 | 107.39 | 107.14 | 107.38 | 3400.0 |
| 2010-02-10 05:10:00 | SPY | ETF | 107.37 | 107.56 | 107.37 | 107.56 | 17700.0 |
| 2010-02-10 05:15:00 | SPY | ETF | 107.3 | 107.33 | 107.26 | 107.33 | 2371.0 |
| 2010-02-10 05:20:00 | SPY | ETF | 107.33 | 107.33 | 107.33 | 107.33 | 200.0 |
| 2010-02-10 05:30:00 | SPY | ETF | 107.31 | 107.39 | 107.28 | 107.39 | 1000.0 |
| 2010-02-10 05:45:00 | SPY | ETF | 107.54 | 107.54 | 107.54 | 107.54 | 5000.0 |
| 2010-02-10 05:50:00 | SPY | ETF | 107.69 | 107.69 | 107.69 | 107.69 | 25000.0 |
| 2010-02-10 05:55:00 | SPY | ETF | 107.61 | 107.61 | 107.61 | 107.61 | 25000.0 |
| 2010-02-10 06:00:00 | SPY | ETF | 107.48 | 107.48 | 107.48 | 107.48 | 100.0 |
| 2010-02-10 06:10:00 | SPY | ETF | 107.51 | 107.51 | 107.51 | 107.51 | 700.0 |
| 2010-02-10 06:15:00 | SPY | ETF | 107.56 | 107.56 | 107.56 | 107.56 | 100.0 |
| 2010-02-10 06:20:00 | SPY | ETF | 107.5 | 107.5 | 107.5 | 107.5 | 500.0 |
| 2010-02-10 06:25:00 | SPY | ETF | 107.44 | 107.44 | 107.4 | 107.4 | 1200.0 |
| 2010-02-10 06:30:00 | SPY | ETF | 107.42 | 107.42 | 107.42 | 107.42 | 200.0 |
| 2010-02-10 06:35:00 | SPY | ETF | 107.41 | 107.41 | 107.41 | 107.41 | 20000.0 |
| 2010-02-10 06:40:00 | SPY | ETF | 107.41 | 107.41 | 107.41 | 107.41 | 5000.0 |
| 2010-02-10 06:45:00 | SPY | ETF | 107.42 | 107.43 | 107.42 | 107.43 | 270.0 |
| 2010-02-10 06:50:00 | SPY | ETF | 107.44 | 107.55 | 107.43 | 107.55 | 22430.0 |
| 2010-02-10 06:55:00 | SPY | ETF | 107.55 | 107.6 | 107.5 | 107.54 | 39900.0 |
| 2010-02-10 07:00:00 | SPY | ETF | 107.49 | 107.49 | 107.42 | 107.44 | 4581.0 |
| 2010-02-10 07:05:00 | SPY | ETF | 107.36 | 107.36 | 107.3 | 107.34 | 53637.0 |
| 2010-02-10 07:10:00 | SPY | ETF | 107.3 | 107.39 | 107.3 | 107.39 | 13805.0 |
| 2010-02-10 07:15:00 | SPY | ETF | 107.4 | 107.44 | 107.4 | 107.43 | 9225.0 |
| 2010-02-10 07:20:00 | SPY | ETF | 107.42 | 107.43 | 107.39 | 107.39 | 3910.0 |
| 2010-02-10 07:25:00 | SPY | ETF | 107.39 | 107.39 | 107.35 | 107.37 | 14100.0 |
| 2010-02-10 07:30:00 | SPY | ETF | 107.4 | 107.41 | 107.4 | 107.41 | 105800.0 |
| 2010-02-10 07:35:00 | SPY | ETF | 107.42 | 107.51 | 107.42 | 107.46 | 179749.0 |
| 2010-02-10 07:40:00 | SPY | ETF | 107.47 | 107.75 | 107.46 | 107.65 | 310046.0 |
| 2010-02-10 07:45:00 | SPY | ETF | 107.65 | 107.66 | 107.53 | 107.54 | 107271.0 |
| 2010-02-10 07:50:00 | SPY | ETF | 107.55 | 107.55 | 107.39 | 107.46 | 411711.0 |
| 2010-02-10 07:55:00 | SPY | ETF | 107.46 | 107.46 | 107.1 | 107.15 | 414722.0 |
| 2010-02-10 08:00:00 | SPY | ETF | 107.53 | 107.53 | 107.12 | 107.23 | 1066570.0 |
| 2010-02-10 08:05:00 | SPY | ETF | 107.21 | 107.27 | 107.06 | 107.09 | 666669.0 |
| 2010-02-10 08:10:00 | SPY | ETF | 107.1 | 107.16 | 106.99 | 106.99 | 682784.0 |
| 2010-02-10 08:15:00 | SPY | ETF | 107.0 | 107.2 | 106.96 | 107.14 | 661809.0 |
| 2010-02-10 08:20:00 | SPY | ETF | 107.13 | 107.26 | 107.12 | 107.25 | 403454.0 |
| 2010-02-10 08:25:00 | SPY | ETF | 107.24 | 107.28 | 107.18 | 107.21 | 605760.0 |
| 2010-02-10 08:30:00 | SPY | ETF | 107.23 | 107.26 | 106.97 | 107.05 | 512821.0 |
| 2010-02-10 08:35:00 | SPY | ETF | 107.05 | 107.21 | 106.98 | 107.18 | 361376.0 |
| 2010-02-10 08:40:00 | SPY | ETF | 107.18 | 107.18 | 107.06 | 107.12 | 373440.0 |
| 2010-02-10 08:45:00 | SPY | ETF | 107.1 | 107.13 | 107.0 | 107.02 | 210016.0 |
| 2010-02-10 08:50:00 | SPY | ETF | 107.03 | 107.13 | 107.01 | 107.12 | 326705.0 |
| 2010-02-10 08:55:00 | SPY | ETF | 107.13 | 107.23 | 107.11 | 107.15 | 479216.0 |
> showing 50 of 31,504 rows — these rows as CSV