PREVIEW / etf_5min / 2009-02-27
file: by_date/etf_5min/2009/2009-02-27.parquet size: 675 KB rows: 29,633
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-02-27 04:20:00 | SPY | ETF | 75.72 | 75.72 | 75.69 | 75.69 | 1800.0 |
| 2009-02-27 04:30:00 | SPY | ETF | 75.63 | 75.63 | 75.63 | 75.63 | 100.0 |
| 2009-02-27 04:35:00 | SPY | ETF | 75.7 | 75.7 | 75.7 | 75.7 | 10000.0 |
| 2009-02-27 04:45:00 | SPY | ETF | 75.8 | 75.8 | 75.77 | 75.77 | 1100.0 |
| 2009-02-27 04:50:00 | SPY | ETF | 75.84 | 75.84 | 75.67 | 75.67 | 2100.0 |
| 2009-02-27 04:55:00 | SPY | ETF | 75.65 | 75.65 | 75.62 | 75.62 | 2000.0 |
| 2009-02-27 05:00:00 | SPY | ETF | 75.62 | 75.67 | 75.62 | 75.67 | 4000.0 |
| 2009-02-27 05:10:00 | SPY | ETF | 75.56 | 75.62 | 75.56 | 75.62 | 1100.0 |
| 2009-02-27 05:15:00 | SPY | ETF | 75.62 | 75.64 | 75.62 | 75.62 | 5000.0 |
| 2009-02-27 05:20:00 | SPY | ETF | 75.67 | 75.73 | 75.67 | 75.73 | 3000.0 |
| 2009-02-27 05:25:00 | SPY | ETF | 75.71 | 75.82 | 75.71 | 75.82 | 4000.0 |
| 2009-02-27 05:30:00 | SPY | ETF | 75.9 | 75.9 | 75.88 | 75.9 | 3000.0 |
| 2009-02-27 05:35:00 | SPY | ETF | 75.81 | 75.81 | 75.76 | 75.76 | 3868.0 |
| 2009-02-27 05:40:00 | SPY | ETF | 75.73 | 75.83 | 75.73 | 75.83 | 3000.0 |
| 2009-02-27 06:00:00 | SPY | ETF | 75.93 | 75.93 | 75.93 | 75.93 | 100.0 |
| 2009-02-27 06:05:00 | SPY | ETF | 75.88 | 75.88 | 75.88 | 75.88 | 100.0 |
| 2009-02-27 06:10:00 | SPY | ETF | 75.97 | 75.97 | 75.97 | 75.97 | 5000.0 |
| 2009-02-27 06:20:00 | SPY | ETF | 75.64 | 75.7 | 75.62 | 75.7 | 2200.0 |
| 2009-02-27 06:25:00 | SPY | ETF | 75.65 | 75.65 | 75.65 | 75.65 | 300.0 |
| 2009-02-27 06:35:00 | SPY | ETF | 75.55 | 75.55 | 75.55 | 75.55 | 2900.0 |
| 2009-02-27 06:40:00 | SPY | ETF | 75.6 | 75.6 | 75.6 | 75.6 | 500.0 |
| 2009-02-27 06:45:00 | SPY | ETF | 75.65 | 75.65 | 75.65 | 75.65 | 400.0 |
| 2009-02-27 06:50:00 | SPY | ETF | 75.61 | 75.61 | 75.45 | 75.45 | 6500.0 |
| 2009-02-27 06:55:00 | SPY | ETF | 75.39 | 75.45 | 75.35 | 75.42 | 38700.0 |
| 2009-02-27 07:00:00 | SPY | ETF | 75.45 | 75.47 | 75.23 | 75.35 | 35200.0 |
| 2009-02-27 07:05:00 | SPY | ETF | 75.28 | 75.48 | 75.28 | 75.48 | 25200.0 |
| 2009-02-27 07:10:00 | SPY | ETF | 75.45 | 75.47 | 75.16 | 75.16 | 74450.0 |
| 2009-02-27 07:15:00 | SPY | ETF | 75.21 | 75.23 | 75.13 | 75.15 | 28500.0 |
| 2009-02-27 07:20:00 | SPY | ETF | 75.14 | 75.14 | 74.8 | 74.94 | 259390.0 |
| 2009-02-27 07:25:00 | SPY | ETF | 74.91 | 74.91 | 74.4 | 74.81 | 1666975.0 |
| 2009-02-27 07:30:00 | SPY | ETF | 74.86 | 74.86 | 74.65 | 74.82 | 92300.0 |
| 2009-02-27 07:35:00 | SPY | ETF | 74.76 | 74.79 | 74.65 | 74.65 | 202039.0 |
| 2009-02-27 07:40:00 | SPY | ETF | 74.65 | 74.83 | 74.62 | 74.78 | 247336.0 |
| 2009-02-27 07:45:00 | SPY | ETF | 74.81 | 74.96 | 74.8 | 74.85 | 265489.0 |
| 2009-02-27 07:50:00 | SPY | ETF | 74.87 | 74.87 | 74.59 | 74.63 | 407493.0 |
| 2009-02-27 07:55:00 | SPY | ETF | 74.62 | 74.85 | 74.54 | 74.77 | 356580.0 |
| 2009-02-27 08:00:00 | SPY | ETF | 74.82 | 75.58 | 74.69 | 74.8 | 614197.0 |
| 2009-02-27 08:05:00 | SPY | ETF | 74.8 | 74.87 | 74.69 | 74.7 | 347758.0 |
| 2009-02-27 08:10:00 | SPY | ETF | 74.72 | 74.77 | 74.58 | 74.58 | 183514.0 |
| 2009-02-27 08:15:00 | SPY | ETF | 74.59 | 76.83 | 74.49 | 74.49 | 316872.0 |
| 2009-02-27 08:20:00 | SPY | ETF | 74.48 | 74.48 | 73.7 | 73.9 | 3716820.0 |
| 2009-02-27 08:25:00 | SPY | ETF | 73.9 | 74.14 | 73.88 | 74.08 | 847919.0 |
| 2009-02-27 08:30:00 | SPY | ETF | 74.06 | 74.06 | 73.63 | 73.64 | 3147975.0 |
| 2009-02-27 08:35:00 | SPY | ETF | 73.64 | 73.86 | 73.53 | 73.74 | 2614585.0 |
| 2009-02-27 08:40:00 | SPY | ETF | 73.77 | 74.11 | 73.73 | 73.96 | 1769709.0 |
| 2009-02-27 08:45:00 | SPY | ETF | 73.96 | 74.05 | 73.9 | 73.9 | 655371.0 |
| 2009-02-27 08:50:00 | SPY | ETF | 73.91 | 74.11 | 73.9 | 73.92 | 742996.0 |
| 2009-02-27 08:55:00 | SPY | ETF | 73.91 | 74.13 | 73.8 | 74.06 | 717128.0 |
| 2009-02-27 09:00:00 | SPY | ETF | 74.06 | 74.18 | 74.06 | 74.13 | 265024.0 |
| 2009-02-27 09:05:00 | SPY | ETF | 74.13 | 74.14 | 73.93 | 74.08 | 438718.0 |
> showing 50 of 29,633 rows — these rows as CSV