PREVIEW / etf_5min / 2009-11-12
file: by_date/etf_5min/2009/2009-11-12.parquet size: 732 KB rows: 30,918
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-11-12 04:15:00 | SPY | ETF | 109.57 | 109.58 | 109.57 | 109.58 | 1100.0 |
| 2009-11-12 04:20:00 | SPY | ETF | 109.56 | 109.57 | 109.45 | 109.45 | 1855.0 |
| 2009-11-12 04:30:00 | SPY | ETF | 109.45 | 109.47 | 109.45 | 109.47 | 400.0 |
| 2009-11-12 04:40:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 100.0 |
| 2009-11-12 04:50:00 | SPY | ETF | 109.6 | 109.6 | 109.6 | 109.6 | 500.0 |
| 2009-11-12 04:55:00 | SPY | ETF | 109.57 | 109.57 | 109.57 | 109.57 | 300.0 |
| 2009-11-12 05:15:00 | SPY | ETF | 109.78 | 109.78 | 109.78 | 109.78 | 2500.0 |
| 2009-11-12 05:55:00 | SPY | ETF | 109.88 | 109.88 | 109.87 | 109.88 | 1100.0 |
| 2009-11-12 06:20:00 | SPY | ETF | 109.79 | 109.79 | 109.79 | 109.79 | 1000.0 |
| 2009-11-12 06:30:00 | SPY | ETF | 109.77 | 109.77 | 109.71 | 109.71 | 600.0 |
| 2009-11-12 06:40:00 | SPY | ETF | 109.71 | 109.71 | 109.71 | 109.71 | 700.0 |
| 2009-11-12 06:45:00 | SPY | ETF | 109.77 | 109.77 | 109.75 | 109.75 | 300.0 |
| 2009-11-12 06:55:00 | SPY | ETF | 109.67 | 109.67 | 109.65 | 109.65 | 400.0 |
| 2009-11-12 07:00:00 | SPY | ETF | 109.74 | 109.92 | 109.74 | 109.92 | 42284.0 |
| 2009-11-12 07:05:00 | SPY | ETF | 109.85 | 109.85 | 109.65 | 109.65 | 43900.0 |
| 2009-11-12 07:10:00 | SPY | ETF | 109.66 | 109.75 | 109.65 | 109.71 | 13959.0 |
| 2009-11-12 07:15:00 | SPY | ETF | 109.68 | 109.68 | 109.62 | 109.66 | 19153.0 |
| 2009-11-12 07:20:00 | SPY | ETF | 109.63 | 109.63 | 109.55 | 109.55 | 35640.0 |
| 2009-11-12 07:25:00 | SPY | ETF | 109.57 | 109.61 | 109.55 | 109.58 | 130408.0 |
| 2009-11-12 07:30:00 | SPY | ETF | 109.58 | 109.58 | 109.51 | 109.51 | 47583.0 |
| 2009-11-12 07:35:00 | SPY | ETF | 109.51 | 109.56 | 109.47 | 109.51 | 57724.0 |
| 2009-11-12 07:40:00 | SPY | ETF | 109.5 | 109.57 | 109.5 | 109.53 | 14052.0 |
| 2009-11-12 07:45:00 | SPY | ETF | 109.58 | 109.63 | 109.55 | 109.6 | 27390.0 |
| 2009-11-12 07:50:00 | SPY | ETF | 109.63 | 109.67 | 109.59 | 109.67 | 180521.0 |
| 2009-11-12 07:55:00 | SPY | ETF | 109.63 | 109.69 | 109.63 | 109.67 | 130704.0 |
| 2009-11-12 08:00:00 | SPY | ETF | 109.67 | 109.75 | 109.59 | 109.66 | 394495.0 |
| 2009-11-12 08:05:00 | SPY | ETF | 109.64 | 109.72 | 109.63 | 109.72 | 62835.0 |
| 2009-11-12 08:10:00 | SPY | ETF | 109.71 | 109.73 | 109.67 | 109.73 | 183046.0 |
| 2009-11-12 08:15:00 | SPY | ETF | 109.72 | 109.85 | 109.72 | 109.8 | 224291.0 |
| 2009-11-12 08:20:00 | SPY | ETF | 109.79 | 109.83 | 109.38 | 109.81 | 91797.0 |
| 2009-11-12 08:25:00 | SPY | ETF | 109.81 | 109.88 | 109.76 | 109.88 | 275609.0 |
| 2009-11-12 08:30:00 | SPY | ETF | 109.88 | 110.0 | 109.58 | 109.67 | 1272374.0 |
| 2009-11-12 08:35:00 | SPY | ETF | 109.68 | 109.75 | 109.67 | 109.73 | 201710.0 |
| 2009-11-12 08:40:00 | SPY | ETF | 109.73 | 109.96 | 109.73 | 109.9 | 252380.0 |
| 2009-11-12 08:45:00 | SPY | ETF | 109.9 | 109.95 | 109.84 | 109.84 | 94893.0 |
| 2009-11-12 08:50:00 | SPY | ETF | 109.84 | 109.87 | 109.81 | 109.82 | 79080.0 |
| 2009-11-12 08:55:00 | SPY | ETF | 109.83 | 110.15 | 109.78 | 109.84 | 443961.0 |
| 2009-11-12 09:00:00 | SPY | ETF | 109.84 | 109.95 | 109.84 | 109.9 | 89455.0 |
| 2009-11-12 09:05:00 | SPY | ETF | 109.9 | 109.91 | 109.84 | 109.84 | 66788.0 |
| 2009-11-12 09:10:00 | SPY | ETF | 109.84 | 109.87 | 109.8 | 109.87 | 79416.0 |
| 2009-11-12 09:15:00 | SPY | ETF | 109.87 | 110.15 | 109.86 | 109.97 | 127262.0 |
| 2009-11-12 09:20:00 | SPY | ETF | 109.97 | 109.97 | 109.91 | 109.95 | 89738.0 |
| 2009-11-12 09:25:00 | SPY | ETF | 109.95 | 109.99 | 109.91 | 109.99 | 79177.0 |
| 2009-11-12 09:30:00 | SPY | ETF | 110.0 | 110.09 | 109.83 | 109.93 | 3208591.0 |
| 2009-11-12 09:35:00 | SPY | ETF | 109.93 | 109.98 | 109.74 | 109.76 | 2804762.0 |
| 2009-11-12 09:40:00 | SPY | ETF | 109.76 | 109.93 | 109.65 | 109.79 | 4126921.0 |
| 2009-11-12 09:45:00 | SPY | ETF | 109.79 | 110.08 | 109.73 | 110.009 | 3437179.0 |
| 2009-11-12 09:50:00 | SPY | ETF | 110.0 | 110.28 | 109.85 | 110.18 | 4304768.0 |
| 2009-11-12 09:55:00 | SPY | ETF | 110.18 | 110.55 | 110.17 | 110.4 | 3836029.0 |
| 2009-11-12 10:00:00 | SPY | ETF | 110.4 | 110.57 | 110.1 | 110.4 | 2742471.0 |
> showing 50 of 30,918 rows — these rows as CSV