PREVIEW / etf_1min / 2009-01-26
file: by_date/etf_1min/2009/2009-01-26.parquet size: 1.6 MB rows: 91,554
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-26 04:20:00 | SPY | ETF | 82.86 | 82.86 | 82.86 | 82.86 | 100.0 |
| 2009-01-26 04:23:00 | SPY | ETF | 82.77 | 82.77 | 82.74 | 82.74 | 850.0 |
| 2009-01-26 04:24:00 | SPY | ETF | 82.81 | 82.81 | 82.81 | 82.81 | 100.0 |
| 2009-01-26 04:25:00 | SPY | ETF | 82.81 | 82.81 | 82.81 | 82.81 | 650.0 |
| 2009-01-26 04:26:00 | SPY | ETF | 82.7 | 82.79 | 82.7 | 82.79 | 300.0 |
| 2009-01-26 04:27:00 | SPY | ETF | 82.74 | 82.74 | 82.74 | 82.74 | 220.0 |
| 2009-01-26 04:29:00 | SPY | ETF | 82.69 | 82.69 | 82.61 | 82.61 | 950.0 |
| 2009-01-26 04:33:00 | SPY | ETF | 82.55 | 82.55 | 82.55 | 82.55 | 100.0 |
| 2009-01-26 04:58:00 | SPY | ETF | 82.56 | 82.56 | 82.56 | 82.56 | 100.0 |
| 2009-01-26 05:27:00 | SPY | ETF | 82.91 | 82.91 | 82.91 | 82.91 | 1000.0 |
| 2009-01-26 05:36:00 | SPY | ETF | 83.29 | 83.29 | 83.28 | 83.28 | 200.0 |
| 2009-01-26 05:38:00 | SPY | ETF | 83.24 | 83.24 | 83.24 | 83.24 | 100.0 |
| 2009-01-26 05:39:00 | SPY | ETF | 83.25 | 83.25 | 83.25 | 83.25 | 100.0 |
| 2009-01-26 05:42:00 | SPY | ETF | 83.28 | 83.28 | 83.28 | 83.28 | 100.0 |
| 2009-01-26 05:46:00 | SPY | ETF | 83.25 | 83.25 | 83.25 | 83.25 | 100.0 |
| 2009-01-26 05:47:00 | SPY | ETF | 83.2 | 83.2 | 83.2 | 83.2 | 100.0 |
| 2009-01-26 05:51:00 | SPY | ETF | 83.17 | 83.17 | 83.17 | 83.17 | 100.0 |
| 2009-01-26 06:06:00 | SPY | ETF | 83.02 | 83.02 | 83.0 | 83.0 | 35000.0 |
| 2009-01-26 06:10:00 | SPY | ETF | 83.05 | 83.05 | 83.05 | 83.05 | 200.0 |
| 2009-01-26 06:21:00 | SPY | ETF | 83.18 | 83.18 | 83.15 | 83.15 | 20000.0 |
| 2009-01-26 06:33:00 | SPY | ETF | 83.14 | 83.15 | 83.14 | 83.15 | 7000.0 |
| 2009-01-26 06:36:00 | SPY | ETF | 83.1 | 83.11 | 83.1 | 83.11 | 8000.0 |
| 2009-01-26 06:41:00 | SPY | ETF | 83.13 | 83.2 | 83.13 | 83.2 | 7000.0 |
| 2009-01-26 06:48:00 | SPY | ETF | 83.28 | 83.28 | 83.28 | 83.28 | 1000.0 |
| 2009-01-26 06:52:00 | SPY | ETF | 83.23 | 83.23 | 83.23 | 83.23 | 200.0 |
| 2009-01-26 06:58:00 | SPY | ETF | 83.23 | 83.23 | 83.23 | 83.23 | 1500.0 |
| 2009-01-26 06:59:00 | SPY | ETF | 83.23 | 83.23 | 83.23 | 83.23 | 500.0 |
| 2009-01-26 07:00:00 | SPY | ETF | 83.28 | 83.28 | 83.28 | 83.28 | 200.0 |
| 2009-01-26 07:01:00 | SPY | ETF | 83.18 | 83.2 | 83.18 | 83.2 | 1200.0 |
| 2009-01-26 07:02:00 | SPY | ETF | 83.2 | 83.2 | 83.13 | 83.13 | 160268.0 |
| 2009-01-26 07:03:00 | SPY | ETF | 83.13 | 83.13 | 83.1 | 83.12 | 12804.0 |
| 2009-01-26 07:04:00 | SPY | ETF | 83.09 | 83.12 | 83.09 | 83.09 | 60500.0 |
| 2009-01-26 07:06:00 | SPY | ETF | 83.17 | 83.21 | 83.17 | 83.21 | 200.0 |
| 2009-01-26 07:07:00 | SPY | ETF | 83.19 | 83.25 | 83.19 | 83.25 | 20700.0 |
| 2009-01-26 07:08:00 | SPY | ETF | 83.25 | 83.33 | 83.25 | 83.3 | 42200.0 |
| 2009-01-26 07:09:00 | SPY | ETF | 83.38 | 83.39 | 83.33 | 83.36 | 40450.0 |
| 2009-01-26 07:12:00 | SPY | ETF | 83.32 | 83.33 | 83.32 | 83.32 | 2700.0 |
| 2009-01-26 07:13:00 | SPY | ETF | 83.35 | 83.36 | 83.35 | 83.36 | 1500.0 |
| 2009-01-26 07:14:00 | SPY | ETF | 83.28 | 83.28 | 83.2 | 83.2 | 120500.0 |
| 2009-01-26 07:15:00 | SPY | ETF | 83.17 | 83.21 | 83.17 | 83.17 | 26100.0 |
| 2009-01-26 07:16:00 | SPY | ETF | 83.2 | 83.2 | 83.17 | 83.17 | 22000.0 |
| 2009-01-26 07:17:00 | SPY | ETF | 83.2 | 83.2 | 83.2 | 83.2 | 5600.0 |
| 2009-01-26 07:18:00 | SPY | ETF | 83.15 | 83.15 | 83.14 | 83.14 | 13050.0 |
| 2009-01-26 07:20:00 | SPY | ETF | 83.15 | 83.17 | 83.14 | 83.17 | 39250.0 |
| 2009-01-26 07:21:00 | SPY | ETF | 83.14 | 83.18 | 83.13 | 83.14 | 10300.0 |
| 2009-01-26 07:22:00 | SPY | ETF | 83.18 | 83.18 | 83.11 | 83.11 | 600.0 |
| 2009-01-26 07:23:00 | SPY | ETF | 83.18 | 83.21 | 83.18 | 83.21 | 3904.0 |
| 2009-01-26 07:24:00 | SPY | ETF | 83.22 | 83.22 | 83.22 | 83.22 | 500.0 |
| 2009-01-26 07:26:00 | SPY | ETF | 83.22 | 83.22 | 83.21 | 83.21 | 500.0 |
| 2009-01-26 07:27:00 | SPY | ETF | 83.22 | 83.22 | 83.22 | 83.22 | 16697.0 |
> showing 50 of 91,554 rows — these rows as CSV