PREVIEW / etf_1min / 2011-07-22
file: by_date/etf_1min/2011/2011-07-22.parquet size: 1.8 MB rows: 100,737
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-07-22 04:01:00 | SPY | ETF | 134.88 | 134.88 | 134.88 | 134.88 | 100.0 |
| 2011-07-22 04:07:00 | SPY | ETF | 134.94 | 134.94 | 134.94 | 134.94 | 700.0 |
| 2011-07-22 04:29:00 | SPY | ETF | 135.01 | 135.01 | 135.01 | 135.01 | 200.0 |
| 2011-07-22 04:37:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 100.0 |
| 2011-07-22 04:41:00 | SPY | ETF | 135.14 | 135.15 | 135.14 | 135.15 | 888.0 |
| 2011-07-22 04:52:00 | SPY | ETF | 135.16 | 135.16 | 135.16 | 135.16 | 190.0 |
| 2011-07-22 05:06:00 | SPY | ETF | 135.13 | 135.13 | 135.13 | 135.13 | 142.0 |
| 2011-07-22 05:08:00 | SPY | ETF | 135.1 | 135.1 | 135.1 | 135.1 | 100.0 |
| 2011-07-22 05:20:00 | SPY | ETF | 135.13 | 135.13 | 135.13 | 135.13 | 688.0 |
| 2011-07-22 05:30:00 | SPY | ETF | 135.09 | 135.09 | 135.09 | 135.09 | 100.0 |
| 2011-07-22 05:35:00 | SPY | ETF | 135.04 | 135.04 | 135.04 | 135.04 | 100.0 |
| 2011-07-22 05:36:00 | SPY | ETF | 135.02 | 135.02 | 135.02 | 135.02 | 19900.0 |
| 2011-07-22 05:47:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 300.0 |
| 2011-07-22 06:16:00 | SPY | ETF | 135.04 | 135.1 | 135.04 | 135.1 | 1450.0 |
| 2011-07-22 06:26:00 | SPY | ETF | 135.09 | 135.09 | 135.09 | 135.09 | 100.0 |
| 2011-07-22 06:30:00 | SPY | ETF | 135.09 | 135.09 | 135.09 | 135.09 | 100.0 |
| 2011-07-22 06:36:00 | SPY | ETF | 135.05 | 135.05 | 135.05 | 135.05 | 400.0 |
| 2011-07-22 06:38:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 1100.0 |
| 2011-07-22 06:39:00 | SPY | ETF | 135.05 | 135.05 | 135.05 | 135.05 | 100.0 |
| 2011-07-22 06:42:00 | SPY | ETF | 135.0 | 135.0 | 135.0 | 135.0 | 100.0 |
| 2011-07-22 06:45:00 | SPY | ETF | 135.02 | 135.02 | 134.9 | 134.9 | 3500.0 |
| 2011-07-22 06:46:00 | SPY | ETF | 135.01 | 135.01 | 134.94 | 134.94 | 300.0 |
| 2011-07-22 06:48:00 | SPY | ETF | 134.92 | 134.92 | 134.9 | 134.9 | 300.0 |
| 2011-07-22 06:49:00 | SPY | ETF | 134.85 | 134.85 | 134.85 | 134.85 | 100.0 |
| 2011-07-22 06:54:00 | SPY | ETF | 134.9 | 134.9 | 134.9 | 134.9 | 350.0 |
| 2011-07-22 06:56:00 | SPY | ETF | 134.93 | 134.93 | 134.91 | 134.91 | 350.0 |
| 2011-07-22 07:00:00 | SPY | ETF | 134.9 | 134.91 | 134.88 | 134.88 | 2400.0 |
| 2011-07-22 07:01:00 | SPY | ETF | 134.87 | 134.87 | 134.87 | 134.87 | 4500.0 |
| 2011-07-22 07:02:00 | SPY | ETF | 134.9 | 134.9 | 134.9 | 134.9 | 100.0 |
| 2011-07-22 07:03:00 | SPY | ETF | 134.9 | 134.91 | 134.9 | 134.91 | 2300.0 |
| 2011-07-22 07:04:00 | SPY | ETF | 134.94 | 134.95 | 134.94 | 134.95 | 200.0 |
| 2011-07-22 07:05:00 | SPY | ETF | 134.97 | 134.97 | 134.96 | 134.96 | 500.0 |
| 2011-07-22 07:07:00 | SPY | ETF | 134.95 | 135.03 | 134.95 | 135.03 | 307500.0 |
| 2011-07-22 07:08:00 | SPY | ETF | 135.02 | 135.02 | 135.01 | 135.01 | 1100.0 |
| 2011-07-22 07:09:00 | SPY | ETF | 135.04 | 135.04 | 134.98 | 134.98 | 1600.0 |
| 2011-07-22 07:10:00 | SPY | ETF | 134.94 | 134.94 | 134.94 | 134.94 | 500.0 |
| 2011-07-22 07:11:00 | SPY | ETF | 135.03 | 135.03 | 135.03 | 135.03 | 600.0 |
| 2011-07-22 07:14:00 | SPY | ETF | 135.05 | 135.05 | 135.05 | 135.05 | 300.0 |
| 2011-07-22 07:15:00 | SPY | ETF | 135.05 | 135.05 | 135.05 | 135.05 | 20100.0 |
| 2011-07-22 07:16:00 | SPY | ETF | 135.07 | 135.1 | 135.06 | 135.06 | 8100.0 |
| 2011-07-22 07:17:00 | SPY | ETF | 135.08 | 135.08 | 135.05 | 135.05 | 20000.0 |
| 2011-07-22 07:18:00 | SPY | ETF | 135.04 | 135.05 | 135.02 | 135.03 | 20000.0 |
| 2011-07-22 07:19:00 | SPY | ETF | 135.0 | 135.01 | 135.0 | 135.01 | 3900.0 |
| 2011-07-22 07:20:00 | SPY | ETF | 135.04 | 135.07 | 135.04 | 135.07 | 7400.0 |
| 2011-07-22 07:21:00 | SPY | ETF | 135.07 | 135.15 | 135.07 | 135.08 | 136500.0 |
| 2011-07-22 07:22:00 | SPY | ETF | 135.07 | 135.12 | 135.07 | 135.09 | 32300.0 |
| 2011-07-22 07:23:00 | SPY | ETF | 135.11 | 135.11 | 135.08 | 135.08 | 1700.0 |
| 2011-07-22 07:24:00 | SPY | ETF | 135.11 | 135.12 | 135.09 | 135.11 | 53000.0 |
| 2011-07-22 07:26:00 | SPY | ETF | 135.08 | 135.08 | 135.05 | 135.05 | 600.0 |
| 2011-07-22 07:27:00 | SPY | ETF | 135.05 | 135.09 | 135.05 | 135.09 | 1100.0 |
> showing 50 of 100,737 rows — these rows as CSV