PREVIEW / etf_5min / 2005-10-18
file: by_date/etf_5min/2005/2005-10-18.parquet size: 135 KB rows: 7,003
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-18 06:35:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 1000.0 |
| 2005-10-18 07:35:00 | SPY | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 300.0 |
| 2005-10-18 07:40:00 | SPY | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 60700.0 |
| 2005-10-18 07:45:00 | SPY | ETF | 119.15 | 119.15 | 119.15 | 119.15 | 50000.0 |
| 2005-10-18 07:55:00 | SPY | ETF | 119.18 | 119.18 | 119.18 | 119.18 | 20500.0 |
| 2005-10-18 08:00:00 | SPY | ETF | 119.22 | 119.25 | 119.15 | 119.18 | 679300.0 |
| 2005-10-18 08:05:00 | SPY | ETF | 119.17 | 119.17 | 119.13 | 119.13 | 2500.0 |
| 2005-10-18 08:10:00 | SPY | ETF | 119.16 | 119.2 | 119.16 | 119.17 | 200800.0 |
| 2005-10-18 08:15:00 | SPY | ETF | 119.18 | 119.2 | 119.18 | 119.19 | 81000.0 |
| 2005-10-18 08:20:00 | SPY | ETF | 119.2 | 119.2 | 119.09 | 119.09 | 18000.0 |
| 2005-10-18 08:25:00 | SPY | ETF | 119.1 | 119.12 | 119.06 | 119.06 | 34300.0 |
| 2005-10-18 08:30:00 | SPY | ETF | 119.08 | 119.08 | 118.83 | 118.91 | 1264500.0 |
| 2005-10-18 08:35:00 | SPY | ETF | 118.91 | 118.98 | 118.88 | 118.97 | 525800.0 |
| 2005-10-18 08:40:00 | SPY | ETF | 118.95 | 118.96 | 118.93 | 118.96 | 78800.0 |
| 2005-10-18 08:45:00 | SPY | ETF | 118.96 | 119.03 | 118.96 | 119.0 | 53400.0 |
| 2005-10-18 08:50:00 | SPY | ETF | 119.01 | 119.01 | 118.93 | 118.94 | 186800.0 |
| 2005-10-18 08:55:00 | SPY | ETF | 118.95 | 118.98 | 118.91 | 118.95 | 662500.0 |
| 2005-10-18 09:00:00 | SPY | ETF | 118.95 | 119.15 | 118.86 | 118.87 | 554600.0 |
| 2005-10-18 09:05:00 | SPY | ETF | 118.87 | 118.97 | 118.8 | 118.81 | 575100.0 |
| 2005-10-18 09:10:00 | SPY | ETF | 118.88 | 118.95 | 118.86 | 118.93 | 82000.0 |
| 2005-10-18 09:15:00 | SPY | ETF | 118.94 | 119.0 | 118.94 | 118.98 | 90900.0 |
| 2005-10-18 09:20:00 | SPY | ETF | 118.98 | 119.05 | 118.98 | 119.02 | 53200.0 |
| 2005-10-18 09:25:00 | SPY | ETF | 119.0 | 119.0 | 118.9 | 118.94 | 52800.0 |
| 2005-10-18 09:30:00 | SPY | ETF | 118.94 | 118.96 | 118.88 | 118.9 | 715600.0 |
| 2005-10-18 09:35:00 | SPY | ETF | 118.89 | 118.96 | 118.78 | 118.78 | 693300.0 |
| 2005-10-18 09:40:00 | SPY | ETF | 118.78 | 118.79 | 118.66 | 118.68 | 1617700.0 |
| 2005-10-18 09:45:00 | SPY | ETF | 118.69 | 118.95 | 118.63 | 118.67 | 1436000.0 |
| 2005-10-18 09:50:00 | SPY | ETF | 118.67 | 118.79 | 118.67 | 118.72 | 665100.0 |
| 2005-10-18 09:55:00 | SPY | ETF | 118.72 | 118.77 | 118.62 | 118.67 | 774600.0 |
| 2005-10-18 10:00:00 | SPY | ETF | 118.68 | 118.76 | 118.58 | 118.76 | 2278400.0 |
| 2005-10-18 10:05:00 | SPY | ETF | 118.76 | 118.85 | 118.69 | 118.85 | 1069600.0 |
| 2005-10-18 10:10:00 | SPY | ETF | 118.83 | 118.91 | 118.79 | 118.8 | 748900.0 |
| 2005-10-18 10:15:00 | SPY | ETF | 118.82 | 118.82 | 118.72 | 118.77 | 499600.0 |
| 2005-10-18 10:20:00 | SPY | ETF | 118.76 | 118.88 | 118.61 | 118.7 | 1345200.0 |
| 2005-10-18 10:25:00 | SPY | ETF | 118.7 | 118.78 | 118.65 | 118.65 | 722500.0 |
| 2005-10-18 10:30:00 | SPY | ETF | 118.65 | 118.7 | 118.57 | 118.64 | 1251500.0 |
| 2005-10-18 10:35:00 | SPY | ETF | 118.64 | 118.65 | 118.55 | 118.59 | 417000.0 |
| 2005-10-18 10:40:00 | SPY | ETF | 118.59 | 118.67 | 118.52 | 118.63 | 470300.0 |
| 2005-10-18 10:45:00 | SPY | ETF | 118.62 | 118.65 | 118.52 | 118.56 | 413800.0 |
| 2005-10-18 10:50:00 | SPY | ETF | 118.57 | 118.61 | 118.5 | 118.59 | 609600.0 |
| 2005-10-18 10:55:00 | SPY | ETF | 118.62 | 118.67 | 118.6 | 118.61 | 404500.0 |
| 2005-10-18 11:00:00 | SPY | ETF | 118.62 | 118.74 | 118.61 | 118.73 | 673200.0 |
| 2005-10-18 11:05:00 | SPY | ETF | 118.71 | 118.83 | 118.71 | 118.77 | 3473000.0 |
| 2005-10-18 11:10:00 | SPY | ETF | 118.75 | 118.81 | 118.73 | 118.77 | 673600.0 |
| 2005-10-18 11:15:00 | SPY | ETF | 118.76 | 118.89 | 118.75 | 118.75 | 1410200.0 |
| 2005-10-18 11:20:00 | SPY | ETF | 118.77 | 118.84 | 118.75 | 118.82 | 398000.0 |
| 2005-10-18 11:25:00 | SPY | ETF | 118.81 | 118.81 | 118.67 | 118.6885 | 542600.0 |
| 2005-10-18 11:30:00 | SPY | ETF | 118.69 | 118.81 | 118.68 | 118.72 | 494000.0 |
| 2005-10-18 11:35:00 | SPY | ETF | 118.75 | 118.78 | 118.61 | 118.66 | 1517600.0 |
| 2005-10-18 11:40:00 | SPY | ETF | 118.67 | 118.74 | 118.63 | 118.74 | 293100.0 |
> showing 50 of 7,003 rows — these rows as CSV