PREVIEW / etf_1min / 2008-07-17
file: by_date/etf_1min/2008/2008-07-17.parquet size: 1.3 MB rows: 80,887
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-17 04:15:00 | SPY | ETF | 124.02 | 124.02 | 124.02 | 124.02 | 200.0 |
| 2008-07-17 04:40:00 | SPY | ETF | 123.98 | 123.98 | 123.98 | 123.98 | 100.0 |
| 2008-07-17 05:25:00 | SPY | ETF | 123.93 | 123.93 | 123.93 | 123.93 | 5000.0 |
| 2008-07-17 05:52:00 | SPY | ETF | 124.21 | 124.21 | 124.21 | 124.21 | 500.0 |
| 2008-07-17 05:55:00 | SPY | ETF | 124.2 | 124.2 | 124.2 | 124.2 | 1000.0 |
| 2008-07-17 05:58:00 | SPY | ETF | 124.22 | 124.29 | 124.22 | 124.29 | 200.0 |
| 2008-07-17 05:59:00 | SPY | ETF | 124.29 | 124.29 | 124.29 | 124.29 | 1400.0 |
| 2008-07-17 06:00:00 | SPY | ETF | 124.25 | 124.25 | 124.25 | 124.25 | 500.0 |
| 2008-07-17 06:02:00 | SPY | ETF | 124.25 | 124.25 | 124.25 | 124.25 | 500.0 |
| 2008-07-17 06:03:00 | SPY | ETF | 124.3 | 124.3 | 124.28 | 124.28 | 600.0 |
| 2008-07-17 06:04:00 | SPY | ETF | 124.25 | 124.25 | 124.25 | 124.25 | 100000.0 |
| 2008-07-17 06:05:00 | SPY | ETF | 124.33 | 124.33 | 124.31 | 124.31 | 1000.0 |
| 2008-07-17 06:06:00 | SPY | ETF | 124.31 | 124.31 | 124.31 | 124.31 | 500.0 |
| 2008-07-17 06:09:00 | SPY | ETF | 124.22 | 124.22 | 124.22 | 124.22 | 100.0 |
| 2008-07-17 06:12:00 | SPY | ETF | 124.28 | 124.28 | 124.28 | 124.28 | 2500.0 |
| 2008-07-17 06:18:00 | SPY | ETF | 124.12 | 124.12 | 124.12 | 124.12 | 100.0 |
| 2008-07-17 06:29:00 | SPY | ETF | 124.28 | 124.46 | 124.28 | 124.46 | 62600.0 |
| 2008-07-17 06:30:00 | SPY | ETF | 124.45 | 124.46 | 124.45 | 124.46 | 2500.0 |
| 2008-07-17 06:31:00 | SPY | ETF | 124.45 | 124.49 | 124.41 | 124.45 | 17000.0 |
| 2008-07-17 06:32:00 | SPY | ETF | 124.48 | 124.48 | 124.43 | 124.43 | 15000.0 |
| 2008-07-17 06:33:00 | SPY | ETF | 124.47 | 124.51 | 124.47 | 124.51 | 4000.0 |
| 2008-07-17 06:34:00 | SPY | ETF | 124.51 | 124.53 | 124.5 | 124.53 | 35000.0 |
| 2008-07-17 06:35:00 | SPY | ETF | 124.4 | 124.41 | 124.4 | 124.41 | 10000.0 |
| 2008-07-17 06:36:00 | SPY | ETF | 124.48 | 124.53 | 124.48 | 124.5 | 74500.0 |
| 2008-07-17 06:37:00 | SPY | ETF | 124.54 | 124.54 | 124.54 | 124.54 | 100.0 |
| 2008-07-17 06:38:00 | SPY | ETF | 124.56 | 124.56 | 124.56 | 124.56 | 4000.0 |
| 2008-07-17 06:41:00 | SPY | ETF | 124.66 | 124.66 | 124.66 | 124.66 | 200.0 |
| 2008-07-17 06:42:00 | SPY | ETF | 124.65 | 124.65 | 124.65 | 124.65 | 4000.0 |
| 2008-07-17 06:43:00 | SPY | ETF | 124.68 | 124.69 | 124.68 | 124.68 | 1200.0 |
| 2008-07-17 06:45:00 | SPY | ETF | 124.73 | 124.76 | 124.73 | 124.76 | 5100.0 |
| 2008-07-17 06:47:00 | SPY | ETF | 124.75 | 124.8 | 124.75 | 124.8 | 8000.0 |
| 2008-07-17 06:48:00 | SPY | ETF | 124.77 | 124.77 | 124.75 | 124.76 | 5000.0 |
| 2008-07-17 06:49:00 | SPY | ETF | 124.74 | 124.74 | 124.69 | 124.69 | 51500.0 |
| 2008-07-17 06:50:00 | SPY | ETF | 124.8 | 124.88 | 124.8 | 124.88 | 4600.0 |
| 2008-07-17 06:51:00 | SPY | ETF | 124.91 | 124.92 | 124.91 | 124.92 | 25000.0 |
| 2008-07-17 06:52:00 | SPY | ETF | 124.91 | 124.91 | 124.91 | 124.91 | 25000.0 |
| 2008-07-17 06:53:00 | SPY | ETF | 124.87 | 124.89 | 124.87 | 124.89 | 2100.0 |
| 2008-07-17 06:54:00 | SPY | ETF | 124.89 | 124.89 | 124.84 | 124.84 | 23500.0 |
| 2008-07-17 06:55:00 | SPY | ETF | 124.8 | 124.9 | 124.76 | 124.9 | 26000.0 |
| 2008-07-17 06:56:00 | SPY | ETF | 124.84 | 124.84 | 124.83 | 124.83 | 41200.0 |
| 2008-07-17 06:57:00 | SPY | ETF | 124.8 | 124.8 | 124.8 | 124.8 | 14800.0 |
| 2008-07-17 06:58:00 | SPY | ETF | 124.8 | 124.8 | 124.8 | 124.8 | 400.0 |
| 2008-07-17 06:59:00 | SPY | ETF | 124.81 | 124.81 | 124.79 | 124.79 | 6000.0 |
| 2008-07-17 07:00:00 | SPY | ETF | 124.9 | 125.26 | 124.9 | 125.26 | 5400.0 |
| 2008-07-17 07:01:00 | SPY | ETF | 125.25 | 125.28 | 125.08 | 125.08 | 67750.0 |
| 2008-07-17 07:02:00 | SPY | ETF | 125.09 | 125.1 | 125.04 | 125.04 | 48800.0 |
| 2008-07-17 07:03:00 | SPY | ETF | 125.09 | 125.25 | 125.09 | 125.25 | 94741.0 |
| 2008-07-17 07:04:00 | SPY | ETF | 125.29 | 125.29 | 125.27 | 125.27 | 13459.0 |
| 2008-07-17 07:05:00 | SPY | ETF | 125.26 | 125.26 | 125.09 | 125.09 | 45766.0 |
| 2008-07-17 07:06:00 | SPY | ETF | 125.09 | 125.14 | 125.09 | 125.13 | 61500.0 |
> showing 50 of 80,887 rows — these rows as CSV