PREVIEW / etf_5min / 2009-11-04
file: by_date/etf_5min/2009/2009-11-04.parquet size: 748 KB rows: 31,773
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-11-04 04:15:00 | SPY | ETF | 105.22 | 105.27 | 105.21 | 105.27 | 1310.0 |
| 2009-11-04 04:25:00 | SPY | ETF | 105.25 | 105.25 | 105.25 | 105.25 | 100.0 |
| 2009-11-04 04:30:00 | SPY | ETF | 105.29 | 105.29 | 105.29 | 105.29 | 200.0 |
| 2009-11-04 04:50:00 | SPY | ETF | 105.32 | 105.32 | 105.32 | 105.32 | 100.0 |
| 2009-11-04 04:55:00 | SPY | ETF | 105.33 | 105.33 | 105.33 | 105.33 | 100.0 |
| 2009-11-04 05:00:00 | SPY | ETF | 105.32 | 105.35 | 105.32 | 105.35 | 1300.0 |
| 2009-11-04 05:05:00 | SPY | ETF | 105.31 | 105.31 | 105.31 | 105.31 | 300.0 |
| 2009-11-04 05:20:00 | SPY | ETF | 105.32 | 105.32 | 105.32 | 105.32 | 100.0 |
| 2009-11-04 05:40:00 | SPY | ETF | 105.37 | 105.37 | 105.37 | 105.37 | 100.0 |
| 2009-11-04 05:50:00 | SPY | ETF | 105.31 | 105.33 | 105.31 | 105.33 | 700.0 |
| 2009-11-04 06:00:00 | SPY | ETF | 105.27 | 105.27 | 105.27 | 105.27 | 1000.0 |
| 2009-11-04 06:10:00 | SPY | ETF | 105.28 | 105.28 | 105.28 | 105.28 | 100.0 |
| 2009-11-04 06:15:00 | SPY | ETF | 105.3 | 105.34 | 105.3 | 105.34 | 3200.0 |
| 2009-11-04 06:20:00 | SPY | ETF | 105.34 | 105.34 | 105.34 | 105.34 | 400.0 |
| 2009-11-04 06:30:00 | SPY | ETF | 105.28 | 105.31 | 105.28 | 105.31 | 400.0 |
| 2009-11-04 06:35:00 | SPY | ETF | 105.31 | 105.31 | 105.31 | 105.31 | 100.0 |
| 2009-11-04 06:45:00 | SPY | ETF | 105.29 | 105.29 | 105.29 | 105.29 | 200.0 |
| 2009-11-04 06:55:00 | SPY | ETF | 105.34 | 105.36 | 105.34 | 105.36 | 400.0 |
| 2009-11-04 07:00:00 | SPY | ETF | 105.34 | 105.38 | 105.34 | 105.38 | 42580.0 |
| 2009-11-04 07:05:00 | SPY | ETF | 105.37 | 105.37 | 105.34 | 105.34 | 35970.0 |
| 2009-11-04 07:10:00 | SPY | ETF | 105.35 | 105.38 | 105.3 | 105.3 | 17480.0 |
| 2009-11-04 07:15:00 | SPY | ETF | 105.32 | 105.32 | 105.22 | 105.22 | 15820.0 |
| 2009-11-04 07:20:00 | SPY | ETF | 105.2 | 105.2 | 105.14 | 105.15 | 14812.0 |
| 2009-11-04 07:25:00 | SPY | ETF | 105.18 | 105.23 | 105.15 | 105.2 | 18876.0 |
| 2009-11-04 07:30:00 | SPY | ETF | 105.22 | 105.23 | 105.17 | 105.21 | 16747.0 |
| 2009-11-04 07:35:00 | SPY | ETF | 105.19 | 105.2 | 105.13 | 105.17 | 13670.0 |
| 2009-11-04 07:40:00 | SPY | ETF | 105.17 | 105.18 | 105.16 | 105.16 | 4100.0 |
| 2009-11-04 07:45:00 | SPY | ETF | 105.18 | 105.18 | 105.12 | 105.12 | 13861.0 |
| 2009-11-04 07:50:00 | SPY | ETF | 105.16 | 105.18 | 105.14 | 105.15 | 31700.0 |
| 2009-11-04 07:55:00 | SPY | ETF | 105.18 | 105.21 | 105.15 | 105.2 | 111912.0 |
| 2009-11-04 08:00:00 | SPY | ETF | 105.19 | 105.21 | 105.15 | 105.18 | 51400.0 |
| 2009-11-04 08:05:00 | SPY | ETF | 105.18 | 105.28 | 105.18 | 105.26 | 130064.0 |
| 2009-11-04 08:10:00 | SPY | ETF | 105.26 | 105.37 | 104.53 | 105.36 | 254459.0 |
| 2009-11-04 08:15:00 | SPY | ETF | 105.35 | 105.36 | 105.0 | 105.24 | 658762.0 |
| 2009-11-04 08:20:00 | SPY | ETF | 105.24 | 105.28 | 105.2 | 105.25 | 201599.0 |
| 2009-11-04 08:25:00 | SPY | ETF | 105.26 | 105.38 | 105.26 | 105.36 | 323417.0 |
| 2009-11-04 08:30:00 | SPY | ETF | 105.37 | 105.46 | 104.65 | 105.46 | 291539.0 |
| 2009-11-04 08:35:00 | SPY | ETF | 105.46 | 105.62 | 105.43 | 105.54 | 383330.0 |
| 2009-11-04 08:40:00 | SPY | ETF | 105.54 | 105.55 | 105.52 | 105.53 | 91083.0 |
| 2009-11-04 08:45:00 | SPY | ETF | 105.52 | 105.52 | 105.48 | 105.49 | 149772.0 |
| 2009-11-04 08:50:00 | SPY | ETF | 105.48 | 105.51 | 105.45 | 105.46 | 243971.0 |
| 2009-11-04 08:55:00 | SPY | ETF | 105.46 | 105.49 | 105.45 | 105.47 | 190619.0 |
| 2009-11-04 09:00:00 | SPY | ETF | 105.47 | 105.54 | 105.45 | 105.53 | 307714.0 |
| 2009-11-04 09:05:00 | SPY | ETF | 105.52 | 105.63 | 105.51 | 105.6 | 922311.0 |
| 2009-11-04 09:10:00 | SPY | ETF | 105.61 | 105.64 | 105.54 | 105.54 | 248172.0 |
| 2009-11-04 09:15:00 | SPY | ETF | 105.54 | 105.6 | 105.52 | 105.53 | 186688.0 |
| 2009-11-04 09:20:00 | SPY | ETF | 105.52 | 105.56 | 105.5 | 105.53 | 216935.0 |
| 2009-11-04 09:25:00 | SPY | ETF | 105.52 | 105.56 | 105.48 | 105.5 | 548811.0 |
| 2009-11-04 09:30:00 | SPY | ETF | 105.51 | 105.72 | 105.44 | 105.51 | 5423081.0 |
| 2009-11-04 09:35:00 | SPY | ETF | 105.52 | 105.54 | 105.41 | 105.43 | 3765650.0 |
> showing 50 of 31,773 rows — these rows as CSV