PREVIEW / etf_5min / 2009-02-12
file: by_date/etf_5min/2009/2009-02-12.parquet size: 664 KB rows: 28,945
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-12 04:15:00 | SPY | ETF | 82.75 | 82.75 | 82.75 | 82.75 | 100.0 |
| 2009-02-12 04:20:00 | SPY | ETF | 82.75 | 82.75 | 82.75 | 82.75 | 100.0 |
| 2009-02-12 04:30:00 | SPY | ETF | 82.82 | 82.82 | 82.82 | 82.82 | 200.0 |
| 2009-02-12 04:35:00 | SPY | ETF | 82.92 | 82.92 | 82.92 | 82.92 | 100.0 |
| 2009-02-12 04:55:00 | SPY | ETF | 82.8 | 82.8 | 82.8 | 82.8 | 5000.0 |
| 2009-02-12 05:00:00 | SPY | ETF | 82.74 | 82.74 | 82.74 | 82.74 | 5000.0 |
| 2009-02-12 05:10:00 | SPY | ETF | 82.84 | 82.84 | 82.68 | 82.7 | 13500.0 |
| 2009-02-12 05:15:00 | SPY | ETF | 82.64 | 82.65 | 82.64 | 82.65 | 200.0 |
| 2009-02-12 05:20:00 | SPY | ETF | 82.62 | 82.64 | 82.62 | 82.64 | 4950.0 |
| 2009-02-12 05:25:00 | SPY | ETF | 82.71 | 82.71 | 82.65 | 82.65 | 5100.0 |
| 2009-02-12 05:30:00 | SPY | ETF | 82.62 | 82.62 | 82.51 | 82.51 | 10200.0 |
| 2009-02-12 05:35:00 | SPY | ETF | 82.51 | 82.6 | 82.51 | 82.6 | 9800.0 |
| 2009-02-12 05:55:00 | SPY | ETF | 82.57 | 82.62 | 82.57 | 82.6 | 585.0 |
| 2009-02-12 06:00:00 | SPY | ETF | 82.5 | 82.55 | 82.5 | 82.55 | 4866.0 |
| 2009-02-12 06:10:00 | SPY | ETF | 82.69 | 82.69 | 82.69 | 82.69 | 300.0 |
| 2009-02-12 06:15:00 | SPY | ETF | 82.66 | 82.66 | 82.66 | 82.66 | 1000.0 |
| 2009-02-12 06:20:00 | SPY | ETF | 82.64 | 82.64 | 82.63 | 82.63 | 4500.0 |
| 2009-02-12 06:30:00 | SPY | ETF | 82.8 | 82.8 | 82.8 | 82.8 | 1600.0 |
| 2009-02-12 06:35:00 | SPY | ETF | 82.82 | 82.88 | 82.82 | 82.88 | 300.0 |
| 2009-02-12 06:40:00 | SPY | ETF | 82.9 | 82.9 | 82.79 | 82.79 | 800.0 |
| 2009-02-12 06:45:00 | SPY | ETF | 82.88 | 82.88 | 82.77 | 82.77 | 3400.0 |
| 2009-02-12 06:50:00 | SPY | ETF | 82.74 | 82.74 | 82.69 | 82.69 | 1600.0 |
| 2009-02-12 06:55:00 | SPY | ETF | 82.65 | 82.75 | 82.65 | 82.75 | 30400.0 |
| 2009-02-12 07:00:00 | SPY | ETF | 82.72 | 82.83 | 82.71 | 82.83 | 44075.0 |
| 2009-02-12 07:05:00 | SPY | ETF | 82.79 | 82.92 | 82.71 | 82.9 | 18975.0 |
| 2009-02-12 07:10:00 | SPY | ETF | 82.9 | 82.9 | 82.81 | 82.85 | 330808.0 |
| 2009-02-12 07:15:00 | SPY | ETF | 82.85 | 82.91 | 82.85 | 82.85 | 70000.0 |
| 2009-02-12 07:20:00 | SPY | ETF | 82.85 | 82.86 | 82.84 | 82.85 | 156880.0 |
| 2009-02-12 07:25:00 | SPY | ETF | 82.87 | 82.91 | 82.85 | 82.91 | 27100.0 |
| 2009-02-12 07:30:00 | SPY | ETF | 82.85 | 82.91 | 82.79 | 82.84 | 128884.0 |
| 2009-02-12 07:35:00 | SPY | ETF | 82.81 | 82.92 | 82.81 | 82.88 | 14200.0 |
| 2009-02-12 07:40:00 | SPY | ETF | 82.86 | 82.91 | 82.85 | 82.85 | 5400.0 |
| 2009-02-12 07:45:00 | SPY | ETF | 82.86 | 82.87 | 82.85 | 82.86 | 31250.0 |
| 2009-02-12 07:50:00 | SPY | ETF | 82.85 | 82.86 | 82.85 | 82.85 | 33100.0 |
| 2009-02-12 07:55:00 | SPY | ETF | 82.85 | 82.86 | 82.58 | 82.6 | 123026.0 |
| 2009-02-12 08:00:00 | SPY | ETF | 82.85 | 82.85 | 82.58 | 82.69 | 1437424.0 |
| 2009-02-12 08:05:00 | SPY | ETF | 82.7 | 82.75 | 82.56 | 82.56 | 351156.0 |
| 2009-02-12 08:10:00 | SPY | ETF | 82.56 | 82.64 | 82.51 | 82.63 | 246003.0 |
| 2009-02-12 08:15:00 | SPY | ETF | 82.6 | 82.7 | 82.5 | 82.51 | 130510.0 |
| 2009-02-12 08:20:00 | SPY | ETF | 82.51 | 82.68 | 82.47 | 82.67 | 314650.0 |
| 2009-02-12 08:25:00 | SPY | ETF | 82.65 | 82.72 | 82.59 | 82.65 | 272026.0 |
| 2009-02-12 08:30:00 | SPY | ETF | 82.65 | 83.05 | 82.65 | 82.98 | 2009236.0 |
| 2009-02-12 08:35:00 | SPY | ETF | 82.98 | 82.99 | 82.76 | 82.87 | 442895.0 |
| 2009-02-12 08:40:00 | SPY | ETF | 82.87 | 82.97 | 82.79 | 82.92 | 182012.0 |
| 2009-02-12 08:45:00 | SPY | ETF | 82.92 | 82.98 | 82.82 | 82.84 | 204276.0 |
| 2009-02-12 08:50:00 | SPY | ETF | 82.84 | 82.85 | 82.71 | 82.84 | 367536.0 |
| 2009-02-12 08:55:00 | SPY | ETF | 82.86 | 82.89 | 82.77 | 82.77 | 117480.0 |
| 2009-02-12 09:00:00 | SPY | ETF | 82.81 | 82.81 | 82.54 | 82.72 | 352060.0 |
| 2009-02-12 09:05:00 | SPY | ETF | 82.72 | 82.72 | 82.28 | 82.4 | 996800.0 |
| 2009-02-12 09:10:00 | SPY | ETF | 82.4 | 82.45 | 82.22 | 82.24 | 666348.0 |
> showing 50 of 28,945 rows — these rows as CSV