PREVIEW / etf_5min / 2009-05-15
file: by_date/etf_5min/2009/2009-05-15.parquet size: 662 KB rows: 28,826
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-05-15 04:25:00 | SPY | ETF | 89.5 | 89.54 | 89.5 | 89.53 | 3400.0 |
| 2009-05-15 04:35:00 | SPY | ETF | 89.5 | 89.5 | 89.5 | 89.5 | 600.0 |
| 2009-05-15 04:45:00 | SPY | ETF | 89.39 | 89.39 | 89.39 | 89.39 | 100.0 |
| 2009-05-15 05:10:00 | SPY | ETF | 89.54 | 89.54 | 89.54 | 89.54 | 200.0 |
| 2009-05-15 05:15:00 | SPY | ETF | 89.48 | 89.48 | 89.48 | 89.48 | 5000.0 |
| 2009-05-15 05:20:00 | SPY | ETF | 89.51 | 89.62 | 89.51 | 89.62 | 5300.0 |
| 2009-05-15 05:25:00 | SPY | ETF | 89.53 | 89.53 | 89.53 | 89.53 | 5000.0 |
| 2009-05-15 05:30:00 | SPY | ETF | 89.43 | 89.43 | 89.43 | 89.43 | 5000.0 |
| 2009-05-15 05:40:00 | SPY | ETF | 89.54 | 89.58 | 89.54 | 89.58 | 711.0 |
| 2009-05-15 05:55:00 | SPY | ETF | 89.44 | 89.44 | 89.44 | 89.44 | 200.0 |
| 2009-05-15 06:00:00 | SPY | ETF | 89.44 | 89.44 | 89.36 | 89.39 | 2400.0 |
| 2009-05-15 06:05:00 | SPY | ETF | 89.3 | 89.3 | 89.29 | 89.29 | 11000.0 |
| 2009-05-15 06:10:00 | SPY | ETF | 89.27 | 89.28 | 89.23 | 89.28 | 10100.0 |
| 2009-05-15 06:15:00 | SPY | ETF | 89.15 | 89.19 | 89.15 | 89.19 | 14000.0 |
| 2009-05-15 06:20:00 | SPY | ETF | 89.15 | 89.15 | 89.11 | 89.11 | 2700.0 |
| 2009-05-15 06:25:00 | SPY | ETF | 89.12 | 89.12 | 89.12 | 89.12 | 100.0 |
| 2009-05-15 06:30:00 | SPY | ETF | 89.14 | 89.15 | 89.14 | 89.15 | 20200.0 |
| 2009-05-15 06:45:00 | SPY | ETF | 89.12 | 89.16 | 89.08 | 89.08 | 6300.0 |
| 2009-05-15 06:50:00 | SPY | ETF | 89.12 | 89.12 | 89.04 | 89.04 | 5365.0 |
| 2009-05-15 06:55:00 | SPY | ETF | 89.03 | 89.1 | 89.03 | 89.1 | 1000.0 |
| 2009-05-15 07:00:00 | SPY | ETF | 89.04 | 89.06 | 88.95 | 88.99 | 324031.0 |
| 2009-05-15 07:05:00 | SPY | ETF | 88.95 | 88.95 | 88.81 | 88.85 | 26400.0 |
| 2009-05-15 07:10:00 | SPY | ETF | 88.84 | 88.87 | 88.79 | 88.87 | 87115.0 |
| 2009-05-15 07:15:00 | SPY | ETF | 88.83 | 88.83 | 88.68 | 88.72 | 600686.0 |
| 2009-05-15 07:20:00 | SPY | ETF | 88.71 | 88.85 | 88.71 | 88.77 | 431606.0 |
| 2009-05-15 07:25:00 | SPY | ETF | 88.77 | 88.87 | 88.77 | 88.82 | 213950.0 |
| 2009-05-15 07:30:00 | SPY | ETF | 88.84 | 88.87 | 88.8 | 88.82 | 29702.0 |
| 2009-05-15 07:35:00 | SPY | ETF | 88.85 | 88.95 | 88.82 | 88.91 | 52002.0 |
| 2009-05-15 07:40:00 | SPY | ETF | 88.92 | 88.95 | 88.91 | 88.93 | 67950.0 |
| 2009-05-15 07:45:00 | SPY | ETF | 88.92 | 88.92 | 88.87 | 88.89 | 44930.0 |
| 2009-05-15 07:50:00 | SPY | ETF | 88.93 | 88.93 | 88.84 | 88.84 | 15580.0 |
| 2009-05-15 07:55:00 | SPY | ETF | 88.86 | 88.86 | 88.8 | 88.8 | 43441.0 |
| 2009-05-15 08:00:00 | SPY | ETF | 88.8 | 89.046 | 88.72 | 88.8 | 1206913.0 |
| 2009-05-15 08:05:00 | SPY | ETF | 88.8 | 88.85 | 88.74 | 88.82 | 85847.0 |
| 2009-05-15 08:10:00 | SPY | ETF | 88.81 | 88.97 | 88.78 | 88.95 | 1156721.0 |
| 2009-05-15 08:15:00 | SPY | ETF | 88.93 | 89.45 | 88.88 | 88.99 | 345715.0 |
| 2009-05-15 08:20:00 | SPY | ETF | 89.0 | 89.01 | 88.84 | 88.85 | 113399.0 |
| 2009-05-15 08:25:00 | SPY | ETF | 88.85 | 88.9 | 88.81 | 88.85 | 55697.0 |
| 2009-05-15 08:30:00 | SPY | ETF | 88.83 | 89.12 | 88.69 | 89.12 | 773067.0 |
| 2009-05-15 08:35:00 | SPY | ETF | 89.11 | 89.11 | 88.99 | 89.1 | 76417.0 |
| 2009-05-15 08:40:00 | SPY | ETF | 89.1 | 89.11 | 89.0 | 89.01 | 546872.0 |
| 2009-05-15 08:45:00 | SPY | ETF | 89.0 | 89.12 | 89.0 | 89.11 | 218645.0 |
| 2009-05-15 08:50:00 | SPY | ETF | 89.1 | 89.22 | 89.1 | 89.2 | 203498.0 |
| 2009-05-15 08:55:00 | SPY | ETF | 89.2 | 89.21 | 89.09 | 89.1 | 135032.0 |
| 2009-05-15 09:00:00 | SPY | ETF | 89.12 | 89.2 | 89.1 | 89.16 | 256158.0 |
| 2009-05-15 09:05:00 | SPY | ETF | 89.13 | 89.13 | 89.03 | 89.08 | 146498.0 |
| 2009-05-15 09:10:00 | SPY | ETF | 89.07 | 89.15 | 89.04 | 89.08 | 212620.0 |
| 2009-05-15 09:15:00 | SPY | ETF | 89.08 | 89.36 | 89.04 | 89.33 | 664071.0 |
| 2009-05-15 09:20:00 | SPY | ETF | 89.32 | 89.44 | 89.32 | 89.39 | 599863.0 |
| 2009-05-15 09:25:00 | SPY | ETF | 89.4 | 89.4 | 89.32 | 89.35 | 832144.0 |
> showing 50 of 28,826 rows — these rows as CSV