PREVIEW / etf_5min / 2009-12-30
file: by_date/etf_5min/2009/2009-12-30.parquet size: 668 KB rows: 29,437
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-30 04:25:00 | SPY | ETF | 112.29 | 112.29 | 112.29 | 112.29 | 200.0 |
| 2009-12-30 04:30:00 | SPY | ETF | 112.23 | 112.23 | 111.92 | 111.92 | 4556.0 |
| 2009-12-30 04:35:00 | SPY | ETF | 111.99 | 111.99 | 111.98 | 111.98 | 200.0 |
| 2009-12-30 04:40:00 | SPY | ETF | 112.03 | 112.03 | 112.0 | 112.0 | 200.0 |
| 2009-12-30 04:55:00 | SPY | ETF | 112.03 | 112.03 | 112.03 | 112.03 | 200.0 |
| 2009-12-30 05:05:00 | SPY | ETF | 111.99 | 111.99 | 111.99 | 111.99 | 100.0 |
| 2009-12-30 05:10:00 | SPY | ETF | 111.9 | 111.9 | 111.9 | 111.9 | 2000.0 |
| 2009-12-30 05:25:00 | SPY | ETF | 111.9 | 111.9 | 111.9 | 111.9 | 200.0 |
| 2009-12-30 05:40:00 | SPY | ETF | 112.0 | 112.0 | 112.0 | 112.0 | 2000.0 |
| 2009-12-30 05:45:00 | SPY | ETF | 112.0 | 112.0 | 112.0 | 112.0 | 100.0 |
| 2009-12-30 06:15:00 | SPY | ETF | 111.75 | 111.82 | 111.75 | 111.82 | 200.0 |
| 2009-12-30 06:30:00 | SPY | ETF | 111.91 | 111.91 | 111.91 | 111.91 | 500.0 |
| 2009-12-30 06:50:00 | SPY | ETF | 111.88 | 111.88 | 111.88 | 111.88 | 2600.0 |
| 2009-12-30 07:00:00 | SPY | ETF | 111.87 | 111.87 | 111.87 | 111.87 | 575.0 |
| 2009-12-30 07:05:00 | SPY | ETF | 111.95 | 111.98 | 111.95 | 111.98 | 1000.0 |
| 2009-12-30 07:10:00 | SPY | ETF | 111.96 | 112.02 | 111.96 | 112.02 | 800.0 |
| 2009-12-30 07:15:00 | SPY | ETF | 112.0 | 112.01 | 111.96 | 112.0 | 35690.0 |
| 2009-12-30 07:20:00 | SPY | ETF | 112.01 | 112.02 | 112.0 | 112.02 | 76800.0 |
| 2009-12-30 07:25:00 | SPY | ETF | 112.0 | 112.0 | 111.99 | 112.0 | 4700.0 |
| 2009-12-30 07:30:00 | SPY | ETF | 112.05 | 112.05 | 112.01 | 112.04 | 2600.0 |
| 2009-12-30 07:35:00 | SPY | ETF | 112.07 | 112.12 | 112.07 | 112.11 | 4400.0 |
| 2009-12-30 07:40:00 | SPY | ETF | 112.12 | 112.15 | 112.1 | 112.15 | 105100.0 |
| 2009-12-30 07:45:00 | SPY | ETF | 112.17 | 112.19 | 112.14 | 112.14 | 3200.0 |
| 2009-12-30 07:50:00 | SPY | ETF | 112.14 | 112.15 | 112.14 | 112.15 | 2150.0 |
| 2009-12-30 07:55:00 | SPY | ETF | 112.12 | 112.14 | 112.12 | 112.12 | 134122.0 |
| 2009-12-30 08:00:00 | SPY | ETF | 112.11 | 112.13 | 112.09 | 112.09 | 44918.0 |
| 2009-12-30 08:05:00 | SPY | ETF | 112.09 | 112.11 | 112.09 | 112.1 | 31227.0 |
| 2009-12-30 08:10:00 | SPY | ETF | 112.1 | 112.11 | 112.09 | 112.11 | 8538.0 |
| 2009-12-30 08:15:00 | SPY | ETF | 112.11 | 112.16 | 112.1 | 112.13 | 144623.0 |
| 2009-12-30 08:20:00 | SPY | ETF | 112.13 | 112.17 | 112.12 | 112.13 | 45229.0 |
| 2009-12-30 08:25:00 | SPY | ETF | 112.15 | 112.15 | 112.12 | 112.13 | 55560.0 |
| 2009-12-30 08:30:00 | SPY | ETF | 112.14 | 112.14 | 112.11 | 112.12 | 77474.0 |
| 2009-12-30 08:35:00 | SPY | ETF | 112.12 | 112.18 | 112.12 | 112.18 | 52363.0 |
| 2009-12-30 08:40:00 | SPY | ETF | 112.18 | 112.21 | 112.17 | 112.17 | 92188.0 |
| 2009-12-30 08:45:00 | SPY | ETF | 112.17 | 112.2 | 112.17 | 112.19 | 23353.0 |
| 2009-12-30 08:50:00 | SPY | ETF | 112.2 | 112.21 | 112.18 | 112.2 | 13860.0 |
| 2009-12-30 08:55:00 | SPY | ETF | 112.18 | 112.21 | 112.18 | 112.2 | 22574.0 |
| 2009-12-30 09:00:00 | SPY | ETF | 112.21 | 112.21 | 112.17 | 112.19 | 21297.0 |
| 2009-12-30 09:05:00 | SPY | ETF | 112.18 | 112.19 | 112.16 | 112.17 | 29350.0 |
| 2009-12-30 09:10:00 | SPY | ETF | 112.16 | 112.18 | 112.16 | 112.18 | 19608.0 |
| 2009-12-30 09:15:00 | SPY | ETF | 112.18 | 112.18 | 112.17 | 112.17 | 34250.0 |
| 2009-12-30 09:20:00 | SPY | ETF | 112.18 | 112.18 | 112.11 | 112.12 | 111349.0 |
| 2009-12-30 09:25:00 | SPY | ETF | 112.13 | 112.22 | 112.11 | 112.22 | 521065.0 |
| 2009-12-30 09:30:00 | SPY | ETF | 112.23 | 112.27 | 112.18 | 112.22 | 3320701.0 |
| 2009-12-30 09:35:00 | SPY | ETF | 112.23 | 112.3 | 112.17 | 112.3 | 1629811.0 |
| 2009-12-30 09:40:00 | SPY | ETF | 112.29 | 112.65 | 112.28 | 112.42 | 4263042.0 |
| 2009-12-30 09:45:00 | SPY | ETF | 112.42 | 112.55 | 112.37 | 112.4 | 2926816.0 |
| 2009-12-30 09:50:00 | SPY | ETF | 112.4012 | 112.54 | 112.4 | 112.53 | 1221351.0 |
| 2009-12-30 09:55:00 | SPY | ETF | 112.5325 | 112.63 | 112.52 | 112.54 | 1668057.0 |
| 2009-12-30 10:00:00 | SPY | ETF | 112.55 | 112.62 | 112.53 | 112.59 | 1357771.0 |
> showing 50 of 29,437 rows — these rows as CSV