PREVIEW / etf_5min / 2008-06-02
file: by_date/etf_5min/2008/2008-06-02.parquet size: 488 KB rows: 22,532
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-02 04:05:00 | SPY | ETF | 139.71 | 139.71 | 139.68 | 139.68 | 3500.0 |
| 2008-06-02 04:10:00 | SPY | ETF | 139.68 | 139.68 | 139.68 | 139.68 | 1000.0 |
| 2008-06-02 04:15:00 | SPY | ETF | 139.59 | 139.6 | 139.5 | 139.51 | 16050.0 |
| 2008-06-02 04:30:00 | SPY | ETF | 139.51 | 139.51 | 139.51 | 139.51 | 600.0 |
| 2008-06-02 04:45:00 | SPY | ETF | 139.42 | 139.42 | 139.42 | 139.42 | 300.0 |
| 2008-06-02 06:10:00 | SPY | ETF | 139.7 | 139.7 | 139.7 | 139.7 | 10000.0 |
| 2008-06-02 06:15:00 | SPY | ETF | 139.72 | 139.72 | 139.72 | 139.72 | 200.0 |
| 2008-06-02 06:20:00 | SPY | ETF | 139.66 | 139.67 | 139.66 | 139.67 | 5200.0 |
| 2008-06-02 06:25:00 | SPY | ETF | 139.67 | 139.67 | 139.65 | 139.65 | 3100.0 |
| 2008-06-02 06:30:00 | SPY | ETF | 139.67 | 139.67 | 139.67 | 139.67 | 3795.0 |
| 2008-06-02 06:40:00 | SPY | ETF | 139.68 | 139.68 | 139.67 | 139.67 | 5500.0 |
| 2008-06-02 06:45:00 | SPY | ETF | 139.67 | 139.67 | 139.58 | 139.58 | 16600.0 |
| 2008-06-02 06:50:00 | SPY | ETF | 139.61 | 139.61 | 139.61 | 139.61 | 200.0 |
| 2008-06-02 07:00:00 | SPY | ETF | 139.61 | 139.61 | 139.52 | 139.52 | 12400.0 |
| 2008-06-02 07:05:00 | SPY | ETF | 139.62 | 139.62 | 139.61 | 139.62 | 8800.0 |
| 2008-06-02 07:10:00 | SPY | ETF | 139.62 | 139.67 | 139.62 | 139.67 | 3000.0 |
| 2008-06-02 07:15:00 | SPY | ETF | 139.67 | 139.71 | 139.67 | 139.7 | 101800.0 |
| 2008-06-02 07:20:00 | SPY | ETF | 139.67 | 139.7 | 139.64 | 139.7 | 31900.0 |
| 2008-06-02 07:25:00 | SPY | ETF | 139.67 | 139.7 | 139.67 | 139.7 | 47700.0 |
| 2008-06-02 07:30:00 | SPY | ETF | 139.72 | 139.72 | 139.67 | 139.68 | 3600.0 |
| 2008-06-02 07:35:00 | SPY | ETF | 139.67 | 139.67 | 139.62 | 139.65 | 94400.0 |
| 2008-06-02 07:40:00 | SPY | ETF | 139.65 | 139.67 | 139.63 | 139.67 | 3400.0 |
| 2008-06-02 07:45:00 | SPY | ETF | 139.69 | 139.72 | 139.65 | 139.65 | 9800.0 |
| 2008-06-02 07:50:00 | SPY | ETF | 139.65 | 139.67 | 139.62 | 139.62 | 10200.0 |
| 2008-06-02 07:55:00 | SPY | ETF | 139.61 | 139.71 | 139.6 | 139.7 | 63200.0 |
| 2008-06-02 08:00:00 | SPY | ETF | 139.69 | 139.72 | 139.39 | 139.65 | 310554.0 |
| 2008-06-02 08:05:00 | SPY | ETF | 139.66 | 139.73 | 139.65 | 139.73 | 24551.0 |
| 2008-06-02 08:10:00 | SPY | ETF | 139.73 | 139.76 | 139.7 | 139.7 | 123500.0 |
| 2008-06-02 08:15:00 | SPY | ETF | 139.68 | 139.7 | 139.64 | 139.7 | 186471.0 |
| 2008-06-02 08:20:00 | SPY | ETF | 139.7 | 139.7 | 139.6 | 139.61 | 411345.0 |
| 2008-06-02 08:25:00 | SPY | ETF | 139.62 | 139.67 | 139.6 | 139.62 | 107980.0 |
| 2008-06-02 08:30:00 | SPY | ETF | 139.61 | 140.35 | 139.59 | 139.67 | 372357.0 |
| 2008-06-02 08:35:00 | SPY | ETF | 139.67 | 139.72 | 139.65 | 139.68 | 16410.0 |
| 2008-06-02 08:40:00 | SPY | ETF | 139.68 | 139.68 | 139.64 | 139.66 | 60434.0 |
| 2008-06-02 08:45:00 | SPY | ETF | 139.65 | 139.74 | 139.65 | 139.73 | 84041.0 |
| 2008-06-02 08:50:00 | SPY | ETF | 139.74 | 139.74 | 139.66 | 139.66 | 66300.0 |
| 2008-06-02 08:55:00 | SPY | ETF | 139.68 | 139.7 | 139.65 | 139.68 | 38295.0 |
| 2008-06-02 09:00:00 | SPY | ETF | 139.68 | 139.71 | 139.66 | 139.68 | 83251.0 |
| 2008-06-02 09:05:00 | SPY | ETF | 139.73 | 139.73 | 139.66 | 139.66 | 14712.0 |
| 2008-06-02 09:10:00 | SPY | ETF | 139.69 | 139.74 | 139.68 | 139.71 | 164402.0 |
| 2008-06-02 09:15:00 | SPY | ETF | 139.71 | 139.73 | 139.7 | 139.73 | 17927.0 |
| 2008-06-02 09:20:00 | SPY | ETF | 139.73 | 139.74 | 139.71 | 139.74 | 71450.0 |
| 2008-06-02 09:25:00 | SPY | ETF | 139.74 | 139.82 | 139.74 | 139.82 | 71050.0 |
| 2008-06-02 09:30:00 | SPY | ETF | 139.83 | 139.86 | 139.68 | 139.72 | 2601509.0 |
| 2008-06-02 09:35:00 | SPY | ETF | 139.72 | 139.77 | 139.58 | 139.65 | 2090027.0 |
| 2008-06-02 09:40:00 | SPY | ETF | 139.65 | 139.66 | 139.51 | 139.55 | 2235266.0 |
| 2008-06-02 09:45:00 | SPY | ETF | 139.55 | 139.55 | 139.44 | 139.49 | 3255914.0 |
| 2008-06-02 09:50:00 | SPY | ETF | 139.48 | 139.49 | 139.19 | 139.21 | 3488411.0 |
| 2008-06-02 09:55:00 | SPY | ETF | 139.2 | 139.29 | 139.18 | 139.27 | 2214238.0 |
| 2008-06-02 10:00:00 | SPY | ETF | 139.28 | 139.45 | 139.1 | 139.34 | 5277406.0 |
> showing 50 of 22,532 rows — these rows as CSV