PREVIEW / etf_5min / 2007-06-26
file: by_date/etf_5min/2007/2007-06-26.parquet size: 342 KB rows: 17,463
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-26 05:00:00 | SPY | ETF | 149.83 | 149.83 | 149.83 | 149.83 | 5000.0 |
| 2007-06-26 06:05:00 | SPY | ETF | 150.06 | 150.06 | 150.06 | 150.06 | 12500.0 |
| 2007-06-26 06:10:00 | SPY | ETF | 150.11 | 150.11 | 150.11 | 150.11 | 5000.0 |
| 2007-06-26 06:15:00 | SPY | ETF | 150.09 | 150.09 | 150.09 | 150.09 | 1500.0 |
| 2007-06-26 06:35:00 | SPY | ETF | 150.03 | 150.03 | 150.03 | 150.03 | 2500.0 |
| 2007-06-26 06:55:00 | SPY | ETF | 150.03 | 150.03 | 150.03 | 150.03 | 2500.0 |
| 2007-06-26 07:00:00 | SPY | ETF | 150.13 | 150.16 | 150.13 | 150.16 | 600.0 |
| 2007-06-26 07:05:00 | SPY | ETF | 150.18 | 150.18 | 150.13 | 150.13 | 60000.0 |
| 2007-06-26 07:10:00 | SPY | ETF | 150.18 | 150.2 | 150.18 | 150.2 | 60100.0 |
| 2007-06-26 07:15:00 | SPY | ETF | 150.2 | 150.27 | 150.17 | 150.27 | 61700.0 |
| 2007-06-26 07:20:00 | SPY | ETF | 150.2 | 150.2 | 150.2 | 150.2 | 10600.0 |
| 2007-06-26 07:25:00 | SPY | ETF | 150.2 | 150.26 | 150.2 | 150.26 | 14100.0 |
| 2007-06-26 07:30:00 | SPY | ETF | 150.27 | 150.28 | 150.21 | 150.24 | 78700.0 |
| 2007-06-26 07:35:00 | SPY | ETF | 150.25 | 150.3 | 150.25 | 150.29 | 21200.0 |
| 2007-06-26 07:40:00 | SPY | ETF | 150.26 | 150.29 | 150.26 | 150.28 | 5400.0 |
| 2007-06-26 07:45:00 | SPY | ETF | 150.26 | 150.35 | 150.26 | 150.35 | 79100.0 |
| 2007-06-26 07:50:00 | SPY | ETF | 150.35 | 150.37 | 150.28 | 150.28 | 22500.0 |
| 2007-06-26 07:55:00 | SPY | ETF | 150.3 | 150.3 | 150.22 | 150.27 | 108900.0 |
| 2007-06-26 08:00:00 | SPY | ETF | 150.23 | 150.25 | 150.15 | 150.16 | 648300.0 |
| 2007-06-26 08:05:00 | SPY | ETF | 150.23 | 150.23 | 150.09 | 150.15 | 438200.0 |
| 2007-06-26 08:10:00 | SPY | ETF | 150.15 | 150.22 | 150.15 | 150.2 | 269900.0 |
| 2007-06-26 08:15:00 | SPY | ETF | 150.2 | 150.23 | 150.09 | 150.12 | 159700.0 |
| 2007-06-26 08:20:00 | SPY | ETF | 150.13 | 150.13 | 150.09 | 150.13 | 41400.0 |
| 2007-06-26 08:25:00 | SPY | ETF | 150.15 | 150.3 | 150.15 | 150.3 | 726600.0 |
| 2007-06-26 08:30:00 | SPY | ETF | 150.25 | 150.25 | 150.19 | 150.22 | 610500.0 |
| 2007-06-26 08:35:00 | SPY | ETF | 150.22 | 150.23 | 150.19 | 150.21 | 113300.0 |
| 2007-06-26 08:40:00 | SPY | ETF | 150.21 | 150.21 | 150.08 | 150.13 | 33500.0 |
| 2007-06-26 08:45:00 | SPY | ETF | 150.13 | 150.18 | 150.13 | 150.17 | 28600.0 |
| 2007-06-26 08:50:00 | SPY | ETF | 150.18 | 150.18 | 150.14 | 150.14 | 24600.0 |
| 2007-06-26 08:55:00 | SPY | ETF | 150.16 | 150.16 | 150.11 | 150.11 | 32000.0 |
| 2007-06-26 09:00:00 | SPY | ETF | 150.16 | 150.21 | 150.14 | 150.2 | 63600.0 |
| 2007-06-26 09:05:00 | SPY | ETF | 150.2 | 150.3 | 150.2 | 150.29 | 505800.0 |
| 2007-06-26 09:10:00 | SPY | ETF | 150.29 | 150.3 | 150.23 | 150.26 | 229600.0 |
| 2007-06-26 09:15:00 | SPY | ETF | 150.26 | 150.3 | 150.26 | 150.27 | 97800.0 |
| 2007-06-26 09:20:00 | SPY | ETF | 150.27 | 150.28 | 150.22 | 150.25 | 112200.0 |
| 2007-06-26 09:25:00 | SPY | ETF | 150.26 | 150.3 | 150.21 | 150.21 | 244100.0 |
| 2007-06-26 09:30:00 | SPY | ETF | 150.21 | 150.28 | 150.12 | 150.12 | 3199092.0 |
| 2007-06-26 09:35:00 | SPY | ETF | 150.12 | 150.3 | 149.98 | 150.23 | 3638407.0 |
| 2007-06-26 09:40:00 | SPY | ETF | 150.23 | 150.28 | 150.16 | 150.21 | 1951307.0 |
| 2007-06-26 09:45:00 | SPY | ETF | 150.21 | 150.21 | 149.99 | 150.06 | 2269404.0 |
| 2007-06-26 09:50:00 | SPY | ETF | 150.06 | 150.2574 | 149.95 | 150.04 | 2003232.0 |
| 2007-06-26 09:55:00 | SPY | ETF | 150.05 | 150.21 | 150.05 | 150.14 | 1672985.0 |
| 2007-06-26 10:00:00 | SPY | ETF | 150.14 | 150.4 | 149.92 | 150.11 | 5388740.0 |
| 2007-06-26 10:05:00 | SPY | ETF | 150.1 | 150.23 | 149.94 | 150.01 | 2507895.0 |
| 2007-06-26 10:10:00 | SPY | ETF | 150.01 | 150.22 | 149.76 | 149.99 | 2985790.0 |
| 2007-06-26 10:15:00 | SPY | ETF | 149.99 | 150.02 | 149.76 | 149.79 | 3247037.0 |
| 2007-06-26 10:20:00 | SPY | ETF | 149.79 | 149.85 | 149.66 | 149.75 | 2582601.0 |
| 2007-06-26 10:25:00 | SPY | ETF | 149.75 | 149.8 | 149.41 | 149.54 | 4867178.0 |
| 2007-06-26 10:30:00 | SPY | ETF | 149.52 | 149.73 | 149.48 | 149.69 | 2255070.0 |
| 2007-06-26 10:35:00 | SPY | ETF | 149.69 | 150.2474 | 149.62 | 150.04 | 3950302.0 |
> showing 50 of 17,463 rows — these rows as CSV