PREVIEW / etf_5min / 2013-02-12
file: by_date/etf_5min/2013/2013-02-12.parquet size: 919 KB rows: 39,070
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-12 04:00:00 | SPY | ETF | 151.49 | 151.5 | 151.41 | 151.5 | 1900.0 |
| 2013-02-12 04:05:00 | SPY | ETF | 151.52 | 151.52 | 151.52 | 151.52 | 400.0 |
| 2013-02-12 04:15:00 | SPY | ETF | 151.5 | 151.5 | 151.47 | 151.47 | 1300.0 |
| 2013-02-12 04:20:00 | SPY | ETF | 151.46 | 151.46 | 151.45 | 151.45 | 4000.0 |
| 2013-02-12 04:25:00 | SPY | ETF | 151.52 | 151.54 | 151.52 | 151.54 | 300.0 |
| 2013-02-12 04:30:00 | SPY | ETF | 151.55 | 151.57 | 151.55 | 151.57 | 300.0 |
| 2013-02-12 04:40:00 | SPY | ETF | 151.51 | 151.51 | 151.5 | 151.5 | 200.0 |
| 2013-02-12 04:45:00 | SPY | ETF | 151.5 | 151.5 | 151.47 | 151.47 | 400.0 |
| 2013-02-12 04:55:00 | SPY | ETF | 151.46 | 151.46 | 151.41 | 151.41 | 800.0 |
| 2013-02-12 05:05:00 | SPY | ETF | 151.45 | 151.45 | 151.45 | 151.45 | 100.0 |
| 2013-02-12 05:10:00 | SPY | ETF | 151.47 | 151.5 | 151.47 | 151.5 | 10300.0 |
| 2013-02-12 05:15:00 | SPY | ETF | 151.5 | 151.5 | 151.5 | 151.5 | 110.0 |
| 2013-02-12 05:20:00 | SPY | ETF | 151.51 | 151.53 | 151.51 | 151.53 | 400.0 |
| 2013-02-12 05:25:00 | SPY | ETF | 151.54 | 151.59 | 151.54 | 151.56 | 6300.0 |
| 2013-02-12 05:30:00 | SPY | ETF | 151.54 | 151.54 | 151.54 | 151.54 | 100.0 |
| 2013-02-12 05:35:00 | SPY | ETF | 151.57 | 151.58 | 151.56 | 151.56 | 1200.0 |
| 2013-02-12 05:40:00 | SPY | ETF | 151.58 | 151.59 | 151.58 | 151.59 | 4000.0 |
| 2013-02-12 05:45:00 | SPY | ETF | 151.58 | 151.69 | 151.58 | 151.66 | 32700.0 |
| 2013-02-12 05:50:00 | SPY | ETF | 151.66 | 151.72 | 151.66 | 151.68 | 12325.0 |
| 2013-02-12 05:55:00 | SPY | ETF | 151.65 | 151.65 | 151.65 | 151.65 | 600.0 |
| 2013-02-12 06:00:00 | SPY | ETF | 151.64 | 151.74 | 151.64 | 151.74 | 1300.0 |
| 2013-02-12 06:05:00 | SPY | ETF | 151.72 | 151.74 | 151.72 | 151.74 | 5200.0 |
| 2013-02-12 06:15:00 | SPY | ETF | 151.73 | 151.74 | 151.72 | 151.72 | 8950.0 |
| 2013-02-12 06:25:00 | SPY | ETF | 151.71 | 151.71 | 151.71 | 151.71 | 100.0 |
| 2013-02-12 06:30:00 | SPY | ETF | 151.73 | 151.74 | 151.73 | 151.74 | 4750.0 |
| 2013-02-12 06:35:00 | SPY | ETF | 151.72 | 151.72 | 151.67 | 151.67 | 2751.0 |
| 2013-02-12 06:40:00 | SPY | ETF | 151.67 | 151.67 | 151.67 | 151.67 | 100.0 |
| 2013-02-12 06:55:00 | SPY | ETF | 151.68 | 151.68 | 151.68 | 151.68 | 400.0 |
| 2013-02-12 07:00:00 | SPY | ETF | 151.68 | 151.68 | 151.68 | 151.68 | 100.0 |
| 2013-02-12 07:10:00 | SPY | ETF | 151.68 | 151.72 | 151.68 | 151.7 | 700.0 |
| 2013-02-12 07:15:00 | SPY | ETF | 151.68 | 151.68 | 151.68 | 151.68 | 1072.0 |
| 2013-02-12 07:20:00 | SPY | ETF | 151.66 | 151.66 | 151.66 | 151.66 | 665.0 |
| 2013-02-12 07:25:00 | SPY | ETF | 151.66 | 151.66 | 151.57 | 151.58 | 13600.0 |
| 2013-02-12 07:30:00 | SPY | ETF | 151.58 | 151.63 | 151.56 | 151.63 | 4100.0 |
| 2013-02-12 07:35:00 | SPY | ETF | 151.67 | 151.72 | 151.64 | 151.64 | 12600.0 |
| 2013-02-12 07:40:00 | SPY | ETF | 151.62 | 151.66 | 151.61 | 151.66 | 1200.0 |
| 2013-02-12 07:45:00 | SPY | ETF | 151.63 | 151.66 | 151.63 | 151.65 | 3300.0 |
| 2013-02-12 07:50:00 | SPY | ETF | 151.63 | 151.66 | 151.63 | 151.63 | 2700.0 |
| 2013-02-12 07:55:00 | SPY | ETF | 151.63 | 151.67 | 151.63 | 151.67 | 11565.0 |
| 2013-02-12 08:00:00 | SPY | ETF | 151.64 | 151.66 | 151.36 | 151.61 | 46822.0 |
| 2013-02-12 08:05:00 | SPY | ETF | 151.62 | 151.69 | 151.62 | 151.63 | 41140.0 |
| 2013-02-12 08:10:00 | SPY | ETF | 151.62 | 151.74 | 151.61 | 151.68 | 15400.0 |
| 2013-02-12 08:15:00 | SPY | ETF | 151.7 | 151.75 | 151.7 | 151.74 | 10700.0 |
| 2013-02-12 08:20:00 | SPY | ETF | 151.74 | 151.83 | 151.73 | 151.83 | 32404.0 |
| 2013-02-12 08:25:00 | SPY | ETF | 151.82 | 151.87 | 151.8 | 151.8 | 265017.0 |
| 2013-02-12 08:30:00 | SPY | ETF | 151.81 | 151.88 | 151.81 | 151.87 | 142800.0 |
| 2013-02-12 08:35:00 | SPY | ETF | 151.86 | 151.94 | 151.83 | 151.94 | 96660.0 |
| 2013-02-12 08:40:00 | SPY | ETF | 151.94 | 151.99 | 151.87 | 151.89 | 261865.0 |
| 2013-02-12 08:45:00 | SPY | ETF | 151.9 | 151.93 | 151.88 | 151.9 | 11730.0 |
| 2013-02-12 08:50:00 | SPY | ETF | 151.88 | 151.89 | 151.87 | 151.88 | 2366.0 |
> showing 50 of 39,070 rows — these rows as CSV