PREVIEW / etf_5min / 2012-05-14
file: by_date/etf_5min/2012/2012-05-14.parquet size: 917 KB rows: 38,684
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-14 04:00:00 | SPY | ETF | 134.61 | 134.71 | 134.61 | 134.71 | 2987.0 |
| 2012-05-14 04:05:00 | SPY | ETF | 134.75 | 134.75 | 134.75 | 134.75 | 200.0 |
| 2012-05-14 04:15:00 | SPY | ETF | 134.68 | 134.68 | 134.35 | 134.35 | 9148.0 |
| 2012-05-14 04:20:00 | SPY | ETF | 134.35 | 134.35 | 134.31 | 134.31 | 1400.0 |
| 2012-05-14 04:25:00 | SPY | ETF | 134.34 | 134.34 | 134.3 | 134.31 | 1650.0 |
| 2012-05-14 04:30:00 | SPY | ETF | 134.32 | 134.32 | 134.32 | 134.32 | 500.0 |
| 2012-05-14 04:35:00 | SPY | ETF | 134.31 | 134.31 | 134.28 | 134.28 | 2300.0 |
| 2012-05-14 04:55:00 | SPY | ETF | 134.29 | 134.29 | 134.29 | 134.29 | 200.0 |
| 2012-05-14 05:00:00 | SPY | ETF | 134.28 | 134.38 | 134.28 | 134.38 | 775.0 |
| 2012-05-14 05:05:00 | SPY | ETF | 134.49 | 134.49 | 134.49 | 134.49 | 400.0 |
| 2012-05-14 05:15:00 | SPY | ETF | 134.57 | 134.57 | 134.57 | 134.57 | 120.0 |
| 2012-05-14 05:20:00 | SPY | ETF | 134.57 | 134.57 | 134.57 | 134.57 | 800.0 |
| 2012-05-14 05:25:00 | SPY | ETF | 134.55 | 134.55 | 134.55 | 134.55 | 200.0 |
| 2012-05-14 05:30:00 | SPY | ETF | 134.55 | 134.55 | 134.54 | 134.54 | 10000.0 |
| 2012-05-14 05:35:00 | SPY | ETF | 134.42 | 134.42 | 134.42 | 134.42 | 100.0 |
| 2012-05-14 05:45:00 | SPY | ETF | 134.39 | 134.45 | 134.39 | 134.45 | 30100.0 |
| 2012-05-14 05:50:00 | SPY | ETF | 134.51 | 134.54 | 134.51 | 134.54 | 5100.0 |
| 2012-05-14 06:00:00 | SPY | ETF | 134.51 | 134.52 | 134.51 | 134.52 | 3500.0 |
| 2012-05-14 06:05:00 | SPY | ETF | 134.45 | 134.45 | 134.44 | 134.44 | 11450.0 |
| 2012-05-14 06:10:00 | SPY | ETF | 134.38 | 134.38 | 134.37 | 134.37 | 500.0 |
| 2012-05-14 06:15:00 | SPY | ETF | 134.31 | 134.35 | 134.31 | 134.35 | 1100.0 |
| 2012-05-14 06:25:00 | SPY | ETF | 134.53 | 134.55 | 134.5 | 134.5 | 4100.0 |
| 2012-05-14 06:30:00 | SPY | ETF | 134.54 | 134.54 | 134.41 | 134.42 | 1400.0 |
| 2012-05-14 06:40:00 | SPY | ETF | 134.39 | 134.39 | 134.35 | 134.37 | 17000.0 |
| 2012-05-14 06:45:00 | SPY | ETF | 134.37 | 134.37 | 134.31 | 134.36 | 8600.0 |
| 2012-05-14 06:50:00 | SPY | ETF | 134.37 | 134.37 | 134.3 | 134.3 | 2700.0 |
| 2012-05-14 06:55:00 | SPY | ETF | 134.29 | 134.3 | 134.27 | 134.27 | 28950.0 |
| 2012-05-14 07:00:00 | SPY | ETF | 134.24 | 134.28 | 134.15 | 134.28 | 45470.0 |
| 2012-05-14 07:05:00 | SPY | ETF | 134.32 | 134.42 | 134.26 | 134.41 | 123753.0 |
| 2012-05-14 07:10:00 | SPY | ETF | 134.45 | 134.48 | 134.43 | 134.45 | 34700.0 |
| 2012-05-14 07:15:00 | SPY | ETF | 134.45 | 134.45 | 134.41 | 134.42 | 41340.0 |
| 2012-05-14 07:20:00 | SPY | ETF | 134.43 | 134.5 | 134.43 | 134.45 | 32000.0 |
| 2012-05-14 07:25:00 | SPY | ETF | 134.5 | 134.5 | 134.42 | 134.5 | 54350.0 |
| 2012-05-14 07:30:00 | SPY | ETF | 134.5 | 134.5 | 134.41 | 134.41 | 27600.0 |
| 2012-05-14 07:35:00 | SPY | ETF | 134.41 | 134.56 | 134.4 | 134.56 | 49860.0 |
| 2012-05-14 07:40:00 | SPY | ETF | 134.56 | 134.59 | 134.48 | 134.48 | 78256.0 |
| 2012-05-14 07:45:00 | SPY | ETF | 134.48 | 134.52 | 134.45 | 134.52 | 69174.0 |
| 2012-05-14 07:50:00 | SPY | ETF | 134.52 | 134.52 | 134.4 | 134.48 | 36300.0 |
| 2012-05-14 07:55:00 | SPY | ETF | 134.49 | 134.53 | 134.49 | 134.5 | 27533.0 |
| 2012-05-14 08:00:00 | SPY | ETF | 134.53 | 134.917 | 134.47 | 134.5 | 195995.0 |
| 2012-05-14 08:05:00 | SPY | ETF | 134.49 | 134.62 | 134.49 | 134.59 | 53155.0 |
| 2012-05-14 08:10:00 | SPY | ETF | 134.59 | 134.6 | 134.54 | 134.6 | 19600.0 |
| 2012-05-14 08:15:00 | SPY | ETF | 134.57 | 134.57 | 134.43 | 134.47 | 105780.0 |
| 2012-05-14 08:20:00 | SPY | ETF | 134.49 | 135.17 | 134.32 | 134.42 | 121182.0 |
| 2012-05-14 08:25:00 | SPY | ETF | 134.41 | 134.54 | 134.38 | 134.42 | 136439.0 |
| 2012-05-14 08:30:00 | SPY | ETF | 134.42 | 134.43 | 134.26 | 134.27 | 130575.0 |
| 2012-05-14 08:35:00 | SPY | ETF | 134.28 | 134.35 | 134.25 | 134.28 | 73417.0 |
| 2012-05-14 08:40:00 | SPY | ETF | 134.3 | 134.42 | 134.29 | 134.42 | 158666.0 |
| 2012-05-14 08:45:00 | SPY | ETF | 134.42 | 134.44 | 134.37 | 134.37 | 92193.0 |
| 2012-05-14 08:50:00 | SPY | ETF | 134.41 | 134.42 | 134.37 | 134.39 | 29450.0 |
> showing 50 of 38,684 rows — these rows as CSV