PREVIEW / etf_5min / 2010-08-19
file: by_date/etf_5min/2010/2010-08-19.parquet size: 789 KB rows: 32,439
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-08-19 04:00:00 | SPY | ETF | 109.13 | 109.17 | 109.11 | 109.17 | 3489.0 |
| 2010-08-19 04:05:00 | SPY | ETF | 109.22 | 109.22 | 109.22 | 109.22 | 2100.0 |
| 2010-08-19 04:10:00 | SPY | ETF | 109.24 | 109.24 | 109.24 | 109.24 | 200.0 |
| 2010-08-19 04:15:00 | SPY | ETF | 109.27 | 109.29 | 109.27 | 109.29 | 300.0 |
| 2010-08-19 04:20:00 | SPY | ETF | 109.26 | 109.26 | 109.12 | 109.12 | 200.0 |
| 2010-08-19 04:30:00 | SPY | ETF | 109.31 | 109.31 | 109.31 | 109.31 | 100.0 |
| 2010-08-19 04:50:00 | SPY | ETF | 109.29 | 109.29 | 109.29 | 109.29 | 200.0 |
| 2010-08-19 04:55:00 | SPY | ETF | 109.3 | 109.3 | 109.3 | 109.3 | 300.0 |
| 2010-08-19 05:00:00 | SPY | ETF | 109.36 | 109.36 | 109.36 | 109.36 | 1500.0 |
| 2010-08-19 05:10:00 | SPY | ETF | 109.39 | 109.44 | 109.39 | 109.44 | 1370.0 |
| 2010-08-19 05:15:00 | SPY | ETF | 109.39 | 109.39 | 109.39 | 109.39 | 300.0 |
| 2010-08-19 05:20:00 | SPY | ETF | 109.39 | 109.39 | 109.39 | 109.39 | 2100.0 |
| 2010-08-19 05:50:00 | SPY | ETF | 109.44 | 109.44 | 109.44 | 109.44 | 200.0 |
| 2010-08-19 06:00:00 | SPY | ETF | 109.43 | 109.61 | 109.43 | 109.61 | 2400.0 |
| 2010-08-19 06:05:00 | SPY | ETF | 109.66 | 109.74 | 109.66 | 109.73 | 3188.0 |
| 2010-08-19 06:10:00 | SPY | ETF | 109.74 | 109.85 | 109.74 | 109.85 | 1900.0 |
| 2010-08-19 06:15:00 | SPY | ETF | 109.77 | 109.77 | 109.77 | 109.77 | 100.0 |
| 2010-08-19 06:20:00 | SPY | ETF | 109.77 | 109.77 | 109.73 | 109.73 | 5400.0 |
| 2010-08-19 06:25:00 | SPY | ETF | 109.85 | 109.85 | 109.79 | 109.79 | 12750.0 |
| 2010-08-19 06:35:00 | SPY | ETF | 109.79 | 109.81 | 109.79 | 109.81 | 1400.0 |
| 2010-08-19 06:40:00 | SPY | ETF | 109.8 | 109.8 | 109.77 | 109.77 | 2250.0 |
| 2010-08-19 06:45:00 | SPY | ETF | 109.74 | 109.74 | 109.7 | 109.7 | 11500.0 |
| 2010-08-19 06:50:00 | SPY | ETF | 109.7 | 109.75 | 109.7 | 109.75 | 5400.0 |
| 2010-08-19 06:55:00 | SPY | ETF | 109.77 | 109.77 | 109.77 | 109.77 | 1025.0 |
| 2010-08-19 07:00:00 | SPY | ETF | 109.76 | 109.8 | 109.73 | 109.77 | 10047.0 |
| 2010-08-19 07:05:00 | SPY | ETF | 109.76 | 109.77 | 109.73 | 109.76 | 16200.0 |
| 2010-08-19 07:10:00 | SPY | ETF | 109.76 | 109.77 | 109.71 | 109.76 | 55600.0 |
| 2010-08-19 07:15:00 | SPY | ETF | 109.75 | 109.79 | 109.74 | 109.78 | 10400.0 |
| 2010-08-19 07:20:00 | SPY | ETF | 109.79 | 109.79 | 109.73 | 109.73 | 12900.0 |
| 2010-08-19 07:25:00 | SPY | ETF | 109.73 | 109.73 | 109.66 | 109.67 | 23077.0 |
| 2010-08-19 07:30:00 | SPY | ETF | 109.66 | 109.68 | 109.61 | 109.63 | 19713.0 |
| 2010-08-19 07:35:00 | SPY | ETF | 109.64 | 109.64 | 109.61 | 109.62 | 8520.0 |
| 2010-08-19 07:40:00 | SPY | ETF | 109.61 | 109.65 | 109.61 | 109.64 | 28880.0 |
| 2010-08-19 07:45:00 | SPY | ETF | 109.65 | 109.69 | 109.63 | 109.66 | 11663.0 |
| 2010-08-19 07:50:00 | SPY | ETF | 109.68 | 109.73 | 109.66 | 109.72 | 355745.0 |
| 2010-08-19 07:55:00 | SPY | ETF | 109.7 | 109.76 | 109.69 | 109.76 | 219871.0 |
| 2010-08-19 08:00:00 | SPY | ETF | 109.73 | 109.8 | 109.64 | 109.79 | 868986.0 |
| 2010-08-19 08:05:00 | SPY | ETF | 109.79 | 109.79 | 109.73 | 109.77 | 960845.0 |
| 2010-08-19 08:10:00 | SPY | ETF | 109.76 | 109.83 | 109.76 | 109.8 | 106399.0 |
| 2010-08-19 08:15:00 | SPY | ETF | 109.8 | 109.84 | 109.77 | 109.84 | 117273.0 |
| 2010-08-19 08:20:00 | SPY | ETF | 109.85 | 109.97 | 109.83 | 109.89 | 529225.0 |
| 2010-08-19 08:25:00 | SPY | ETF | 109.89 | 110.0 | 109.76 | 109.85 | 183976.0 |
| 2010-08-19 08:30:00 | SPY | ETF | 109.79 | 109.93 | 108.92 | 108.96 | 3568231.0 |
| 2010-08-19 08:35:00 | SPY | ETF | 108.96 | 109.24 | 108.94 | 109.11 | 1900426.0 |
| 2010-08-19 08:40:00 | SPY | ETF | 109.11 | 109.14 | 108.87 | 108.97 | 1656732.0 |
| 2010-08-19 08:45:00 | SPY | ETF | 108.98 | 109.11 | 108.97 | 109.09 | 2016155.0 |
| 2010-08-19 08:50:00 | SPY | ETF | 109.1 | 109.15 | 109.07 | 109.12 | 736235.0 |
| 2010-08-19 08:55:00 | SPY | ETF | 109.12 | 109.23 | 109.08 | 109.23 | 1690307.0 |
| 2010-08-19 09:00:00 | SPY | ETF | 109.22 | 109.34 | 109.2 | 109.33 | 677861.0 |
| 2010-08-19 09:05:00 | SPY | ETF | 109.32 | 109.33 | 109.25 | 109.27 | 148067.0 |
> showing 50 of 32,439 rows — these rows as CSV