PREVIEW / etf_5min / 2013-11-29
file: by_date/etf_5min/2013/2013-11-29.parquet size: 575 KB rows: 23,648
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-29 04:00:00 | SPY | ETF | 181.25 | 181.25 | 181.25 | 181.25 | 100.0 |
| 2013-11-29 04:35:00 | SPY | ETF | 180.94 | 181.31 | 180.92 | 181.31 | 1400.0 |
| 2013-11-29 04:45:00 | SPY | ETF | 181.3 | 181.3 | 181.3 | 181.3 | 250.0 |
| 2013-11-29 04:50:00 | SPY | ETF | 181.33 | 181.33 | 181.33 | 181.33 | 190.0 |
| 2013-11-29 05:00:00 | SPY | ETF | 181.28 | 181.28 | 181.28 | 181.28 | 200.0 |
| 2013-11-29 05:25:00 | SPY | ETF | 181.3 | 181.3 | 181.3 | 181.3 | 400.0 |
| 2013-11-29 05:40:00 | SPY | ETF | 181.28 | 181.28 | 181.28 | 181.28 | 200.0 |
| 2013-11-29 05:50:00 | SPY | ETF | 181.28 | 181.3 | 181.28 | 181.28 | 300.0 |
| 2013-11-29 06:00:00 | SPY | ETF | 181.28 | 181.28 | 181.28 | 181.28 | 100.0 |
| 2013-11-29 06:15:00 | SPY | ETF | 181.27 | 181.27 | 181.27 | 181.27 | 349.0 |
| 2013-11-29 06:25:00 | SPY | ETF | 181.27 | 181.27 | 181.25 | 181.25 | 488.0 |
| 2013-11-29 06:30:00 | SPY | ETF | 181.27 | 181.27 | 181.22 | 181.22 | 200.0 |
| 2013-11-29 06:40:00 | SPY | ETF | 181.22 | 181.25 | 181.22 | 181.25 | 812.0 |
| 2013-11-29 06:50:00 | SPY | ETF | 181.31 | 181.33 | 181.31 | 181.33 | 1200.0 |
| 2013-11-29 06:55:00 | SPY | ETF | 181.35 | 181.35 | 181.35 | 181.35 | 200.0 |
| 2013-11-29 07:00:00 | SPY | ETF | 181.33 | 181.33 | 181.3 | 181.3 | 1746.0 |
| 2013-11-29 07:10:00 | SPY | ETF | 181.33 | 181.37 | 181.33 | 181.37 | 650.0 |
| 2013-11-29 07:15:00 | SPY | ETF | 181.38 | 181.4 | 181.38 | 181.4 | 40835.0 |
| 2013-11-29 07:20:00 | SPY | ETF | 181.4 | 181.42 | 181.35 | 181.35 | 24712.0 |
| 2013-11-29 07:25:00 | SPY | ETF | 181.34 | 181.36 | 181.32 | 181.33 | 14090.0 |
| 2013-11-29 07:30:00 | SPY | ETF | 181.34 | 181.37 | 181.34 | 181.37 | 1600.0 |
| 2013-11-29 07:35:00 | SPY | ETF | 181.35 | 181.35 | 181.35 | 181.35 | 500.0 |
| 2013-11-29 07:40:00 | SPY | ETF | 181.36 | 181.41 | 181.35 | 181.39 | 17500.0 |
| 2013-11-29 07:45:00 | SPY | ETF | 181.4 | 181.41 | 181.4 | 181.41 | 2500.0 |
| 2013-11-29 07:50:00 | SPY | ETF | 181.37 | 181.37 | 181.35 | 181.35 | 885.0 |
| 2013-11-29 07:55:00 | SPY | ETF | 181.37 | 181.4 | 181.37 | 181.38 | 10423.0 |
| 2013-11-29 08:00:00 | SPY | ETF | 181.37 | 181.37 | 181.33 | 181.33 | 33580.0 |
| 2013-11-29 08:05:00 | SPY | ETF | 181.35 | 181.38 | 181.1217 | 181.37 | 540391.0 |
| 2013-11-29 08:10:00 | SPY | ETF | 181.38 | 181.38 | 181.35 | 181.35 | 3600.0 |
| 2013-11-29 08:15:00 | SPY | ETF | 181.35 | 181.37 | 181.33 | 181.35 | 2750.0 |
| 2013-11-29 08:20:00 | SPY | ETF | 181.35 | 181.36 | 181.34 | 181.34 | 12112.0 |
| 2013-11-29 08:25:00 | SPY | ETF | 181.34 | 181.37 | 181.31 | 181.32 | 15687.0 |
| 2013-11-29 08:30:00 | SPY | ETF | 181.34 | 181.34 | 181.31 | 181.32 | 3750.0 |
| 2013-11-29 08:35:00 | SPY | ETF | 181.31 | 181.33 | 181.31 | 181.31 | 6400.0 |
| 2013-11-29 08:40:00 | SPY | ETF | 181.3 | 181.3 | 181.27 | 181.29 | 19980.0 |
| 2013-11-29 08:45:00 | SPY | ETF | 181.3 | 181.31 | 181.27 | 181.28 | 24484.0 |
| 2013-11-29 08:50:00 | SPY | ETF | 181.29 | 181.31 | 181.27 | 181.28 | 15172.0 |
| 2013-11-29 08:55:00 | SPY | ETF | 181.28 | 181.31 | 181.28 | 181.3 | 20979.0 |
| 2013-11-29 09:00:00 | SPY | ETF | 181.29 | 181.31 | 181.28 | 181.3 | 17582.0 |
| 2013-11-29 09:05:00 | SPY | ETF | 181.3 | 181.33 | 181.28 | 181.31 | 25369.0 |
| 2013-11-29 09:10:00 | SPY | ETF | 181.31 | 181.31 | 181.25 | 181.27 | 10492.0 |
| 2013-11-29 09:15:00 | SPY | ETF | 181.28 | 181.31 | 181.26 | 181.31 | 7972.0 |
| 2013-11-29 09:20:00 | SPY | ETF | 181.3 | 181.36 | 181.28 | 181.31 | 43034.0 |
| 2013-11-29 09:25:00 | SPY | ETF | 181.31 | 181.36 | 181.3 | 181.32 | 87827.0 |
| 2013-11-29 09:30:00 | SPY | ETF | 181.32 | 181.38 | 181.21 | 181.35 | 2045125.0 |
| 2013-11-29 09:35:00 | SPY | ETF | 181.36 | 181.52 | 181.35 | 181.45 | 1141195.0 |
| 2013-11-29 09:40:00 | SPY | ETF | 181.46 | 181.54 | 181.45 | 181.499 | 1248818.0 |
| 2013-11-29 09:45:00 | SPY | ETF | 181.4901 | 181.51 | 181.36 | 181.5 | 958534.0 |
| 2013-11-29 09:50:00 | SPY | ETF | 181.499 | 181.59 | 181.445 | 181.55 | 651935.0 |
| 2013-11-29 09:55:00 | SPY | ETF | 181.555 | 181.58 | 181.5 | 181.56 | 843921.0 |
> showing 50 of 23,648 rows — these rows as CSV