PREVIEW / etf_5min / 2008-02-14
file: by_date/etf_5min/2008/2008-02-14.parquet size: 451 KB rows: 21,501
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-02-14 04:25:00 | SPY | ETF | 136.75 | 136.75 | 136.75 | 136.75 | 100.0 |
| 2008-02-14 04:45:00 | SPY | ETF | 136.77 | 136.77 | 136.77 | 136.77 | 100.0 |
| 2008-02-14 05:00:00 | SPY | ETF | 136.54 | 136.54 | 136.54 | 136.54 | 500.0 |
| 2008-02-14 05:15:00 | SPY | ETF | 136.52 | 136.52 | 136.52 | 136.52 | 500.0 |
| 2008-02-14 05:40:00 | SPY | ETF | 136.67 | 136.67 | 136.67 | 136.67 | 5000.0 |
| 2008-02-14 05:45:00 | SPY | ETF | 136.67 | 136.67 | 136.67 | 136.67 | 600.0 |
| 2008-02-14 05:55:00 | SPY | ETF | 136.79 | 136.79 | 136.74 | 136.74 | 10000.0 |
| 2008-02-14 06:05:00 | SPY | ETF | 136.67 | 136.67 | 136.67 | 136.67 | 200.0 |
| 2008-02-14 06:45:00 | SPY | ETF | 136.7 | 136.7 | 136.7 | 136.7 | 1000.0 |
| 2008-02-14 06:50:00 | SPY | ETF | 136.77 | 136.84 | 136.7 | 136.7 | 15500.0 |
| 2008-02-14 06:55:00 | SPY | ETF | 136.7 | 136.7 | 136.7 | 136.7 | 10600.0 |
| 2008-02-14 07:00:00 | SPY | ETF | 136.75 | 136.85 | 136.75 | 136.82 | 21000.0 |
| 2008-02-14 07:05:00 | SPY | ETF | 136.84 | 136.84 | 136.72 | 136.72 | 1800.0 |
| 2008-02-14 07:10:00 | SPY | ETF | 136.78 | 136.83 | 136.78 | 136.83 | 2800.0 |
| 2008-02-14 07:15:00 | SPY | ETF | 136.77 | 136.77 | 136.75 | 136.75 | 54500.0 |
| 2008-02-14 07:20:00 | SPY | ETF | 136.82 | 136.84 | 136.8 | 136.81 | 2400.0 |
| 2008-02-14 07:25:00 | SPY | ETF | 136.85 | 136.89 | 136.84 | 136.89 | 103100.0 |
| 2008-02-14 07:30:00 | SPY | ETF | 136.85 | 136.85 | 136.79 | 136.81 | 33600.0 |
| 2008-02-14 07:35:00 | SPY | ETF | 136.85 | 136.85 | 136.68 | 136.76 | 72400.0 |
| 2008-02-14 07:40:00 | SPY | ETF | 136.82 | 136.83 | 136.73 | 136.73 | 29900.0 |
| 2008-02-14 07:45:00 | SPY | ETF | 136.77 | 136.78 | 136.56 | 136.64 | 123500.0 |
| 2008-02-14 07:50:00 | SPY | ETF | 136.64 | 136.64 | 136.64 | 136.64 | 1000.0 |
| 2008-02-14 07:55:00 | SPY | ETF | 136.66 | 136.74 | 136.62 | 136.62 | 29200.0 |
| 2008-02-14 08:00:00 | SPY | ETF | 136.64 | 136.64 | 136.55 | 136.62 | 66200.0 |
| 2008-02-14 08:05:00 | SPY | ETF | 136.61 | 136.74 | 136.61 | 136.65 | 125100.0 |
| 2008-02-14 08:10:00 | SPY | ETF | 136.64 | 136.66 | 136.52 | 136.62 | 51200.0 |
| 2008-02-14 08:15:00 | SPY | ETF | 136.62 | 136.68 | 136.52 | 136.68 | 88500.0 |
| 2008-02-14 08:20:00 | SPY | ETF | 136.66 | 137.03 | 136.5 | 136.53 | 154000.0 |
| 2008-02-14 08:25:00 | SPY | ETF | 136.56 | 136.6 | 136.46 | 136.54 | 148700.0 |
| 2008-02-14 08:30:00 | SPY | ETF | 136.56 | 136.97 | 136.56 | 136.75 | 839100.0 |
| 2008-02-14 08:35:00 | SPY | ETF | 136.76 | 136.87 | 136.69 | 136.7 | 203600.0 |
| 2008-02-14 08:40:00 | SPY | ETF | 136.7 | 136.91 | 136.7 | 136.85 | 148300.0 |
| 2008-02-14 08:45:00 | SPY | ETF | 136.86 | 136.91 | 136.78 | 136.82 | 91800.0 |
| 2008-02-14 08:50:00 | SPY | ETF | 136.83 | 136.88 | 136.8 | 136.82 | 259100.0 |
| 2008-02-14 08:55:00 | SPY | ETF | 136.82 | 136.9 | 136.78 | 136.79 | 198200.0 |
| 2008-02-14 09:00:00 | SPY | ETF | 136.8 | 136.99 | 136.79 | 136.92 | 242400.0 |
| 2008-02-14 09:05:00 | SPY | ETF | 136.93 | 137.04 | 136.9 | 136.97 | 986170.0 |
| 2008-02-14 09:10:00 | SPY | ETF | 136.94 | 137.03 | 136.9 | 136.9 | 377100.0 |
| 2008-02-14 09:15:00 | SPY | ETF | 136.9 | 137.0 | 136.76 | 136.77 | 243900.0 |
| 2008-02-14 09:20:00 | SPY | ETF | 136.76 | 136.87 | 136.75 | 136.87 | 194200.0 |
| 2008-02-14 09:25:00 | SPY | ETF | 136.84 | 136.95 | 136.8 | 136.95 | 81300.0 |
| 2008-02-14 09:30:00 | SPY | ETF | 136.95 | 137.0 | 136.59 | 136.71 | 3435364.0 |
| 2008-02-14 09:35:00 | SPY | ETF | 136.71 | 136.87 | 136.46 | 136.55 | 2294573.0 |
| 2008-02-14 09:40:00 | SPY | ETF | 136.56 | 136.7585 | 136.3 | 136.3 | 2741199.0 |
| 2008-02-14 09:45:00 | SPY | ETF | 136.3 | 136.48 | 136.22 | 136.4 | 4993926.0 |
| 2008-02-14 09:50:00 | SPY | ETF | 136.4 | 136.66 | 136.35 | 136.6 | 1859762.0 |
| 2008-02-14 09:55:00 | SPY | ETF | 136.6 | 136.7501 | 136.44 | 136.46 | 2451642.0 |
| 2008-02-14 10:00:00 | SPY | ETF | 136.46 | 136.98 | 136.35 | 136.6 | 4483314.0 |
| 2008-02-14 10:05:00 | SPY | ETF | 136.59 | 136.6 | 136.28 | 136.2801 | 1926794.0 |
| 2008-02-14 10:10:00 | SPY | ETF | 136.29 | 136.53 | 136.2 | 136.51 | 2328486.0 |
> showing 50 of 21,501 rows — these rows as CSV