PREVIEW / etf_1min / 2011-09-01
file: by_date/etf_1min/2011/2011-09-01.parquet size: 2.1 MB rows: 110,379
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-01 04:20:00 | SPY | ETF | 121.93 | 121.93 | 121.93 | 121.93 | 300.0 |
| 2011-09-01 04:36:00 | SPY | ETF | 121.99 | 122.03 | 121.97 | 122.03 | 80100.0 |
| 2011-09-01 04:42:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 200.0 |
| 2011-09-01 04:44:00 | SPY | ETF | 121.79 | 121.8 | 121.79 | 121.8 | 300.0 |
| 2011-09-01 04:47:00 | SPY | ETF | 121.87 | 121.87 | 121.87 | 121.87 | 100.0 |
| 2011-09-01 04:59:00 | SPY | ETF | 121.85 | 121.85 | 121.85 | 121.85 | 2500.0 |
| 2011-09-01 05:08:00 | SPY | ETF | 121.76 | 121.76 | 121.75 | 121.75 | 295.0 |
| 2011-09-01 05:12:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 2400.0 |
| 2011-09-01 05:15:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 100.0 |
| 2011-09-01 05:17:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 200.0 |
| 2011-09-01 05:20:00 | SPY | ETF | 121.55 | 121.58 | 121.55 | 121.58 | 1100.0 |
| 2011-09-01 05:21:00 | SPY | ETF | 121.55 | 121.55 | 121.5 | 121.5 | 390.0 |
| 2011-09-01 05:26:00 | SPY | ETF | 121.48 | 121.48 | 121.48 | 121.48 | 400.0 |
| 2011-09-01 05:27:00 | SPY | ETF | 121.45 | 121.45 | 121.45 | 121.45 | 2500.0 |
| 2011-09-01 05:30:00 | SPY | ETF | 121.52 | 121.52 | 121.52 | 121.52 | 200.0 |
| 2011-09-01 05:34:00 | SPY | ETF | 121.68 | 121.68 | 121.68 | 121.68 | 100.0 |
| 2011-09-01 05:57:00 | SPY | ETF | 121.75 | 121.75 | 121.75 | 121.75 | 7000.0 |
| 2011-09-01 05:58:00 | SPY | ETF | 121.73 | 121.73 | 121.73 | 121.73 | 100.0 |
| 2011-09-01 06:01:00 | SPY | ETF | 121.78 | 121.78 | 121.78 | 121.78 | 4000.0 |
| 2011-09-01 06:04:00 | SPY | ETF | 121.77 | 121.77 | 121.77 | 121.77 | 272.0 |
| 2011-09-01 06:18:00 | SPY | ETF | 121.81 | 121.81 | 121.81 | 121.81 | 100.0 |
| 2011-09-01 06:19:00 | SPY | ETF | 121.81 | 121.81 | 121.81 | 121.81 | 1400.0 |
| 2011-09-01 06:23:00 | SPY | ETF | 121.62 | 121.62 | 121.57 | 121.57 | 8200.0 |
| 2011-09-01 06:24:00 | SPY | ETF | 121.59 | 121.59 | 121.59 | 121.59 | 100.0 |
| 2011-09-01 06:26:00 | SPY | ETF | 121.71 | 121.71 | 121.71 | 121.71 | 100.0 |
| 2011-09-01 06:30:00 | SPY | ETF | 121.65 | 121.65 | 121.65 | 121.65 | 100.0 |
| 2011-09-01 06:33:00 | SPY | ETF | 121.81 | 121.81 | 121.81 | 121.81 | 1500.0 |
| 2011-09-01 06:37:00 | SPY | ETF | 121.82 | 121.82 | 121.82 | 121.82 | 100.0 |
| 2011-09-01 06:39:00 | SPY | ETF | 121.88 | 121.88 | 121.82 | 121.82 | 250.0 |
| 2011-09-01 06:42:00 | SPY | ETF | 121.84 | 121.84 | 121.84 | 121.84 | 100.0 |
| 2011-09-01 06:53:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 100.0 |
| 2011-09-01 06:54:00 | SPY | ETF | 121.76 | 121.76 | 121.76 | 121.76 | 150.0 |
| 2011-09-01 06:55:00 | SPY | ETF | 121.73 | 121.73 | 121.69 | 121.69 | 3100.0 |
| 2011-09-01 06:56:00 | SPY | ETF | 121.64 | 121.64 | 121.64 | 121.64 | 100.0 |
| 2011-09-01 07:00:00 | SPY | ETF | 121.71 | 121.76 | 121.71 | 121.76 | 3200.0 |
| 2011-09-01 07:01:00 | SPY | ETF | 121.74 | 121.78 | 121.74 | 121.78 | 7650.0 |
| 2011-09-01 07:02:00 | SPY | ETF | 121.77 | 121.81 | 121.72 | 121.78 | 11800.0 |
| 2011-09-01 07:03:00 | SPY | ETF | 121.81 | 121.84 | 121.79 | 121.79 | 12700.0 |
| 2011-09-01 07:04:00 | SPY | ETF | 121.76 | 121.88 | 121.76 | 121.88 | 13650.0 |
| 2011-09-01 07:05:00 | SPY | ETF | 121.88 | 121.89 | 121.87 | 121.87 | 3200.0 |
| 2011-09-01 07:06:00 | SPY | ETF | 121.85 | 121.88 | 121.85 | 121.88 | 6200.0 |
| 2011-09-01 07:07:00 | SPY | ETF | 121.9 | 121.9 | 121.9 | 121.9 | 2800.0 |
| 2011-09-01 07:09:00 | SPY | ETF | 121.86 | 121.86 | 121.86 | 121.86 | 100.0 |
| 2011-09-01 07:10:00 | SPY | ETF | 121.85 | 121.85 | 121.83 | 121.83 | 2100.0 |
| 2011-09-01 07:11:00 | SPY | ETF | 121.85 | 121.9 | 121.85 | 121.9 | 17100.0 |
| 2011-09-01 07:12:00 | SPY | ETF | 121.87 | 121.87 | 121.87 | 121.87 | 200.0 |
| 2011-09-01 07:13:00 | SPY | ETF | 121.83 | 121.85 | 121.83 | 121.85 | 4100.0 |
| 2011-09-01 07:15:00 | SPY | ETF | 121.86 | 121.9 | 121.85 | 121.88 | 19300.0 |
| 2011-09-01 07:16:00 | SPY | ETF | 121.88 | 121.93 | 121.87 | 121.91 | 3900.0 |
| 2011-09-01 07:17:00 | SPY | ETF | 121.93 | 121.93 | 121.92 | 121.92 | 10700.0 |
> showing 50 of 110,379 rows — these rows as CSV