PREVIEW / etf_5min / 2010-07-02
file: by_date/etf_5min/2010/2010-07-02.parquet size: 789 KB rows: 32,966
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-02 04:15:00 | SPY | ETF | 102.82 | 102.82 | 102.82 | 102.82 | 100.0 |
| 2010-07-02 05:30:00 | SPY | ETF | 102.71 | 102.71 | 102.71 | 102.71 | 100.0 |
| 2010-07-02 05:40:00 | SPY | ETF | 102.64 | 102.72 | 102.64 | 102.72 | 1200.0 |
| 2010-07-02 05:45:00 | SPY | ETF | 102.76 | 102.76 | 102.76 | 102.76 | 1400.0 |
| 2010-07-02 05:50:00 | SPY | ETF | 102.8 | 102.8 | 102.8 | 102.8 | 200.0 |
| 2010-07-02 05:55:00 | SPY | ETF | 102.8 | 102.8 | 102.8 | 102.8 | 100.0 |
| 2010-07-02 06:00:00 | SPY | ETF | 102.8 | 102.84 | 102.8 | 102.84 | 1100.0 |
| 2010-07-02 06:05:00 | SPY | ETF | 102.84 | 102.88 | 102.84 | 102.88 | 3200.0 |
| 2010-07-02 06:10:00 | SPY | ETF | 102.84 | 102.84 | 102.84 | 102.84 | 9000.0 |
| 2010-07-02 06:15:00 | SPY | ETF | 102.83 | 102.84 | 102.81 | 102.81 | 4600.0 |
| 2010-07-02 06:20:00 | SPY | ETF | 102.8 | 102.8 | 102.8 | 102.8 | 2000.0 |
| 2010-07-02 06:40:00 | SPY | ETF | 102.79 | 102.79 | 102.79 | 102.79 | 300.0 |
| 2010-07-02 06:45:00 | SPY | ETF | 102.76 | 102.76 | 102.7 | 102.7 | 2100.0 |
| 2010-07-02 06:50:00 | SPY | ETF | 102.67 | 102.67 | 102.67 | 102.67 | 1000.0 |
| 2010-07-02 06:55:00 | SPY | ETF | 102.67 | 102.67 | 102.67 | 102.67 | 2000.0 |
| 2010-07-02 07:00:00 | SPY | ETF | 102.67 | 102.72 | 102.67 | 102.68 | 4976.0 |
| 2010-07-02 07:05:00 | SPY | ETF | 102.68 | 102.75 | 102.66 | 102.73 | 31926.0 |
| 2010-07-02 07:10:00 | SPY | ETF | 102.76 | 102.77 | 102.73 | 102.73 | 7425.0 |
| 2010-07-02 07:15:00 | SPY | ETF | 102.73 | 102.75 | 102.73 | 102.75 | 64200.0 |
| 2010-07-02 07:20:00 | SPY | ETF | 102.79 | 102.79 | 102.76 | 102.78 | 37100.0 |
| 2010-07-02 07:25:00 | SPY | ETF | 102.78 | 102.87 | 102.78 | 102.87 | 9600.0 |
| 2010-07-02 07:30:00 | SPY | ETF | 102.84 | 102.91 | 102.84 | 102.91 | 47100.0 |
| 2010-07-02 07:35:00 | SPY | ETF | 102.91 | 102.92 | 102.88 | 102.88 | 107800.0 |
| 2010-07-02 07:40:00 | SPY | ETF | 102.89 | 102.92 | 102.88 | 102.91 | 33900.0 |
| 2010-07-02 07:45:00 | SPY | ETF | 102.91 | 103.0 | 102.91 | 103.0 | 62600.0 |
| 2010-07-02 07:50:00 | SPY | ETF | 102.97 | 103.0 | 102.93 | 102.98 | 70900.0 |
| 2010-07-02 07:55:00 | SPY | ETF | 103.0 | 103.03 | 102.98 | 103.02 | 201050.0 |
| 2010-07-02 08:00:00 | SPY | ETF | 103.0 | 103.35 | 102.71 | 102.71 | 999420.0 |
| 2010-07-02 08:05:00 | SPY | ETF | 102.96 | 103.04 | 102.93 | 102.96 | 198340.0 |
| 2010-07-02 08:10:00 | SPY | ETF | 102.97 | 103.01 | 102.93 | 102.96 | 127026.0 |
| 2010-07-02 08:15:00 | SPY | ETF | 102.97 | 102.99 | 102.83 | 102.96 | 627839.0 |
| 2010-07-02 08:20:00 | SPY | ETF | 102.95 | 103.11 | 102.92 | 103.06 | 402705.0 |
| 2010-07-02 08:25:00 | SPY | ETF | 103.07 | 103.48 | 102.83 | 103.48 | 1124398.0 |
| 2010-07-02 08:30:00 | SPY | ETF | 103.41 | 103.75 | 102.62 | 102.92 | 8156610.0 |
| 2010-07-02 08:35:00 | SPY | ETF | 102.93 | 102.95 | 102.27 | 102.55 | 4573718.0 |
| 2010-07-02 08:40:00 | SPY | ETF | 102.55 | 103.01 | 102.54 | 103.0 | 2049488.0 |
| 2010-07-02 08:45:00 | SPY | ETF | 103.0 | 103.05 | 102.82 | 102.84 | 1676387.0 |
| 2010-07-02 08:50:00 | SPY | ETF | 102.84 | 102.91 | 102.59 | 102.79 | 910571.0 |
| 2010-07-02 08:55:00 | SPY | ETF | 102.76 | 102.81 | 102.62 | 102.67 | 537497.0 |
| 2010-07-02 09:00:00 | SPY | ETF | 102.66 | 102.86 | 102.62 | 102.83 | 325490.0 |
| 2010-07-02 09:05:00 | SPY | ETF | 102.82 | 102.91 | 102.68 | 102.9 | 628424.0 |
| 2010-07-02 09:10:00 | SPY | ETF | 102.9 | 103.02 | 102.85 | 102.96 | 704698.0 |
| 2010-07-02 09:15:00 | SPY | ETF | 102.96 | 103.23 | 102.94 | 103.14 | 1602582.0 |
| 2010-07-02 09:20:00 | SPY | ETF | 103.15 | 103.26 | 103.13 | 103.2 | 1119183.0 |
| 2010-07-02 09:25:00 | SPY | ETF | 103.19 | 103.28 | 103.11 | 103.11 | 549140.0 |
| 2010-07-02 09:30:00 | SPY | ETF | 103.11 | 103.26 | 102.88 | 103.21 | 7254796.0 |
| 2010-07-02 09:35:00 | SPY | ETF | 103.21 | 103.42 | 103.17 | 103.2501 | 4528362.0 |
| 2010-07-02 09:40:00 | SPY | ETF | 103.26 | 103.37 | 103.0 | 103.04 | 3848004.0 |
| 2010-07-02 09:45:00 | SPY | ETF | 103.05 | 103.15 | 102.88 | 102.88 | 3854806.0 |
| 2010-07-02 09:50:00 | SPY | ETF | 102.88 | 102.96 | 102.72 | 102.72 | 4151684.0 |
> showing 50 of 32,966 rows — these rows as CSV