PREVIEW / etf_5min / 2010-03-03
file: by_date/etf_5min/2010/2010-03-03.parquet size: 751 KB rows: 32,289
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-03-03 04:10:00 | SPY | ETF | 112.01 | 112.01 | 112.01 | 112.01 | 1000.0 |
| 2010-03-03 05:40:00 | SPY | ETF | 112.24 | 112.24 | 112.24 | 112.24 | 500.0 |
| 2010-03-03 06:10:00 | SPY | ETF | 112.25 | 112.25 | 112.25 | 112.25 | 2000.0 |
| 2010-03-03 06:15:00 | SPY | ETF | 112.26 | 112.26 | 112.26 | 112.26 | 116.0 |
| 2010-03-03 06:20:00 | SPY | ETF | 112.17 | 112.17 | 112.17 | 112.17 | 2500.0 |
| 2010-03-03 06:25:00 | SPY | ETF | 112.25 | 112.3 | 112.25 | 112.3 | 2600.0 |
| 2010-03-03 06:30:00 | SPY | ETF | 112.3 | 112.3 | 112.3 | 112.3 | 2000.0 |
| 2010-03-03 06:35:00 | SPY | ETF | 112.25 | 112.33 | 112.25 | 112.31 | 27684.0 |
| 2010-03-03 06:40:00 | SPY | ETF | 112.39 | 112.39 | 112.39 | 112.39 | 7700.0 |
| 2010-03-03 06:45:00 | SPY | ETF | 112.35 | 112.35 | 112.35 | 112.35 | 4000.0 |
| 2010-03-03 06:55:00 | SPY | ETF | 112.35 | 112.35 | 112.25 | 112.25 | 11500.0 |
| 2010-03-03 07:00:00 | SPY | ETF | 112.26 | 112.26 | 112.21 | 112.25 | 9500.0 |
| 2010-03-03 07:05:00 | SPY | ETF | 112.27 | 112.27 | 112.16 | 112.16 | 526600.0 |
| 2010-03-03 07:10:00 | SPY | ETF | 112.14 | 112.17 | 112.09 | 112.12 | 41390.0 |
| 2010-03-03 07:15:00 | SPY | ETF | 112.16 | 112.16 | 112.13 | 112.15 | 11800.0 |
| 2010-03-03 07:20:00 | SPY | ETF | 112.16 | 112.19 | 112.16 | 112.18 | 55100.0 |
| 2010-03-03 07:25:00 | SPY | ETF | 112.14 | 112.16 | 112.14 | 112.14 | 2400.0 |
| 2010-03-03 07:30:00 | SPY | ETF | 112.17 | 112.21 | 112.17 | 112.21 | 9635.0 |
| 2010-03-03 07:35:00 | SPY | ETF | 112.16 | 112.22 | 112.11 | 112.12 | 104181.0 |
| 2010-03-03 07:40:00 | SPY | ETF | 112.14 | 112.17 | 112.02 | 112.04 | 99885.0 |
| 2010-03-03 07:45:00 | SPY | ETF | 112.05 | 112.12 | 112.03 | 112.12 | 11600.0 |
| 2010-03-03 07:50:00 | SPY | ETF | 112.09 | 112.15 | 112.09 | 112.14 | 30850.0 |
| 2010-03-03 07:55:00 | SPY | ETF | 112.15 | 112.15 | 112.09 | 112.11 | 100000.0 |
| 2010-03-03 08:00:00 | SPY | ETF | 112.12 | 112.18 | 112.08 | 112.08 | 924570.0 |
| 2010-03-03 08:05:00 | SPY | ETF | 112.08 | 112.12 | 112.08 | 112.11 | 85005.0 |
| 2010-03-03 08:10:00 | SPY | ETF | 112.11 | 112.13 | 112.03 | 112.04 | 55150.0 |
| 2010-03-03 08:15:00 | SPY | ETF | 112.05 | 112.25 | 112.03 | 112.25 | 724634.0 |
| 2010-03-03 08:20:00 | SPY | ETF | 112.1 | 112.28 | 112.1 | 112.26 | 549251.0 |
| 2010-03-03 08:25:00 | SPY | ETF | 112.26 | 112.32 | 112.25 | 112.32 | 95163.0 |
| 2010-03-03 08:30:00 | SPY | ETF | 112.32 | 112.38 | 112.29 | 112.29 | 128397.0 |
| 2010-03-03 08:35:00 | SPY | ETF | 112.28 | 112.34 | 112.27 | 112.3 | 100717.0 |
| 2010-03-03 08:40:00 | SPY | ETF | 112.31 | 112.34 | 112.28 | 112.33 | 70764.0 |
| 2010-03-03 08:45:00 | SPY | ETF | 112.33 | 112.34 | 112.31 | 112.33 | 33585.0 |
| 2010-03-03 08:50:00 | SPY | ETF | 112.32 | 112.44 | 112.31 | 112.43 | 120469.0 |
| 2010-03-03 08:55:00 | SPY | ETF | 112.44 | 112.53 | 112.41 | 112.42 | 452142.0 |
| 2010-03-03 09:00:00 | SPY | ETF | 112.43 | 112.52 | 112.4 | 112.45 | 230311.0 |
| 2010-03-03 09:05:00 | SPY | ETF | 112.45 | 112.49 | 112.39 | 112.4 | 188985.0 |
| 2010-03-03 09:10:00 | SPY | ETF | 112.4 | 112.45 | 112.4 | 112.44 | 63425.0 |
| 2010-03-03 09:15:00 | SPY | ETF | 112.44 | 112.46 | 112.41 | 112.43 | 57316.0 |
| 2010-03-03 09:20:00 | SPY | ETF | 112.44 | 112.48 | 112.44 | 112.47 | 54161.0 |
| 2010-03-03 09:25:00 | SPY | ETF | 112.47 | 112.5 | 112.46 | 112.49 | 115660.0 |
| 2010-03-03 09:30:00 | SPY | ETF | 112.49 | 112.52 | 112.37 | 112.43 | 2688154.0 |
| 2010-03-03 09:35:00 | SPY | ETF | 112.44 | 112.44 | 112.31 | 112.39 | 2253200.0 |
| 2010-03-03 09:40:00 | SPY | ETF | 112.399 | 112.42 | 112.3 | 112.42 | 2242452.0 |
| 2010-03-03 09:45:00 | SPY | ETF | 112.4101 | 112.62 | 112.35 | 112.58 | 3279677.0 |
| 2010-03-03 09:50:00 | SPY | ETF | 112.57 | 112.74 | 112.56 | 112.6599 | 2228998.0 |
| 2010-03-03 09:55:00 | SPY | ETF | 112.6501 | 112.69 | 112.59 | 112.63 | 1329465.0 |
| 2010-03-03 10:00:00 | SPY | ETF | 112.64 | 112.8 | 112.55 | 112.57 | 5428364.0 |
| 2010-03-03 10:05:00 | SPY | ETF | 112.57 | 112.64 | 112.55 | 112.55 | 2307837.0 |
| 2010-03-03 10:10:00 | SPY | ETF | 112.55 | 112.6 | 112.5 | 112.58 | 2825161.0 |
> showing 50 of 32,289 rows — these rows as CSV