PREVIEW / etf_1min / 2009-05-06
file: by_date/etf_1min/2009/2009-05-06.parquet size: 1.8 MB rows: 102,995
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-05-06 04:08:00 | SPY | ETF | 90.12 | 90.12 | 90.12 | 90.12 | 1000.0 |
| 2009-05-06 04:15:00 | SPY | ETF | 90.28 | 90.28 | 90.28 | 90.28 | 100.0 |
| 2009-05-06 04:20:00 | SPY | ETF | 90.37 | 90.37 | 90.37 | 90.37 | 200.0 |
| 2009-05-06 04:26:00 | SPY | ETF | 90.38 | 90.38 | 90.38 | 90.38 | 800.0 |
| 2009-05-06 04:30:00 | SPY | ETF | 90.33 | 90.33 | 90.33 | 90.33 | 900.0 |
| 2009-05-06 04:33:00 | SPY | ETF | 90.31 | 90.31 | 90.31 | 90.31 | 100.0 |
| 2009-05-06 04:36:00 | SPY | ETF | 90.28 | 90.28 | 90.28 | 90.28 | 200.0 |
| 2009-05-06 04:42:00 | SPY | ETF | 90.28 | 90.28 | 90.27 | 90.27 | 300.0 |
| 2009-05-06 04:50:00 | SPY | ETF | 90.34 | 90.34 | 90.34 | 90.34 | 400.0 |
| 2009-05-06 04:51:00 | SPY | ETF | 90.34 | 90.34 | 90.34 | 90.34 | 100.0 |
| 2009-05-06 05:00:00 | SPY | ETF | 90.46 | 90.46 | 90.46 | 90.46 | 300.0 |
| 2009-05-06 05:01:00 | SPY | ETF | 90.46 | 90.46 | 90.46 | 90.46 | 300.0 |
| 2009-05-06 05:02:00 | SPY | ETF | 90.44 | 90.44 | 90.44 | 90.44 | 100.0 |
| 2009-05-06 05:13:00 | SPY | ETF | 90.52 | 90.52 | 90.52 | 90.52 | 130.0 |
| 2009-05-06 05:20:00 | SPY | ETF | 90.47 | 90.47 | 90.47 | 90.47 | 100.0 |
| 2009-05-06 05:21:00 | SPY | ETF | 90.42 | 90.42 | 90.42 | 90.42 | 300.0 |
| 2009-05-06 05:22:00 | SPY | ETF | 90.39 | 90.39 | 90.39 | 90.39 | 100.0 |
| 2009-05-06 05:47:00 | SPY | ETF | 90.49 | 90.49 | 90.49 | 90.49 | 500.0 |
| 2009-05-06 05:48:00 | SPY | ETF | 90.4 | 90.4 | 90.4 | 90.4 | 10000.0 |
| 2009-05-06 05:59:00 | SPY | ETF | 90.4 | 90.4 | 90.4 | 90.4 | 300.0 |
| 2009-05-06 06:00:00 | SPY | ETF | 90.4 | 90.4 | 90.4 | 90.4 | 100.0 |
| 2009-05-06 06:02:00 | SPY | ETF | 90.29 | 90.29 | 90.29 | 90.29 | 500.0 |
| 2009-05-06 06:12:00 | SPY | ETF | 90.25 | 90.25 | 90.23 | 90.23 | 600.0 |
| 2009-05-06 06:13:00 | SPY | ETF | 90.2 | 90.2 | 90.2 | 90.2 | 400.0 |
| 2009-05-06 06:17:00 | SPY | ETF | 90.2 | 90.2 | 90.2 | 90.2 | 100.0 |
| 2009-05-06 06:20:00 | SPY | ETF | 90.2 | 90.2 | 90.2 | 90.2 | 100.0 |
| 2009-05-06 06:24:00 | SPY | ETF | 90.25 | 90.25 | 90.25 | 90.25 | 100.0 |
| 2009-05-06 06:36:00 | SPY | ETF | 90.2 | 90.2 | 90.2 | 90.2 | 600.0 |
| 2009-05-06 06:39:00 | SPY | ETF | 90.17 | 90.17 | 90.17 | 90.17 | 800.0 |
| 2009-05-06 06:46:00 | SPY | ETF | 90.15 | 90.15 | 90.15 | 90.15 | 800.0 |
| 2009-05-06 06:49:00 | SPY | ETF | 90.1 | 90.12 | 90.1 | 90.12 | 1800.0 |
| 2009-05-06 06:51:00 | SPY | ETF | 90.15 | 90.17 | 90.14 | 90.17 | 3300.0 |
| 2009-05-06 06:52:00 | SPY | ETF | 90.2 | 90.2 | 90.2 | 90.2 | 5000.0 |
| 2009-05-06 06:53:00 | SPY | ETF | 90.22 | 90.22 | 90.22 | 90.22 | 4700.0 |
| 2009-05-06 06:54:00 | SPY | ETF | 90.18 | 90.18 | 90.18 | 90.18 | 4000.0 |
| 2009-05-06 06:55:00 | SPY | ETF | 90.16 | 90.16 | 90.14 | 90.15 | 4500.0 |
| 2009-05-06 06:56:00 | SPY | ETF | 90.18 | 90.21 | 90.18 | 90.21 | 3100.0 |
| 2009-05-06 06:57:00 | SPY | ETF | 90.22 | 90.23 | 90.22 | 90.23 | 4000.0 |
| 2009-05-06 06:58:00 | SPY | ETF | 90.26 | 90.26 | 90.25 | 90.25 | 1200.0 |
| 2009-05-06 06:59:00 | SPY | ETF | 90.27 | 90.29 | 90.27 | 90.29 | 3630.0 |
| 2009-05-06 07:00:00 | SPY | ETF | 90.29 | 90.35 | 90.29 | 90.3 | 38200.0 |
| 2009-05-06 07:01:00 | SPY | ETF | 90.29 | 90.3 | 90.29 | 90.3 | 8719.0 |
| 2009-05-06 07:02:00 | SPY | ETF | 90.22 | 90.23 | 90.21 | 90.21 | 1731.0 |
| 2009-05-06 07:03:00 | SPY | ETF | 90.22 | 90.22 | 90.21 | 90.21 | 1469.0 |
| 2009-05-06 07:04:00 | SPY | ETF | 90.21 | 90.21 | 90.18 | 90.18 | 2007.0 |
| 2009-05-06 07:05:00 | SPY | ETF | 90.18 | 90.18 | 90.15 | 90.15 | 10131.0 |
| 2009-05-06 07:06:00 | SPY | ETF | 90.16 | 90.17 | 90.15 | 90.17 | 10298.0 |
| 2009-05-06 07:07:00 | SPY | ETF | 90.15 | 90.15 | 90.13 | 90.13 | 969.0 |
| 2009-05-06 07:08:00 | SPY | ETF | 90.13 | 90.13 | 90.08 | 90.08 | 3169.0 |
| 2009-05-06 07:09:00 | SPY | ETF | 90.1 | 90.1 | 90.07 | 90.08 | 12331.0 |
> showing 50 of 102,995 rows — these rows as CSV