PREVIEW / etf_5min / 2008-10-08
file: by_date/etf_5min/2008/2008-10-08.parquet size: 616 KB rows: 28,852
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-10-08 04:05:00 | SPY | ETF | 96.86 | 96.88 | 96.86 | 96.88 | 1100.0 |
| 2008-10-08 04:15:00 | SPY | ETF | 97.12 | 97.13 | 96.92 | 97.06 | 5200.0 |
| 2008-10-08 04:20:00 | SPY | ETF | 97.06 | 97.06 | 96.4 | 96.4 | 4200.0 |
| 2008-10-08 04:25:00 | SPY | ETF | 96.41 | 96.99 | 96.41 | 96.99 | 300.0 |
| 2008-10-08 04:30:00 | SPY | ETF | 97.46 | 97.46 | 97.0 | 97.0 | 300.0 |
| 2008-10-08 04:45:00 | SPY | ETF | 97.38 | 97.69 | 97.38 | 97.69 | 1300.0 |
| 2008-10-08 04:50:00 | SPY | ETF | 97.74 | 98.07 | 97.74 | 98.07 | 2500.0 |
| 2008-10-08 05:10:00 | SPY | ETF | 98.1 | 98.1 | 98.1 | 98.1 | 600.0 |
| 2008-10-08 05:20:00 | SPY | ETF | 97.76 | 97.76 | 97.58 | 97.63 | 4200.0 |
| 2008-10-08 05:25:00 | SPY | ETF | 97.71 | 97.71 | 97.71 | 97.71 | 1000.0 |
| 2008-10-08 05:30:00 | SPY | ETF | 97.88 | 97.88 | 97.88 | 97.88 | 100.0 |
| 2008-10-08 05:35:00 | SPY | ETF | 97.57 | 97.57 | 96.89 | 96.89 | 3600.0 |
| 2008-10-08 05:40:00 | SPY | ETF | 96.86 | 97.4 | 96.86 | 97.4 | 1100.0 |
| 2008-10-08 05:45:00 | SPY | ETF | 97.35 | 97.36 | 97.2 | 97.2 | 900.0 |
| 2008-10-08 05:50:00 | SPY | ETF | 97.59 | 97.59 | 97.59 | 97.59 | 200.0 |
| 2008-10-08 05:55:00 | SPY | ETF | 97.43 | 97.9 | 97.43 | 97.6 | 32000.0 |
| 2008-10-08 06:00:00 | SPY | ETF | 97.7 | 97.7 | 97.7 | 97.7 | 600.0 |
| 2008-10-08 06:05:00 | SPY | ETF | 97.52 | 97.66 | 97.52 | 97.66 | 688.0 |
| 2008-10-08 06:10:00 | SPY | ETF | 98.03 | 98.5 | 98.03 | 98.5 | 28200.0 |
| 2008-10-08 06:15:00 | SPY | ETF | 98.6 | 98.76 | 98.6 | 98.76 | 900.0 |
| 2008-10-08 06:20:00 | SPY | ETF | 98.65 | 98.82 | 98.64 | 98.82 | 11400.0 |
| 2008-10-08 06:25:00 | SPY | ETF | 98.89 | 99.01 | 98.89 | 98.94 | 13600.0 |
| 2008-10-08 06:30:00 | SPY | ETF | 98.87 | 98.87 | 98.43 | 98.75 | 93800.0 |
| 2008-10-08 06:35:00 | SPY | ETF | 98.75 | 99.31 | 98.75 | 99.31 | 170600.0 |
| 2008-10-08 06:40:00 | SPY | ETF | 99.4 | 99.56 | 99.09 | 99.09 | 133850.0 |
| 2008-10-08 06:45:00 | SPY | ETF | 99.06 | 99.38 | 99.0 | 99.28 | 77800.0 |
| 2008-10-08 06:50:00 | SPY | ETF | 99.3 | 99.31 | 98.85 | 98.85 | 75500.0 |
| 2008-10-08 06:55:00 | SPY | ETF | 98.78 | 99.0 | 98.78 | 98.96 | 39600.0 |
| 2008-10-08 07:00:00 | SPY | ETF | 99.12 | 104.98 | 99.12 | 102.89 | 1424204.0 |
| 2008-10-08 07:05:00 | SPY | ETF | 102.89 | 103.37 | 101.55 | 102.15 | 732048.0 |
| 2008-10-08 07:10:00 | SPY | ETF | 102.15 | 102.25 | 101.5 | 101.8 | 1002842.0 |
| 2008-10-08 07:15:00 | SPY | ETF | 101.8 | 101.91 | 101.03 | 101.25 | 938308.0 |
| 2008-10-08 07:20:00 | SPY | ETF | 101.16 | 102.07 | 101.16 | 101.75 | 1236341.0 |
| 2008-10-08 07:25:00 | SPY | ETF | 101.82 | 102.14 | 101.54 | 102.14 | 643035.0 |
| 2008-10-08 07:30:00 | SPY | ETF | 102.03 | 102.65 | 101.95 | 102.3 | 506709.0 |
| 2008-10-08 07:35:00 | SPY | ETF | 102.31 | 102.57 | 102.27 | 102.3 | 279249.0 |
| 2008-10-08 07:40:00 | SPY | ETF | 102.3 | 102.57 | 101.95 | 102.15 | 863240.0 |
| 2008-10-08 07:45:00 | SPY | ETF | 102.16 | 102.23 | 101.7 | 102.09 | 595100.0 |
| 2008-10-08 07:50:00 | SPY | ETF | 102.09 | 102.5 | 102.09 | 102.5 | 379274.0 |
| 2008-10-08 07:55:00 | SPY | ETF | 102.5 | 103.15 | 102.5 | 103.15 | 1133732.0 |
| 2008-10-08 08:00:00 | SPY | ETF | 103.14 | 104.0 | 99.55 | 103.31 | 4635538.0 |
| 2008-10-08 08:05:00 | SPY | ETF | 103.3 | 103.3 | 97.65 | 102.76 | 655267.0 |
| 2008-10-08 08:10:00 | SPY | ETF | 102.77 | 102.93 | 102.1 | 102.71 | 727430.0 |
| 2008-10-08 08:15:00 | SPY | ETF | 102.72 | 102.87 | 101.97 | 101.97 | 1065987.0 |
| 2008-10-08 08:20:00 | SPY | ETF | 101.98 | 102.14 | 101.75 | 101.8 | 1422335.0 |
| 2008-10-08 08:25:00 | SPY | ETF | 101.81 | 101.85 | 101.17 | 101.59 | 2180548.0 |
| 2008-10-08 08:30:00 | SPY | ETF | 101.6 | 101.94 | 100.9 | 100.9 | 2581741.0 |
| 2008-10-08 08:35:00 | SPY | ETF | 100.93 | 101.02 | 100.21 | 100.55 | 3466484.0 |
| 2008-10-08 08:40:00 | SPY | ETF | 100.54 | 100.73 | 99.52 | 99.64 | 3480129.0 |
| 2008-10-08 08:45:00 | SPY | ETF | 99.67 | 99.83 | 97.81 | 98.58 | 5170256.0 |
> showing 50 of 28,852 rows — these rows as CSV