PREVIEW / etf_5min / 2009-11-03
file: by_date/etf_5min/2009/2009-11-03.parquet size: 758 KB rows: 31,839
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-03 04:15:00 | SPY | ETF | 103.97 | 103.99 | 103.95 | 103.95 | 1700.0 |
| 2009-11-03 04:20:00 | SPY | ETF | 103.99 | 103.99 | 103.86 | 103.86 | 281.0 |
| 2009-11-03 04:25:00 | SPY | ETF | 103.92 | 103.92 | 103.85 | 103.85 | 900.0 |
| 2009-11-03 04:30:00 | SPY | ETF | 103.83 | 103.83 | 103.76 | 103.76 | 1000.0 |
| 2009-11-03 04:40:00 | SPY | ETF | 103.7 | 103.7 | 103.56 | 103.56 | 338.0 |
| 2009-11-03 04:45:00 | SPY | ETF | 103.65 | 103.65 | 103.65 | 103.65 | 200.0 |
| 2009-11-03 04:50:00 | SPY | ETF | 103.6 | 103.6 | 103.57 | 103.57 | 300.0 |
| 2009-11-03 04:55:00 | SPY | ETF | 103.48 | 103.48 | 103.38 | 103.38 | 600.0 |
| 2009-11-03 05:00:00 | SPY | ETF | 103.33 | 103.33 | 103.28 | 103.28 | 4709.0 |
| 2009-11-03 05:05:00 | SPY | ETF | 103.35 | 103.35 | 103.35 | 103.35 | 2500.0 |
| 2009-11-03 05:10:00 | SPY | ETF | 103.41 | 103.42 | 103.41 | 103.42 | 400.0 |
| 2009-11-03 05:15:00 | SPY | ETF | 103.45 | 103.45 | 103.45 | 103.45 | 2500.0 |
| 2009-11-03 05:20:00 | SPY | ETF | 103.49 | 103.49 | 103.46 | 103.46 | 400.0 |
| 2009-11-03 05:25:00 | SPY | ETF | 103.39 | 103.4 | 103.39 | 103.4 | 200.0 |
| 2009-11-03 05:30:00 | SPY | ETF | 103.39 | 103.39 | 103.35 | 103.35 | 300.0 |
| 2009-11-03 05:35:00 | SPY | ETF | 103.4 | 103.4 | 103.4 | 103.4 | 2000.0 |
| 2009-11-03 05:40:00 | SPY | ETF | 103.49 | 103.53 | 103.49 | 103.53 | 230.0 |
| 2009-11-03 06:00:00 | SPY | ETF | 103.54 | 103.59 | 103.54 | 103.59 | 783.0 |
| 2009-11-03 06:15:00 | SPY | ETF | 103.23 | 103.25 | 103.16 | 103.25 | 1467.0 |
| 2009-11-03 06:20:00 | SPY | ETF | 103.32 | 103.34 | 103.24 | 103.24 | 19606.0 |
| 2009-11-03 06:30:00 | SPY | ETF | 103.29 | 103.29 | 103.29 | 103.29 | 606.0 |
| 2009-11-03 06:35:00 | SPY | ETF | 103.26 | 103.33 | 103.26 | 103.33 | 300.0 |
| 2009-11-03 06:40:00 | SPY | ETF | 103.33 | 103.34 | 103.33 | 103.34 | 2800.0 |
| 2009-11-03 06:45:00 | SPY | ETF | 103.31 | 103.31 | 103.29 | 103.29 | 694.0 |
| 2009-11-03 06:50:00 | SPY | ETF | 103.29 | 103.29 | 103.21 | 103.21 | 14900.0 |
| 2009-11-03 06:55:00 | SPY | ETF | 103.23 | 103.26 | 103.22 | 103.24 | 13250.0 |
| 2009-11-03 07:00:00 | SPY | ETF | 103.28 | 103.33 | 103.24 | 103.33 | 92588.0 |
| 2009-11-03 07:05:00 | SPY | ETF | 103.33 | 103.48 | 103.3 | 103.48 | 71299.0 |
| 2009-11-03 07:10:00 | SPY | ETF | 103.48 | 103.51 | 103.43 | 103.5 | 20863.0 |
| 2009-11-03 07:15:00 | SPY | ETF | 103.51 | 103.53 | 103.41 | 103.41 | 27864.0 |
| 2009-11-03 07:20:00 | SPY | ETF | 103.41 | 103.46 | 103.4 | 103.41 | 31389.0 |
| 2009-11-03 07:25:00 | SPY | ETF | 103.43 | 103.45 | 103.35 | 103.43 | 191436.0 |
| 2009-11-03 07:30:00 | SPY | ETF | 103.46 | 103.91 | 103.46 | 103.88 | 737754.0 |
| 2009-11-03 07:35:00 | SPY | ETF | 103.9 | 103.94 | 103.75 | 103.8 | 417630.0 |
| 2009-11-03 07:40:00 | SPY | ETF | 103.77 | 103.98 | 103.76 | 103.95 | 195235.0 |
| 2009-11-03 07:45:00 | SPY | ETF | 103.95 | 103.95 | 103.79 | 103.79 | 88840.0 |
| 2009-11-03 07:50:00 | SPY | ETF | 103.78 | 103.78 | 103.61 | 103.65 | 353018.0 |
| 2009-11-03 07:55:00 | SPY | ETF | 103.71 | 103.73 | 103.65 | 103.72 | 116160.0 |
| 2009-11-03 08:00:00 | SPY | ETF | 103.9 | 103.92 | 103.4 | 103.86 | 1937183.0 |
| 2009-11-03 08:05:00 | SPY | ETF | 103.88 | 103.95 | 103.78 | 103.78 | 392126.0 |
| 2009-11-03 08:10:00 | SPY | ETF | 103.78 | 103.78 | 103.66 | 103.71 | 321101.0 |
| 2009-11-03 08:15:00 | SPY | ETF | 103.71 | 103.79 | 103.69 | 103.76 | 833695.0 |
| 2009-11-03 08:20:00 | SPY | ETF | 103.75 | 103.93 | 103.75 | 103.9 | 307704.0 |
| 2009-11-03 08:25:00 | SPY | ETF | 103.9 | 104.36 | 103.89 | 103.93 | 393094.0 |
| 2009-11-03 08:30:00 | SPY | ETF | 103.94 | 103.95 | 103.76 | 103.76 | 276589.0 |
| 2009-11-03 08:35:00 | SPY | ETF | 103.75 | 103.81 | 103.7 | 103.76 | 317144.0 |
| 2009-11-03 08:40:00 | SPY | ETF | 103.74 | 103.81 | 102.49 | 103.81 | 127018.0 |
| 2009-11-03 08:45:00 | SPY | ETF | 103.81 | 103.84 | 103.73 | 103.79 | 296941.0 |
| 2009-11-03 08:50:00 | SPY | ETF | 103.79 | 103.82 | 103.73 | 103.77 | 202240.0 |
| 2009-11-03 08:55:00 | SPY | ETF | 103.76 | 103.76 | 103.56 | 103.65 | 1227507.0 |
> showing 50 of 31,839 rows — these rows as CSV