PREVIEW / etf_1min / 2010-03-02
file: by_date/etf_1min/2010/2010-03-02.parquet size: 1.7 MB rows: 98,260
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-02 04:20:00 | SPY | ETF | 111.81 | 111.81 | 111.81 | 111.81 | 100.0 |
| 2010-03-02 04:25:00 | SPY | ETF | 111.82 | 111.82 | 111.82 | 111.82 | 100.0 |
| 2010-03-02 04:34:00 | SPY | ETF | 111.92 | 111.92 | 111.92 | 111.92 | 100.0 |
| 2010-03-02 04:38:00 | SPY | ETF | 111.92 | 111.92 | 111.92 | 111.92 | 200.0 |
| 2010-03-02 04:41:00 | SPY | ETF | 111.9 | 111.9 | 111.9 | 111.9 | 300.0 |
| 2010-03-02 04:42:00 | SPY | ETF | 111.93 | 111.93 | 111.93 | 111.93 | 5000.0 |
| 2010-03-02 05:50:00 | SPY | ETF | 111.98 | 111.98 | 111.98 | 111.98 | 3500.0 |
| 2010-03-02 05:53:00 | SPY | ETF | 111.98 | 111.98 | 111.98 | 111.98 | 300.0 |
| 2010-03-02 06:02:00 | SPY | ETF | 112.18 | 112.18 | 112.18 | 112.18 | 100.0 |
| 2010-03-02 06:07:00 | SPY | ETF | 112.21 | 112.21 | 112.21 | 112.21 | 500.0 |
| 2010-03-02 06:11:00 | SPY | ETF | 112.21 | 112.21 | 112.21 | 112.21 | 4200.0 |
| 2010-03-02 06:13:00 | SPY | ETF | 112.18 | 112.18 | 112.18 | 112.18 | 100.0 |
| 2010-03-02 06:15:00 | SPY | ETF | 112.19 | 112.19 | 112.19 | 112.19 | 4100.0 |
| 2010-03-02 06:16:00 | SPY | ETF | 112.18 | 112.19 | 112.18 | 112.19 | 5700.0 |
| 2010-03-02 06:17:00 | SPY | ETF | 112.19 | 112.19 | 112.19 | 112.19 | 1000.0 |
| 2010-03-02 06:20:00 | SPY | ETF | 112.18 | 112.23 | 112.18 | 112.23 | 8900.0 |
| 2010-03-02 06:22:00 | SPY | ETF | 112.21 | 112.21 | 112.21 | 112.21 | 2100.0 |
| 2010-03-02 06:24:00 | SPY | ETF | 112.2 | 112.2 | 112.2 | 112.2 | 1000.0 |
| 2010-03-02 06:26:00 | SPY | ETF | 112.28 | 112.3 | 112.28 | 112.3 | 1600.0 |
| 2010-03-02 06:27:00 | SPY | ETF | 112.28 | 112.28 | 112.27 | 112.27 | 4000.0 |
| 2010-03-02 06:28:00 | SPY | ETF | 112.3 | 112.3 | 112.3 | 112.3 | 500.0 |
| 2010-03-02 06:29:00 | SPY | ETF | 112.3 | 112.3 | 112.3 | 112.3 | 1000.0 |
| 2010-03-02 06:30:00 | SPY | ETF | 112.28 | 112.28 | 112.28 | 112.28 | 1500.0 |
| 2010-03-02 06:31:00 | SPY | ETF | 112.27 | 112.27 | 112.27 | 112.27 | 500.0 |
| 2010-03-02 06:32:00 | SPY | ETF | 112.32 | 112.35 | 112.32 | 112.35 | 300.0 |
| 2010-03-02 06:33:00 | SPY | ETF | 112.39 | 112.39 | 112.39 | 112.39 | 1000.0 |
| 2010-03-02 06:38:00 | SPY | ETF | 112.36 | 112.38 | 112.36 | 112.38 | 600.0 |
| 2010-03-02 06:41:00 | SPY | ETF | 112.41 | 112.41 | 112.41 | 112.41 | 300.0 |
| 2010-03-02 06:42:00 | SPY | ETF | 112.43 | 112.43 | 112.43 | 112.43 | 100.0 |
| 2010-03-02 06:44:00 | SPY | ETF | 112.45 | 112.45 | 112.45 | 112.45 | 350.0 |
| 2010-03-02 06:45:00 | SPY | ETF | 112.5 | 112.51 | 112.5 | 112.51 | 300.0 |
| 2010-03-02 06:47:00 | SPY | ETF | 112.51 | 112.51 | 112.51 | 112.51 | 500.0 |
| 2010-03-02 06:48:00 | SPY | ETF | 112.51 | 112.68 | 112.51 | 112.68 | 26300.0 |
| 2010-03-02 06:49:00 | SPY | ETF | 112.56 | 112.56 | 112.55 | 112.55 | 13400.0 |
| 2010-03-02 06:50:00 | SPY | ETF | 112.54 | 112.54 | 112.48 | 112.53 | 24100.0 |
| 2010-03-02 06:51:00 | SPY | ETF | 112.53 | 112.53 | 112.5 | 112.5 | 25000.0 |
| 2010-03-02 06:53:00 | SPY | ETF | 112.53 | 112.53 | 112.53 | 112.53 | 1200.0 |
| 2010-03-02 06:55:00 | SPY | ETF | 112.46 | 112.46 | 112.46 | 112.46 | 300.0 |
| 2010-03-02 06:56:00 | SPY | ETF | 112.47 | 112.47 | 112.46 | 112.46 | 2700.0 |
| 2010-03-02 06:57:00 | SPY | ETF | 112.4 | 112.41 | 112.4 | 112.41 | 4995.0 |
| 2010-03-02 06:58:00 | SPY | ETF | 112.41 | 112.41 | 112.41 | 112.41 | 200.0 |
| 2010-03-02 07:00:00 | SPY | ETF | 112.45 | 112.45 | 112.45 | 112.45 | 100.0 |
| 2010-03-02 07:01:00 | SPY | ETF | 112.43 | 112.43 | 112.43 | 112.43 | 100.0 |
| 2010-03-02 07:02:00 | SPY | ETF | 112.43 | 112.44 | 112.43 | 112.43 | 107300.0 |
| 2010-03-02 07:03:00 | SPY | ETF | 112.41 | 112.41 | 112.41 | 112.41 | 500.0 |
| 2010-03-02 07:04:00 | SPY | ETF | 112.41 | 112.47 | 112.41 | 112.47 | 12700.0 |
| 2010-03-02 07:05:00 | SPY | ETF | 112.47 | 112.47 | 112.46 | 112.46 | 10702.0 |
| 2010-03-02 07:06:00 | SPY | ETF | 112.45 | 112.47 | 112.45 | 112.46 | 7057.0 |
| 2010-03-02 07:07:00 | SPY | ETF | 112.47 | 112.52 | 112.46 | 112.52 | 5978.0 |
| 2010-03-02 07:08:00 | SPY | ETF | 112.5 | 112.52 | 112.49 | 112.49 | 824.0 |
> showing 50 of 98,260 rows — these rows as CSV