PREVIEW / etf_5min / 2010-02-02
file: by_date/etf_5min/2010/2010-02-02.parquet size: 776 KB rows: 32,825
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-02-02 04:15:00 | SPY | ETF | 108.93 | 108.93 | 108.87 | 108.87 | 1400.0 |
| 2010-02-02 04:20:00 | SPY | ETF | 109.08 | 109.08 | 109.08 | 109.08 | 100.0 |
| 2010-02-02 04:40:00 | SPY | ETF | 109.13 | 109.13 | 109.13 | 109.13 | 200.0 |
| 2010-02-02 04:55:00 | SPY | ETF | 109.18 | 109.22 | 109.18 | 109.22 | 600.0 |
| 2010-02-02 05:00:00 | SPY | ETF | 109.24 | 109.43 | 109.24 | 109.43 | 3900.0 |
| 2010-02-02 05:10:00 | SPY | ETF | 109.4 | 109.42 | 109.4 | 109.42 | 600.0 |
| 2010-02-02 05:15:00 | SPY | ETF | 109.44 | 109.5 | 109.44 | 109.5 | 900.0 |
| 2010-02-02 05:20:00 | SPY | ETF | 109.52 | 109.52 | 109.52 | 109.52 | 200.0 |
| 2010-02-02 05:25:00 | SPY | ETF | 109.44 | 109.44 | 109.44 | 109.44 | 100.0 |
| 2010-02-02 05:30:00 | SPY | ETF | 109.54 | 109.61 | 109.54 | 109.61 | 1000.0 |
| 2010-02-02 06:00:00 | SPY | ETF | 109.53 | 109.53 | 109.53 | 109.53 | 15000.0 |
| 2010-02-02 06:10:00 | SPY | ETF | 109.37 | 109.4 | 109.36 | 109.36 | 3050.0 |
| 2010-02-02 06:15:00 | SPY | ETF | 109.32 | 109.32 | 109.32 | 109.32 | 2000.0 |
| 2010-02-02 06:20:00 | SPY | ETF | 109.34 | 109.35 | 109.34 | 109.35 | 2000.0 |
| 2010-02-02 06:30:00 | SPY | ETF | 109.44 | 109.48 | 109.41 | 109.48 | 17600.0 |
| 2010-02-02 06:35:00 | SPY | ETF | 109.47 | 109.5 | 109.47 | 109.5 | 5000.0 |
| 2010-02-02 06:45:00 | SPY | ETF | 109.38 | 109.38 | 109.37 | 109.37 | 750.0 |
| 2010-02-02 06:50:00 | SPY | ETF | 109.35 | 109.4 | 109.3 | 109.35 | 9600.0 |
| 2010-02-02 06:55:00 | SPY | ETF | 109.31 | 109.38 | 109.31 | 109.34 | 3100.0 |
| 2010-02-02 07:00:00 | SPY | ETF | 109.34 | 109.37 | 109.33 | 109.35 | 3500.0 |
| 2010-02-02 07:05:00 | SPY | ETF | 109.36 | 109.4 | 109.36 | 109.36 | 10106.0 |
| 2010-02-02 07:10:00 | SPY | ETF | 109.38 | 109.42 | 109.38 | 109.42 | 1000.0 |
| 2010-02-02 07:15:00 | SPY | ETF | 109.42 | 109.42 | 109.34 | 109.36 | 18704.0 |
| 2010-02-02 07:20:00 | SPY | ETF | 109.36 | 109.4 | 109.34 | 109.4 | 30804.0 |
| 2010-02-02 07:25:00 | SPY | ETF | 109.34 | 109.37 | 109.34 | 109.37 | 26885.0 |
| 2010-02-02 07:30:00 | SPY | ETF | 109.37 | 109.4 | 109.36 | 109.39 | 11910.0 |
| 2010-02-02 07:35:00 | SPY | ETF | 109.39 | 109.46 | 109.39 | 109.44 | 64400.0 |
| 2010-02-02 07:40:00 | SPY | ETF | 109.47 | 109.52 | 109.46 | 109.46 | 43630.0 |
| 2010-02-02 07:45:00 | SPY | ETF | 109.45 | 109.51 | 109.45 | 109.49 | 40800.0 |
| 2010-02-02 07:50:00 | SPY | ETF | 109.53 | 109.56 | 109.5 | 109.5 | 87150.0 |
| 2010-02-02 07:55:00 | SPY | ETF | 109.5 | 109.54 | 109.39 | 109.41 | 60705.0 |
| 2010-02-02 08:00:00 | SPY | ETF | 109.39 | 109.5 | 109.38 | 109.43 | 656313.0 |
| 2010-02-02 08:05:00 | SPY | ETF | 109.43 | 109.44 | 109.38 | 109.38 | 354484.0 |
| 2010-02-02 08:10:00 | SPY | ETF | 109.38 | 109.4 | 109.34 | 109.35 | 291362.0 |
| 2010-02-02 08:15:00 | SPY | ETF | 109.35 | 109.36 | 109.29 | 109.32 | 65260.0 |
| 2010-02-02 08:20:00 | SPY | ETF | 109.33 | 109.33 | 109.23 | 109.28 | 317012.0 |
| 2010-02-02 08:25:00 | SPY | ETF | 109.29 | 109.33 | 109.26 | 109.33 | 190923.0 |
| 2010-02-02 08:30:00 | SPY | ETF | 109.32 | 109.34 | 109.3 | 109.32 | 69976.0 |
| 2010-02-02 08:35:00 | SPY | ETF | 109.32 | 109.32 | 109.27 | 109.28 | 194824.0 |
| 2010-02-02 08:40:00 | SPY | ETF | 109.28 | 109.3 | 109.26 | 109.27 | 183992.0 |
| 2010-02-02 08:45:00 | SPY | ETF | 109.26 | 109.29 | 109.23 | 109.23 | 243517.0 |
| 2010-02-02 08:50:00 | SPY | ETF | 109.23 | 109.24 | 109.16 | 109.21 | 299411.0 |
| 2010-02-02 08:55:00 | SPY | ETF | 109.2 | 109.21 | 109.11 | 109.17 | 572822.0 |
| 2010-02-02 09:00:00 | SPY | ETF | 109.15 | 109.25 | 109.13 | 109.21 | 416918.0 |
| 2010-02-02 09:05:00 | SPY | ETF | 109.21 | 109.27 | 109.21 | 109.24 | 117509.0 |
| 2010-02-02 09:10:00 | SPY | ETF | 109.24 | 109.34 | 109.24 | 109.31 | 170713.0 |
| 2010-02-02 09:15:00 | SPY | ETF | 109.32 | 109.38 | 109.28 | 109.29 | 115557.0 |
| 2010-02-02 09:20:00 | SPY | ETF | 109.3 | 109.32 | 109.27 | 109.29 | 186703.0 |
| 2010-02-02 09:25:00 | SPY | ETF | 109.29 | 109.34 | 109.26 | 109.27 | 652010.0 |
| 2010-02-02 09:30:00 | SPY | ETF | 109.26 | 109.3 | 109.03 | 109.09 | 4095493.0 |
> showing 50 of 32,825 rows — these rows as CSV