PREVIEW / etf_5min / 2010-05-27
file: by_date/etf_5min/2010/2010-05-27.parquet size: 863 KB rows: 36,114
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-27 04:10:00 | SPY | ETF | 108.62 | 108.62 | 108.62 | 108.62 | 12500.0 |
| 2010-05-27 04:15:00 | SPY | ETF | 108.65 | 108.68 | 108.58 | 108.58 | 4314.0 |
| 2010-05-27 04:20:00 | SPY | ETF | 108.5 | 108.5 | 108.47 | 108.47 | 2422.0 |
| 2010-05-27 04:25:00 | SPY | ETF | 108.45 | 108.47 | 108.44 | 108.44 | 2200.0 |
| 2010-05-27 04:30:00 | SPY | ETF | 108.55 | 108.67 | 108.55 | 108.67 | 12700.0 |
| 2010-05-27 04:40:00 | SPY | ETF | 108.57 | 108.67 | 108.54 | 108.67 | 1000.0 |
| 2010-05-27 04:45:00 | SPY | ETF | 108.7 | 108.73 | 108.67 | 108.67 | 360.0 |
| 2010-05-27 04:50:00 | SPY | ETF | 108.69 | 108.8 | 108.69 | 108.8 | 23743.0 |
| 2010-05-27 04:55:00 | SPY | ETF | 108.73 | 108.75 | 108.72 | 108.75 | 10000.0 |
| 2010-05-27 05:00:00 | SPY | ETF | 108.81 | 108.86 | 108.81 | 108.86 | 600.0 |
| 2010-05-27 05:05:00 | SPY | ETF | 108.88 | 108.93 | 108.88 | 108.88 | 10200.0 |
| 2010-05-27 05:10:00 | SPY | ETF | 108.9 | 108.92 | 108.88 | 108.92 | 10100.0 |
| 2010-05-27 05:15:00 | SPY | ETF | 108.86 | 109.21 | 108.86 | 109.21 | 7600.0 |
| 2010-05-27 05:20:00 | SPY | ETF | 109.2 | 109.22 | 109.2 | 109.22 | 1138.0 |
| 2010-05-27 05:25:00 | SPY | ETF | 109.13 | 109.2 | 109.13 | 109.19 | 6811.0 |
| 2010-05-27 05:30:00 | SPY | ETF | 109.22 | 109.26 | 109.17 | 109.23 | 9100.0 |
| 2010-05-27 05:35:00 | SPY | ETF | 109.21 | 109.23 | 109.21 | 109.23 | 2100.0 |
| 2010-05-27 05:40:00 | SPY | ETF | 109.24 | 109.24 | 109.19 | 109.19 | 1200.0 |
| 2010-05-27 05:45:00 | SPY | ETF | 109.23 | 109.23 | 109.2 | 109.2 | 500.0 |
| 2010-05-27 05:50:00 | SPY | ETF | 109.17 | 109.26 | 109.14 | 109.26 | 26000.0 |
| 2010-05-27 05:55:00 | SPY | ETF | 109.3 | 109.46 | 109.25 | 109.46 | 30800.0 |
| 2010-05-27 06:00:00 | SPY | ETF | 109.42 | 109.48 | 109.37 | 109.37 | 27553.0 |
| 2010-05-27 06:05:00 | SPY | ETF | 109.38 | 109.6 | 109.38 | 109.6 | 1300.0 |
| 2010-05-27 06:10:00 | SPY | ETF | 109.65 | 109.65 | 109.55 | 109.6 | 29933.0 |
| 2010-05-27 06:15:00 | SPY | ETF | 109.49 | 109.58 | 109.36 | 109.38 | 80930.0 |
| 2010-05-27 06:20:00 | SPY | ETF | 109.39 | 109.39 | 109.35 | 109.37 | 32729.0 |
| 2010-05-27 06:25:00 | SPY | ETF | 109.37 | 109.54 | 109.37 | 109.46 | 76775.0 |
| 2010-05-27 06:30:00 | SPY | ETF | 109.49 | 109.49 | 109.39 | 109.49 | 1850.0 |
| 2010-05-27 06:35:00 | SPY | ETF | 109.48 | 109.48 | 109.34 | 109.34 | 27201.0 |
| 2010-05-27 06:40:00 | SPY | ETF | 109.36 | 109.37 | 109.19 | 109.23 | 111650.0 |
| 2010-05-27 06:45:00 | SPY | ETF | 109.27 | 109.37 | 109.24 | 109.25 | 23000.0 |
| 2010-05-27 06:50:00 | SPY | ETF | 109.3 | 109.36 | 109.3 | 109.35 | 18700.0 |
| 2010-05-27 06:55:00 | SPY | ETF | 109.32 | 109.33 | 109.24 | 109.26 | 43400.0 |
| 2010-05-27 07:00:00 | SPY | ETF | 109.25 | 109.26 | 109.2 | 109.25 | 218629.0 |
| 2010-05-27 07:05:00 | SPY | ETF | 109.29 | 109.29 | 109.1 | 109.12 | 172436.0 |
| 2010-05-27 07:10:00 | SPY | ETF | 109.13 | 109.18 | 109.02 | 109.04 | 644818.0 |
| 2010-05-27 07:15:00 | SPY | ETF | 109.07 | 109.19 | 109.06 | 109.18 | 420587.0 |
| 2010-05-27 07:20:00 | SPY | ETF | 109.17 | 109.17 | 109.04 | 109.11 | 49125.0 |
| 2010-05-27 07:25:00 | SPY | ETF | 109.11 | 109.11 | 109.01 | 109.04 | 129601.0 |
| 2010-05-27 07:30:00 | SPY | ETF | 109.04 | 109.08 | 108.95 | 108.95 | 59772.0 |
| 2010-05-27 07:35:00 | SPY | ETF | 108.95 | 109.07 | 108.95 | 109.03 | 122600.0 |
| 2010-05-27 07:40:00 | SPY | ETF | 109.05 | 109.19 | 109.02 | 109.15 | 145841.0 |
| 2010-05-27 07:45:00 | SPY | ETF | 109.15 | 109.19 | 109.04 | 109.07 | 220831.0 |
| 2010-05-27 07:50:00 | SPY | ETF | 109.07 | 109.11 | 109.0 | 109.07 | 266303.0 |
| 2010-05-27 07:55:00 | SPY | ETF | 109.08 | 109.11 | 109.02 | 109.04 | 129756.0 |
| 2010-05-27 08:00:00 | SPY | ETF | 109.04 | 109.37 | 108.89 | 108.93 | 1036918.0 |
| 2010-05-27 08:05:00 | SPY | ETF | 108.92 | 109.15 | 108.92 | 108.96 | 329888.0 |
| 2010-05-27 08:10:00 | SPY | ETF | 108.97 | 109.05 | 108.87 | 108.97 | 207164.0 |
| 2010-05-27 08:15:00 | SPY | ETF | 108.97 | 109.05 | 108.92 | 109.0 | 150923.0 |
| 2010-05-27 08:20:00 | SPY | ETF | 109.0 | 109.15 | 109.0 | 109.14 | 442801.0 |
> showing 50 of 36,114 rows — these rows as CSV