PREVIEW / etf_5min / 2008-08-14
file: by_date/etf_5min/2008/2008-08-14.parquet size: 497 KB rows: 23,702
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-08-14 05:35:00 | SPY | ETF | 128.97 | 128.97 | 128.97 | 128.97 | 1000.0 |
| 2008-08-14 05:40:00 | SPY | ETF | 129.07 | 129.07 | 129.05 | 129.05 | 3000.0 |
| 2008-08-14 06:00:00 | SPY | ETF | 128.92 | 128.92 | 128.89 | 128.89 | 10000.0 |
| 2008-08-14 06:15:00 | SPY | ETF | 128.94 | 129.02 | 128.94 | 129.02 | 2200.0 |
| 2008-08-14 06:20:00 | SPY | ETF | 129.01 | 129.01 | 129.01 | 129.01 | 1000.0 |
| 2008-08-14 06:25:00 | SPY | ETF | 128.97 | 129.0 | 128.97 | 129.0 | 1500.0 |
| 2008-08-14 06:35:00 | SPY | ETF | 129.0 | 129.0 | 128.95 | 128.95 | 7000.0 |
| 2008-08-14 06:40:00 | SPY | ETF | 129.07 | 129.07 | 129.07 | 129.07 | 100.0 |
| 2008-08-14 06:45:00 | SPY | ETF | 129.07 | 129.07 | 129.07 | 129.07 | 5200.0 |
| 2008-08-14 06:50:00 | SPY | ETF | 129.0 | 129.0 | 129.0 | 129.0 | 25000.0 |
| 2008-08-14 07:00:00 | SPY | ETF | 129.03 | 129.09 | 128.97 | 129.0 | 21200.0 |
| 2008-08-14 07:05:00 | SPY | ETF | 129.0 | 129.05 | 128.99 | 129.05 | 74800.0 |
| 2008-08-14 07:10:00 | SPY | ETF | 129.05 | 129.09 | 129.05 | 129.09 | 10808.0 |
| 2008-08-14 07:15:00 | SPY | ETF | 129.12 | 129.15 | 129.1 | 129.12 | 6400.0 |
| 2008-08-14 07:20:00 | SPY | ETF | 129.11 | 129.11 | 129.03 | 129.05 | 1800.0 |
| 2008-08-14 07:25:00 | SPY | ETF | 129.05 | 129.06 | 129.0 | 129.06 | 35200.0 |
| 2008-08-14 07:30:00 | SPY | ETF | 129.03 | 129.08 | 129.03 | 129.07 | 105756.0 |
| 2008-08-14 07:35:00 | SPY | ETF | 129.1 | 129.12 | 129.06 | 129.1 | 40577.0 |
| 2008-08-14 07:40:00 | SPY | ETF | 129.11 | 129.12 | 129.09 | 129.12 | 41000.0 |
| 2008-08-14 07:45:00 | SPY | ETF | 129.11 | 129.11 | 129.04 | 129.08 | 28000.0 |
| 2008-08-14 07:50:00 | SPY | ETF | 129.04 | 129.04 | 129.04 | 129.04 | 27000.0 |
| 2008-08-14 07:55:00 | SPY | ETF | 129.06 | 129.06 | 129.03 | 129.03 | 7369.0 |
| 2008-08-14 08:00:00 | SPY | ETF | 129.05 | 129.12 | 129.04 | 129.05 | 545347.0 |
| 2008-08-14 08:05:00 | SPY | ETF | 129.04 | 129.04 | 129.02 | 129.02 | 10400.0 |
| 2008-08-14 08:10:00 | SPY | ETF | 129.01 | 129.03 | 128.96 | 128.96 | 82912.0 |
| 2008-08-14 08:15:00 | SPY | ETF | 128.96 | 129.02 | 128.96 | 129.0 | 403058.0 |
| 2008-08-14 08:20:00 | SPY | ETF | 129.01 | 129.02 | 128.99 | 129.0 | 59582.0 |
| 2008-08-14 08:25:00 | SPY | ETF | 129.0 | 129.15 | 129.0 | 129.1 | 449141.0 |
| 2008-08-14 08:30:00 | SPY | ETF | 129.0 | 129.1 | 128.08 | 128.15 | 4096009.0 |
| 2008-08-14 08:35:00 | SPY | ETF | 128.15 | 128.19 | 127.95 | 128.05 | 1700061.0 |
| 2008-08-14 08:40:00 | SPY | ETF | 128.05 | 128.18 | 127.88 | 127.96 | 1599942.0 |
| 2008-08-14 08:45:00 | SPY | ETF | 127.97 | 128.14 | 127.96 | 128.09 | 345755.0 |
| 2008-08-14 08:50:00 | SPY | ETF | 128.09 | 128.16 | 127.88 | 127.98 | 399868.0 |
| 2008-08-14 08:55:00 | SPY | ETF | 127.98 | 128.0 | 127.86 | 127.96 | 210194.0 |
| 2008-08-14 09:00:00 | SPY | ETF | 127.97 | 128.13 | 127.92 | 128.12 | 358056.0 |
| 2008-08-14 09:05:00 | SPY | ETF | 128.13 | 128.13 | 127.97 | 128.06 | 775436.0 |
| 2008-08-14 09:10:00 | SPY | ETF | 128.07 | 128.07 | 127.97 | 128.02 | 386816.0 |
| 2008-08-14 09:15:00 | SPY | ETF | 128.03 | 128.03 | 127.94 | 127.95 | 77662.0 |
| 2008-08-14 09:20:00 | SPY | ETF | 127.96 | 127.96 | 127.8 | 127.9 | 289244.0 |
| 2008-08-14 09:25:00 | SPY | ETF | 127.91 | 127.91 | 127.81 | 127.84 | 247807.0 |
| 2008-08-14 09:30:00 | SPY | ETF | 127.84 | 128.01 | 127.75 | 127.94 | 4545939.0 |
| 2008-08-14 09:35:00 | SPY | ETF | 127.94 | 128.17 | 127.9 | 128.07 | 3710714.0 |
| 2008-08-14 09:40:00 | SPY | ETF | 128.06 | 128.27 | 128.04 | 128.17 | 3807551.0 |
| 2008-08-14 09:45:00 | SPY | ETF | 128.16 | 128.25 | 127.9 | 127.9 | 4762009.0 |
| 2008-08-14 09:50:00 | SPY | ETF | 127.905 | 128.17 | 127.86 | 128.16 | 3168356.0 |
| 2008-08-14 09:55:00 | SPY | ETF | 128.16 | 128.5 | 127.99 | 128.45 | 4214979.0 |
| 2008-08-14 10:00:00 | SPY | ETF | 128.45 | 128.6 | 128.17 | 128.46 | 4649702.0 |
| 2008-08-14 10:05:00 | SPY | ETF | 128.461 | 128.68 | 128.41 | 128.44 | 3763176.0 |
| 2008-08-14 10:10:00 | SPY | ETF | 128.45 | 128.53 | 128.34 | 128.44 | 4215029.0 |
| 2008-08-14 10:15:00 | SPY | ETF | 128.43 | 128.67 | 128.4 | 128.65 | 2267165.0 |
> showing 50 of 23,702 rows — these rows as CSV